Ubuntu – How to autocomplete formulas in LibreOffice Calc

Simple Recalculation:

Recalculates all changed formulas. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW.

Choose Data - Calculate - Recalculate

F9

Press F9 to recalculate. Press Shift+Ctrl+F9 to recalculate all formulas in the document.

After the document has been recalculated, the display is refreshed. All charts are also refreshed.

The Add-In functions like RANDBETWEEN currently cannot respond to the Recalculate command or F9. Press Shift+Ctrl+F9 to recalculate all formulas, including the Add-In functions.

Source: http://help.libreoffice.org/Calc/Recalculate

References to Other Sheets and Referencing URLs or other external data

See source: http://help.libreoffice.org/Calc/References_to_Other_Sheets_and_Referencing_URLs*

For what I know, LibreOffice has no arbitrary precision numbers (decimal or integers). So if the number exceeds the range of a long integer it is stored as an IEEE754 number and so it has a limited precision.

So basically you can't do calculations with arbitrary precision in Calc, and if you want to read the long number as a number you will have it rounded off.

If you do not need to do calculations, use a string; put in your csv:

,
,
,12345678901234678901234567890
,"123456789012345678901234567890"

(notice the quotation marks) and then when reading it be sure to add "quoted field as text" and the correct text delimiter:

...and you have

Now --- if you touch, transform, eval the string --- you will have the rounding kicking in again.

Maybe you can use currency type which is a 64 bit integer, but as far as I know there is no way to force that via csv.