Re: [libreoffice-users] Currency format always gets lost/screwed up

On 05/10/2013 04:32 AM, Mathias Koerber wrote:
> I am using Libreoffice to write invoices.
>
> I have a table with several fields that need to be formatted
> as currency (SGD).
>
> I basically re-use an older document to save as a new one.
> Then I change the values.
>
> Most of the time one of the following happens:
>
> a) when I change just the numerical digits of the value,
>     the cell is no longer detected as numerical (and thus
>     counts as 0, detectable by the wrong sum in a SUM field
>     further down). It seems that it converts the old 'S$'
>     prefix found in the cell as text now.
>
> b) the 'S$' prefix gets lost and the value stands naked.
>
> Trying to correct this by selecting the value and
> applying
>         Table/Number format/selecting 'SGD' and
>    pressing ENTER often does nothing.
>
> Neither does selecting a different cell that still has the
> correct format applied, selecting the brush and trying
> to brush the format back into the cell that was screwed u.
>
> It takes me usually several minutes to clean out the cells
> and try to correct everything.
>
> It gets worse when I need to add or delete a row from the
> table and thus reapply the format to the new row or such.
>
> Is there no way to 'fix' the format for those cells, so that
> editing cannot screw up the format?
>
> Currency formatting in LO seems to be really broken :(
>
> I'm using
> Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)
> TinderBox: MacOSX TDF Release, Branch:libreoffice-4-0, Time:
> 2013-03-26_15:52:16
       Suggestion:
1) Open the document in Writer.
2) Format the cells that will contain currency amounts. (Right click 
such a cell. Select Number Format from the context
    menu. Select Currency in the Category list. In the Format list, 
select the format you want to use. Click OK.)
3) Save the document as a template (File > Save Templates).

     Now when you want to write an invoice, open this template, enter 
the data the invoice should have, and save the invoice.

--Dan

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted