Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Only one setCellFormula call calls clearCellValue #68

Closed
SoltauFintel opened this issue Oct 30, 2020 · 1 comment
Closed

Only one setCellFormula call calls clearCellValue #68

SoltauFintel opened this issue Oct 30, 2020 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@SoltauFintel
Copy link
Member

SoltauFintel commented Oct 30, 2020

The PoiTransformer.clearCellValue workaround for a POI bug (see BitBucket issue 180) works for non-streaming. There's another call to setCellFormula where this clearCellValue() call is missing. With that call streaming would also work.

Background info: In POI 4.1.0 Vladislav Galas removed the unsetV() call after modifying a formula. This results sometimes in wrong sums (0).

@SoltauFintel SoltauFintel added the bug Something isn't working label Oct 30, 2020
@SoltauFintel SoltauFintel self-assigned this Oct 30, 2020
@SoltauFintel
Copy link
Member Author

Done. Will be released with 2.9.0.

SoltauFintel added a commit that referenced this issue Nov 2, 2020
* [maven-release-plugin] prepare release 2.9.0-rc1

* [maven-release-plugin] prepare for next development iteration

* Changes for 2.9.0

* #68 clearCellValue workaround for every setCellFormula() call (#70)

streaming

* Changes for 2.9.0 (links)

* release 2.9.0 component version and home page updates

* [maven-release-plugin] prepare release 2.9.0

* [maven-release-plugin] prepare for next development iteration

Co-authored-by: Marcus Warm <warm@mwvb.de>
Co-authored-by: SoltauFintel <SoltauFintel@users.noreply.github.com>
SoltauFintel added a commit that referenced this issue Nov 2, 2020
* [maven-release-plugin] prepare release 2.9.0-rc1

* [maven-release-plugin] prepare for next development iteration

* Changes for 2.9.0

* #68 clearCellValue workaround for every setCellFormula() call (#70)

streaming

* Changes for 2.9.0 (links)

* release 2.9.0 component version and home page updates

* [maven-release-plugin] prepare release 2.9.0

* [maven-release-plugin] prepare for next development iteration

Co-authored-by: SoltauFintel <SoltauFintel@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant