I created a simple one cell spreadsheet one with the warning and one
where I set the warning to ignore in Excel. Here is the diff after
running them through BiffViewer. Reading the BiffViewer out it looks
like it is not supported. Any ideas for next step to take, dig in and
add the feature?
< recordid = 0x867, size = 19
< [UNKNOWN RECORD:867]
< .id = 867
< [/UNKNOWN RECORD]
<
< Offset 0x6f3 (1779)
< recordid = 0x868, size = 39
< [UNKNOWN RECORD:868]
< .id = 868
< [/UNKNOWN RECORD]
<
< Offset 0x71e (1822)
-----Original Message-----
From: Knudsen, Joe
Sent: Wednesday, October 22, 2008 8:33 AM
To: 'POI Users List'
Subject: RE: green corner in a cell warning about a number formatted as
text
>From Excel I can tell it to ignore the error on a cell by cell basis and
it seems to remember that. I was wondering if that is stored in the
spreadsheet and I can set that flag via POI?
-----Original Message-----
From: Knudsen, Joe
Sent: Monday, October 20, 2008 8:31 AM
To: 'POI Users List'
Subject: green corner in a cell warning about a number formatted as text
Can anyone help in getting rid of the green corner in a cell warning
about, "Number Stored as Text". I would like to use the Cells as Text.
I have set the Data Format and that seems to working, but I still get
the warning in Excel. I see that I can turn off the warning in Excel
but I was hoping I could do something in POI to get rid of the warning.
Any ideas?
dataStyle.setDataFormat(HSSFDataFormat.getBuiltinFormat("text"));
Thanks,
Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
