Issue 69842 - Writer needs a rounddown operator
Summary: Writer needs a rounddown operator
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-09-25 15:25 UTC by andrewbird
Modified: 2013-02-07 22:42 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description andrewbird 2006-09-25 15:25:48 UTC
I'm attempting to move my company's invoicing system to Openoffice from MS 
Word. In the UK, if you are VAT registered, you need to add 17.5% Value Added 
Tax on all goods you sell. Whilst it is easy to just multiply by 0.175 to find 
the amount, government guidelines say you must always round this down to the 
penny. I don't seem to be able to achieve this in writer, calc has rounddown 
and roundup functions for exactly this purpose. Would it be possible to 
implement these in writer please?
Comment 1 ace_dent 2006-09-25 19:57:21 UTC
In Writer, you can achieve more complex tables by embedding an OOo spreadsheet:
Insert > Object > OLE Object...

This provides the functionality that you describe. Is this sufficent? If not,
please advise on the enhancement you would like to see.

Comment 2 michael.ruess 2006-09-26 07:31:55 UTC
Yeah, a Spreadsheet OLE is a good workaround.
But it could also be a nice enhancement to have a rounddown function for
Writer's tables.
Comment 3 andrewbird 2006-09-26 11:17:14 UTC
Thanks for the info. I have now embedded a spreadsheet in my invoice, which 
gets around the lack of a rounddown operator. It does however make it a little 
messy to edit the table. I had envisaged having my secretary work with these 
docs, and with this in mind I wanted to make it as easy to work with as 
Thanks again, Andrew
Comment 4 andrewbird 2007-01-20 15:17:03 UTC
Hi, I'm really finding it hard without the rounddown operator in writer. I've
tried embedding a calc spreadsheet, but I find it too awkward to use. Now I'm a
fairly accomplished C/C++ programmer, so I'm thinking about adding the
functionality. Can anyone give me a few pointers about what parts of the
codebase will need altering?