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

[Iain Buchanan]

Hi,

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

etc.  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

etc.  For a large spreadsheet, with lots of number, the aligned "$" is
much easier to read.

I've tried to get around it with a "custom" formatting that uses the
"conditional brackets" <, >, <=, etc:

[<=0][RED]"$      "0.00;[>=10]"$    "#.00;"$      "0.00

But this only works (kind of) with numbers 99.00 and less, because over
100, the $ gets misaligned again.

I then tried 

[<=0][RED]"$      "0.00;[>=10]"$    "##.00;[>=100]"$  "###.00;"$      "0.00

but for some reason, the [>=100] condition gets deleted by openoffice,
so next time I look it isn't there!  I suspect this is something to do
with the fact that >=10 and >=100 overlap, and ooffice doesn't know what
to do... or something...

Also, there's no way of doing >10 AND <100 for a condition...

Anyone have a solution for the "accountancy" problem, or some
suggestions for my number formats?

I would greatly appreciate any leads.  I'm trying to convert some of our
company's excel documents to open office, and this will halt the
process :(

TIA!
-- 
Iain Buchanan <iaindb at netspace dot net dot au>

Our little systems have their day;
They have their day and cease to be;
They are but broken lights of thee.
		-- Tennyson

-- 
gentoo-user@g.o mailing list