Monday, November 18, 2019

Automatic row numbering in the Writer tables

Often we have a Writer table with some numbering in its first column. And when you delete some rows from the table, then you should to make your numbering in first column anew.
There is a beautiful method for that case special for you! After that you shouldn't re-create your numbering in the table.
Just make next steps:
1. Create a table in Writer
2. Select needed column or several cells in column
3. Press Toggle Numbered List icon on toolbar (or select some list style on the Sidebar)
4. Now you have AUTOMATIC numbering of table rows!
For example, you created a numbering for 10 rows. Try delete 5th and 6th row. Your numbering is updated automatic and you have numbering from 1 to 8. And if you insert two row between existing rows with numbering, then you'll get numbering from 1 to 10 automatic also.
You can disable that numbering using the same way as when you created it. Just select cells with numbering and press Toggle Numbered List icon.
The same Russian post is here.

Sunday, November 17, 2019

LibreOffice 6.4 beta 1 is available

LibreOffice 6.4 beta 1 is available for downloading now. There are builds for all main OS for 64 bit. There is a 32 bit build for Windows also.
These builds are only for testing.
Links for downloading below:
Source code
Description of fixed bugs in LibreOffice 6.4 beta 1 compare with LibreOffice 6.4 alpha 1 is by link.
If you found a bug in LibreOffice 6.4 beta 1, then please file a bug reprort in our Bugzilla.

Tuesday, November 12, 2019

Calculations inside of Writer tables

Possibly, not all people know it can to make calculations inside Writer tables like in the Calc. But there are only 25 functions for use inside Writer tables, but Calc has over 400 functions.
To start use functions inside Writer tables you should left click into cell and then press key F2 or "=" on keyboard, or use "Formula" icon on Table toolbar. It shows a Formula bar like in the Calc.
There are Cell address field, Functions drop-down list, Cancel button, Apply button, Formula field on that bar.
Note, links to cells in Writer tables look as <A1> or <B3>. Cell ranges look as <A1:A10> or <A1:D12>.
After the Formula bar appeared you can select functions from drop-down list or can write a formula manually inside the Formula field after equal sign at once.
You can make calculates not only inside one Writer table. You can use values from many tables inside one Writer document. Use link to cell with table name like <Table2.A1>.
Attention! If you made in your formula a link to cell from another table and then changed that table's name, then you'll see an error in the cell like "** Expression is faulty **"! So, you should rename all your tables before you start create formulas inside these tables.
MS Word allows calculations in its native table too. But there are some differences between MS Word and LO Writer in that case.
First - difference between functions sets:

Writer table`s functions
Word table`s functions
SUM
SUM
ROUND
ROUND
PERCENT -
SQUARE ROOT -
POWER -
LIST SEPARATOR -
EQUAL -
NOT EQUAL -
LESS THAN OR EQUAL -
GREATER THAN OR EQUAL -
LESS -
GREATER -
BOOLEAN OR
OR
BOOLEAN XOR -
BOOLEAN AND
AND
BOOLEAN NOT
NOT
MEAN
AVERAGE
MINIMUM
MIN
MAXIMUM
MAX
SINE -
COSINE -
TANGENT -
ARCSINE -
ARCCOSINE -
ARCTANGENT -
-
COUNT
-
ABS
-
DEFINED
-
FALSE
-
IF
-
INT
-
MOD
-
PRODUCT
-
SIGN
-
TRUE

Second - in the Writer you type a formula into Formula bar like in the Calc, but in the MS Word you type a formula into the different dialog window.
Third - you can click on cells in the Writer tables when you create a formula, but in the MS Word you can't make it
Fourth - Writer can automatically recalculate result of formula when you change source values, but MS Word can't.
ps: if there is a formula inside a Writer table, then you'll never know about it wihout tooltip! Cell with formula looks like any another cell without formula in the table=(

Sunday, November 10, 2019

The best LibreOffice Extensions. Remove Duplicates Fast

There are many good extensions for LibreOffice. You can find it all on site https://extensions.libreoffice.org/. I want to tell you about the best from it.
So, there is an enhancement 85976 about adding of Remove Duplicates feature to LibreOffice Calc. That is really useful function and LibreOffice Calc isn't having it now.
However, there is Remove Duplicates Fast extension that adds need feature to Calc. It's a fork of another extension Remove Duplicates.
RDF allows you delete all row duplicates from selected range using values from one or more column. Just download it by link above, install and use it from Data menu.
Thanks to Mike Kaganski for great code writing.

Friday, November 8, 2019

Footnotes and Endnotes in LibreOffice Writer

It's translation of my Russian post about Footnotes and Endnotes to English.
What's Footnote? Wiki says us next:
A note is a string of text placed at the bottom of a page in a book or document or at the end of a chapter, volume or the whole text. The note can provide an author's comments on the main text or citations of a reference work in support of the text. Footnotes are notes at the foot of the page while endnotes are collected under a separate heading at the end of a chapter, volume, or entire work.
It looks in the text document so:
Note, the notes in the text are highlight by gray color. It made for help of users and will not be print on paper.
LibreOffice Writer can insert both types of notes: Footnotes and Endnotes.
On image above you see that footnotes places in bottom of page and endnotes places on latest page in the document. Page with endnotes is always latest page in the document. If you have last "empty" page in your document with even only one empty paragraph, then the endnotes page will be next page anyway.
Font size for footnotes and endnotes is smaller than basic font size in text body by default.
Use menu "Insert->Footnote and Endnote->Footnote" and "Insert->Footnote and Endnote->Endnote" to insert notes.
Notes have own options. You can find it in "Tools->Footnotes and Endnotes...". I think it needs to rename that item to something like "Foot/Endnotes settings".
The dialog has two tabs:
Here can set up numbering type, for Footnotes can to set up counting per page, per chapter or per document, can select paragraph ans symbol styles, etc.
Footnotes have else one place with some parameters. It's "Page style" dialog, "Footnote" tab:
Look at two options in Footnote area section. Its are responsible for footnotes area height on the page. If you select "Maximum footnote height" with small value and your footnote's text will be too long, then that text could be move to next page to its footnotes area. It may be unwanted. Also here you can customize Separator line between text body and footnotes area.
Next place with some parameters for notes is "Paragraph style" dialog for Footnote or Endnote. Select your Footnote (or Endnote), open Styles tab in the Sidebar, select Footnote (or Endnote) in the list of styles, right click and select "Modify":
Here you can change many options for text of footnotes.
Note, you can select any paragraph style for footnotes (or endnotes) text. Just for your convenience LibreOffice already has predefined styles. Footnote paragraph style is just style by default for footnotes.
Next thing that you'll want customize is note number view in the text body. Use options of Footnote (or Endnote) anchor symbol style. Find that style in the list of symbol styles in the Sidebar, right click on style name and select "Modify". Use "Font" and "Position" tabs in the dialog to customize view of note number.
Also Footnote text in bottom of the page has a number. If you want customize that number view, then use changing of "Footnote (or Endnote) characters" character style.
And, finally, there are pair of lifehacks for work with Footnotes and Endnotes in Writer text document.
First. Possibly you'll want to have two or more the same footnote number in the text body that will be link with only one footnote text in bottom of the page:
Make follow steps:
1. Insert first Footnote using menu "Insert->Footnote and Endnote->Footnote"
2. Second and all next the same number we'll be insert using dialog "Insert->Cross-reference...". In "Type" list select "Footnote", in "Insert reference to" list select "Reference, then press "Insert" button. You got link to the same footnote. But it looks like text body text. So...
3. Select your second footnote number in text body and apply to it "Footnote anchor" symbol style!
Second. Normally Endnotes place on latest page of the document. But there is a method for placing of Endnotes after end of text body at once.
1. Make sure you have all need Endnotes in the your document. 
2. Select all text using Ctrl+A.
3. Select menu "Insert->Section"
4. Go to Footnotes/Endnotes tab
5. Check "Collect at end of section" in Endnotes section
6. Press "Insert" button
Voila, we have Endnotes after text body at once.

Wednesday, November 6, 2019

New Table section was added to Writer Sidebar

Tamás Zolnai from Collabora added to Writer Sidebar new Table section. Now when you click inside a Writer table then you'll see in Sidebar new section with controls for handling of the table like "Add row", "Add column", etc.
It will be available in LibreOffice 6.4 that will be release in February 2020 year

Tuesday, November 5, 2019

Changing of cairo to skia inside LibreOffice

Developers of LibreOffice are making an experiment. They make changing of cairo to skia inside LibreOffice.
That change will be merge in to the master after branch of LibreOffice 6.4