Ask Your Question
0

How do you use a roundup() formula in Writer?

asked 2016-07-18 03:59:08 +0200

Xaelvaen gravatar image

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.

edit retag flag offensive close merge delete

Comments

1

Roundup(value) can be emulated in Writer by "=(value + 0.5) ROUND 0".

floris v gravatar imagefloris v ( 2016-07-18 12:07:10 +0200 )edit

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.

mark_t gravatar imagemark_t ( 2016-07-18 15:23:55 +0200 )edit

Lol, yes, that's true.

floris v gravatar imagefloris v ( 2016-07-18 15:31:21 +0200 )edit

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.

Xaelvaen gravatar imageXaelvaen ( 2016-07-18 17:30:28 +0200 )edit

I mixed that up with INT(X+0.5) if you didn't have a ROUND function. My bad.

floris v gravatar imagefloris v ( 2016-07-18 18:12:51 +0200 )edit

If you have an INT function in writer then use "=(-INT(-C5))", this does not change existing whole numbers.

mark_t gravatar imagemark_t ( 2016-07-18 19:16:42 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2016-07-21 01:13:54 +0200

Xaelvaen gravatar image

updated 2016-07-21 01:19:11 +0200

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.

edit flag offensive delete link more
0

answered 2016-07-19 00:11:45 +0200

floris v gravatar image

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.

edit flag offensive delete link more
0

answered 2018-02-07 21:01:51 +0200

xormar gravatar image

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
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-07-18 03:59:08 +0200

Seen: 495 times

Last updated: Feb 07 '18