You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Ilya Kasnacheev <il...@office.uw.ru> on 2007/07/20 16:27:07 UTC
HSSF: Yet another question about data format:
This question is not entirely related to POI, rather to Excel.
Documentation tells about some formats which I don't understand.
"($#,##0_);($#,##0)"
"m/d/yy h:mm"
"_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"
What do ()'s mean? What does _ mean? When date contains both month and minute,
how does it guess which one is which - first one is always month? :-separated
is always minute?
What does * mean?
If you do know any of this, I would like to hear :)
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSF: Yet another question about data format:
Posted by Ilya Kasnacheev <il...@office.uw.ru>.
В сообщении от 20 Июль 2007 18:53 Yegor Kozlov написал(a):
> Search for a guidelines for custom number formats in Excel.
> May be this link will help:
> http://support.microsoft.com/kb/264372
Thanks, that was of great value!
> Open the Format Cells dialog in Excel and try to apply these custom
> formats. This way you can figure out what this abracadabra means.
I have OOo 1.1 and MS Excel 2006.
Both of them mishandle and misdisplay those formats - one thing is displayed
and another goes to file :(
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: HSSF: Yet another question about data format:
Posted by Yegor Kozlov <ye...@dinom.ru>.
Search for a guidelines for custom number formats in Excel.
May be this link will help:
http://support.microsoft.com/kb/264372
Open the Format Cells dialog in Excel and try to apply these custom
formats. This way you can figure out what this abracadabra means.
Regards,
Yegor
> This question is not entirely related to POI, rather to Excel.
> Documentation tells about some formats which I don't understand.
> "($#,##0_);($#,##0)"
> "m/d/yy h:mm"
> "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"
> What do ()'s mean? What does _ mean? When date contains both month and minute,
> how does it guess which one is which - first one is always month? :-separated
> is always minute?
> What does * mean?
> If you do know any of this, I would like to hear :)
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org