Re: [gentoo-user] [OT] openoffice calc custom "accountancy" number format

[Philip Webb]

060109 Iain Buchanan wrote:
> you may know that M$Excel has a number format called "accounting" IIRC,
> that lines up the currency sign:
>   $    10.00
>   $   100.00
>   $  1000.00
>   $  -123.45
> Openoffice, as far as I've know it from 1.x to the current 2.x
> doesn't have such an option.  The formatting comes out like this:
>     $ 10.00
>    $ 100.00
>   $ 1000.00
>   $ -123.45
>
> For a large spreadsheet, with lots of number,
> the aligned "$" is much easier to read.

I realise this is not what you are looking for
& also may not meet professional accounting rules for layout,
but a very simple & elegant solution is simply
to write the currency symbol (or any other units)
in a row on its own near the top of the sheet:

       $        %     riders/year
       
      10.00    23.6       170 000
     100.00    54.7       265 500
    1000.00    67.8       143 200
   
I find it much easier to read tables with varied units this way
& always use it when writing tables myself.

HTH if no-one can suggest anything closer to your request.

-- 
========================,,============================================
SUPPORT     ___________//___,  Philip Webb : purslow@××××××××××××××.ca
ELECTRIC   /] [] [] [] [] []|  Centre for Urban & Community Studies
TRANSIT    `-O----------O---'  University of Toronto
-- 
gentoo-user@g.o mailing list