how to inhibit writer's calc rounding

[kengra]

I’m new to spreadsheets but being very fallible I’m trying to get calc to do some arithmetic. Try as I might I only get ** expression is faulty **, I have a lengthy document with multiple tables. I suspect that 1 or more of the following is the cause of my issues.

1. each table is within a frame to facilitate subsequent movement.
2. some cells have numeric data which is centered vertically within several merged cells.
3. trailing decimal zeroes are sometimes omitted. ie. must data be aligned on the decimal point?.
4. a topmost full width cell defines the table’s purpose.
5. some of the tables have captions.
6. the 3 column pages use my printer’s maximum vertical & horizontal capabilities.
7. some of the cell data is left, right, or centered.
8. some of the frames overlap the topmost line of the page with the date, page #, title/name of the document, revision date, etc…
9. most cells are narrowed to the minimum width of the largest (actually the longest or widest) input.
10. the font is liberation sans narrow.
11. LO 6.2.0.3
    12, some of the frames are adjacent or nearly so & present some wrapping issues.
    i’d appreciate any help you can provide.

(Slightly edditedd for better readability by @Lupp .)

[Lupp]

You cannot use a TextTable as a spreadsheet. The range of available arithmetic and functions is extremely restricted, the syntax is different, and everything is very unhandy.
I you need real spredsheet power included with a text document, you need to create a spreadsheet for linking into the text document the OLE way. However, thats unhandy in a different way. Nonetheless it’s sometimes recommendable.

(This is not a shortcoming of LibreOffice. It’s the result of the history of text processing software unfortunately ruled by a powerful commercial competitor.)