Download /; Portable versions; Portable versions LibreOffice Portable. LibreOffice Portable is a full-featured portable version of LibreOffice for Windows – including a word processor, spreadsheet, presentation tool, drawing package and database – packaged as a portable app, so you can take all your documents and everything you need to work with them wherever you go. LibreOffice: free. software download for olderv versions of windows, osx, linux. Comparing Versions of a Document The review function is available in LibreOffice for text documents and spreadsheet documents. Imagine you have some co-authors or reviewers who collaborate with you writing your original document. One day you send out copies of your document to all reviewers. You ask them to edit the copy and send it back. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.
The review function is available in LibreOffice for text documents and spreadsheet documents.
Imagine you have some co-authors or reviewers who collaborate with you writing your original document. One day you send out copies of your document to all reviewers. You ask them to edit the copy and send it back.
Normally, the reviewers enable change tracking by Edit - Track Changes - Record and you can easily see the changes.
If one of the authors has made changes to a document without recording them, you can compare the changed document to your original document.
Open the reviewer's document and then choose Edit - Track Changes - Compare Document.
You should always start with opening the newer document and compare it with the older document.
A file selection dialog appears. Select your older original document and confirm the dialog.
LibreOffice combines both documents into the reviewer's document. All text passages that occur in the reviewer's document but not in the original are identified as having been inserted, and all text passages that got deleted by the reviewer are identified as deletions.
You can now accept or reject the insertions and deletions. At the end you may save the reviewer's document as a new original with a new name.
You can use the following operators in LibreOffice Calc:
Arithmetical Operators
These operators return numerical results.
Operator | Name | |
+ (Plus) | Addition | 1+1 |
- (Minus) | Subtraction | 2-1 |
- (Minus) | Negation | -5 |
* (asterisk) | Multiplication | 2*2 |
/ (Slash) | Division | 9/3 |
% (Percent) | Percent | 15% |
^ (Caret) | Exponentiation | 3^2 |
Comparative operators
These operators return either true or false.
Operator | Name | Example |
= (equal sign) | Equal | A1=B1 |
> (Greater than) | Greater than | A1>B1 |
< (Less than) | Less than | A1<B1 |
>= (Greater than or equal to) | Greater than or equal to | A1>=B1 |
<= (Less than or equal to) | Less than or equal to | A1<=B1 |
<> (Inequality) | Inequality | A1<>B1 |
Text operators
The operator combines separate texts into one text.
Operator | Name | |
& (And) | text concatenation AND | 'Sun' & 'day' is 'Sunday' |
Libreoffice Old Versions
Reference operators
These operators return a cell range of zero, one or more cells.
Range has the highest precedence, then intersection, and then finally union.
Operator | Name | Example |
: (Colon) | Range | A1:C108 |
! (Exclamation point) | Intersection | SUM(A1:B6!B5:C12) Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6. |
~ (Tilde) | Concatenation or union | Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice. See note below this table. |
Libreoffice Old Versions
Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.