https://bz.apache.org/bugzilla/show_bug.cgi?id=62215
--- Comment #3 from [email protected] <[email protected]> --- I came up with a solution. Attached go a test case to demonstrate the behavior and the solution. The reason is that SheetDataWriter.writeCell, when the cell is a formula cell, actually only handles numeric cached values, ignoring all other cell types. In my solution I rearranged the whole method to follow the routine: * write cell header * if cell is blank, finalize cell and return * get value type (either getCellTypeEnum for regular cells or getCachedFormulaResultTypeEnum for formula cells) * base on type, write type tag to the header and close header * write formula, if any * based on type, write value * finalize cell -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
