the formula =62408-A1 in Excel, the value serialized is
v0/v, which strongly suggests Excel is reading 62408 as the closest
number to the serialized data. So it would be ideal if POI did likewise.
Thanks,
David
--
David North, Technical Lead, CoreFiling Limited
http://www.corefiling.com
Phone: +44-1865
.aspx
Wading through the Office Open XML Specifications has failed to throw up
a definitive reference on number parsing.
--
David North, Technical Lead, CoreFiling Limited
http://www.corefiling.com
Phone: +44-1865-203192
On 02/06/14 18:21, David North wrote:
On 02/06/14 17:01, Nick Burch wrote:
No matter how I format it, the UI refuses to acknowledge or display
the
.0007 in the underlying file.
What about if you set a format string of something like
0.000 ? (I suspect the 62408 displayed
, building something on top of SAX - i.e. there is no
API as such for streaming read access to Row and Cell objects.
Correct?
Thanks,
David
--
David North, Technical Lead, CoreFiling Limited
http://www.corefiling.com
Phone: +44-1865-203192
ata of the Excel File,so i want to know if
>> there is any feature such that on giving a specific cell that will tell me
>> weather the cell is a merged cell or not and if the cell is a merged cell
>> give me the value of first row,colon of the cell(i mean merged cell value)
>>
Christmas to all our
users and developers, and I look forward to working with you in 2016.
On behalf of the Apache POI PMC,
David
- --
David North - Committer and PMC Member, Apache POI
https://home.apache.org/~dnorth/
-BEGIN PGP SIGNATURE-
Version: GnuPG v2
iQIcBAEBCAAGBQJWfBg/
will be at ApacheCon Europe in Seville later in the year; do
find us there if you have input and suggestions.
On behalf of the Apache POI PMC,
David North
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional