I’m trying to create a table with a few complex calculations. I know all the formulas for ‘calc’, but alas, they do not function in Writer. The document I’m creating is predominantly text, I just need a few tables. I’d prefer to find a way to do it in the tables created on Writer and not import sheets from ‘calc’ so if there is a way to directly bring over the formulas, that would be preferable.
Roundup(value) can be emulated in Writer by “=(value + 0.5) ROUND 0”.
Would “=(value + 0.5) ROUND 0” not also round 1.0 to 2.0 etc. While Roundup of 1.0 should remain at 1.0.
I have not used formulas in writer, but in basic I have used “=(-INT(-C5))” when the roundup function is not available.
Lol, yes, that’s true.
Unfortunately that will not work, though I thank you for the response. A great deal of the numbers will naturally be whole numbers, so adding to the value will create rounding of numbers that are already whole.
I mixed that up with INT(X+0.5) if you didn’t have a ROUND function. My bad.
If you have an INT function in writer then use “=(-INT(-C5))”, this does not change existing whole numbers.
I don’t see a way to do that, the math functions available in Writer are rudimentary. The following isn’t even a workaround, it’s just a suggestion based on the idea that Calc is an advanced calculator and Writer is a tool to format text, so use both to your advantage.
You can do the calculations in Calc, then copy the data, in Writer do Paste special, as unformatted text, then convert the data to a table. Keep the Calc file with the Writer file.
It is seeming as though it isn’t quite possible to do it ‘easily’ so I took advantage of the ‘insert’ ability to add an OLE object to a writer page.
Step 1) Create the table I need in ‘Calc’ and save it as a separate file.
Step 2) In Writer, INSERT > OBJECT > OLE OBJECT
Step 3) Select CREATE FROM FILE with ‘Spreadsheet’ highlighted. In the field below, choose the file you saved in step 1.
Step 4) This imports the spreadsheet and attaches it to Writer, and you can even edit the spreadsheet using all the benefits of ‘Calc’ in your writer document.
A bit late, but you could implement =ROUNDUP(number; 0.05) like this:
=(number*20+0.0499)/20
=ROUNDDOWN(number; 0.05) then would become:
=(number*20-0.0501)/20