https://bz.apache.org/bugzilla/show_bug.cgi?id=60571
--- Comment #4 from Jonny <jlwin...@us.ibm.com> --- Hello, so I have been working on this issue. I believe the change may be deeper than the package I had mentioned, and I don't see the source code for them. But more importantly, I don't quite know where the implementation for the solution would take place. In the excel file, I did comparisons and looked at the cell properties, by using VBA editor. The cell properties "NumberFormat" and "NumberFormatLocal" should be set with the custom number format somehow. They aren't set currently with the custom format, except for the Japanese Yen, as I had mentioned; the others are set with a standard currency format. I also manaully added the format to a cell value, and did see this cell property update to the correct custom number format. So I believe if we have some way to set this in Apache POI, that will resolve the issue. The following are some things I've looked into. I looked in CellUtil.setCellStyleProperty(), and those are limited. Updating this to have a setNumberFormat & setNumberFormatLocal might help. However, I've unzipped an xlsx file, and looked at the containing xml files, and it seems that the only place which has the custom number formats is in styles.xml. And as I've mentioned before, the JPY number format works mostly. So I don't know how this update would help. Another location I looked in is in CTXF, which is used when setting the data format for cell styles. When debugging, I looked at the xml fragment generated (this is for Japanese Yen, but it looks the same for all the cells): <xml-fragment numFmtId="166" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="true" xmlns:main="http://schemas.openxmlformats.org/spreadsheetml/2006/main";> <main:alignment wrapText="true"/> </xml-fragment> >From what I've researched, this should include the "formatCode" attribute, which the value would be the number format. I received that from this stackoverflow, but the solution doesn't use Apache POI, nor do I think it still uses the formatCode attribute, which leads me to believe this implementation may not be fruitful. But I'd appreciate an opinion from someone else. http://stackoverflow.com/questions/23501843/applying-number-formatting-in-openxml This package may be with a different open source product, is that right? org.openxmlformats.schemas.spreadsheetml.x2006.main If so, maybe the issue resides in there and I should open a different ticket? Thank you all for any tips or suggestions. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
