[PR] Keep cell number formats when plotting chart data from a sheet range [poi]

kamilkrzywanski (via GitHub) <[email protected]> Mon, 20 Jul 2026 22:22:42 -0000
Newsgroups gmane.comp.jakarta.poi.devel
Message-ID <[email protected]>
kamilkrzywanski opened a new pull request, #1189:
URL: https://github.com/apache/poi/pull/1189

   When chart data is built with `fromNumericCellRange` and then `plot()` is called, the series format code in the chart `numCache` was left empty (and any existing format was cleared). PowerPoint then shows unformatted data labels if they are linked to source, until the embedded workbook is opened in Excel and the cache is refreshed.
   
   This change reads number formats from the cells, uses the first non-blank numeric cell as the series format, and writes a per-point format when it differs. `setFormatCode(...)` still overrides the series format. Includes a regression test.
   
   Fixes #1007


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]