Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

At 11:43 19/12/2013 -0800, Paul Whitehurst wrote:
In writer in a table I have numerical data entered in a column. I set the column to be right justified and the numeric format to currency. Occasionally I'll enter a number and it will not format correctly and will shift to the left. I can force it to right justify the cell contents, but I can't force it to apply currency numeric format. What am I doing wrong?

You may want to experiment with the options at Tools | Options... | LibreOffice Writer | Table | Input in tables. I don't claim to be an expert in exactly what these do, so I won't attempt to explain.

But there is one thing of which you should be aware. In some circumstances, any input that does not fit the applied format - in your case, Currency - will automatically reset the format of that cell alone to Text. Note that something as simple as completing an entry into a cell with Enter (instead of an arrow key or a mouse click) will render your entry no longer acceptable as Currency and have this effect. Interestingly, if you press Enter and then Backspace to correct yourself, the problem persists, but Enter followed by Edit | Undo (or Ctrl+Z) works without resetting the cell format. Note also that if you paste in a number from elsewhere, it is quite easy to bring along a trailing paragraph break, just as if you had pressed Enter, and this will likewise cause your problem

When you say that you "can't force it to apply currency numeric format", do you mean that reapplying the format has no effect? The only reason I can imagine for that would be that your entry cannot be interpreted as Currency: perhaps it contains a rogue character or has misplaced thousands separators, for example.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.