Apache OpenOffice (AOO) Bugzilla – Issue 69842
Writer needs a rounddown operator
Last modified: 2013-02-07 22:42:56 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?
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. Regards, Andrew
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.
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 possible. Thanks again, Andrew
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?