On 27/10/2007 22:38, Alan Boba wrote:
On 10/27/07, Jayant Gedam <[EMAIL PROTECTED]> wrote:
I want to format comma separator like this in spredsheet:
1,00,00,00,000.00
(This is Indian pattern of displaying numbers and currencies)
This format code works, sort of.
[>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0
Numbers from 0 to 100 million are displayed correctly. There are some
limitations though, no decimal display and using the add or remove decimal
tool bar button removes the Indian formating.
To add decimals, you have to have a different format code for each number of
decimal formats you want to display. This format is for two decimals.
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00
I haven't found a way to properly format numbers beyond 100 million. The
code for numbers to 100 million was found here...
http://help.lockergnome.com/office/set-numbers-Indian-Style-ftopict565238.htmlin
Gordon's post of July 5th, 2005. I confirmed how to add decimals and
identified the 100 million limit.
I don't know Calc very well but it seems to me that if regular expressions
can be used in format codes there might be a way to build the format code so
it understands there needs to be a repeating pattern of 00, for numbers
greater than 99,999. e.g. 1,00,000; 1,00,00,000; etc.
In Windows (XP Pro, at least) there are Control Panel options to set the
"digit grouping" for numbers and currency, separately, to the pattern
the OP requires. However, OpenOffice 2.2 takes no notice of these
settings. Is this a bug? Should not OO honour the OS's locale settings?
I haven't tried in OO 2.3 because I haven't downloaded it yet.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
