[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #8 from J English --- Created attachment 39698 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39698&action=edit zip file contains a simple test class and an excel template Hi PJ, Hopefully this is a lot simpler than the previous version. Simply run the test class. The excel template path should be relative. The excel template contains 1 row and 1 cell as the source row/cell that will be used for all rows. After running the test class, if you manually add '=SUM(A1:A6)' to any cell to get the sum of all modified cells, you will notice that the formula is not calculating correctly. Please let me know if you need anything else. Thank you -- 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
[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #7 from J English --- OK got it. No worries. I'll try uploading much simpler version of the code. I'll keep you posted. -- 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
[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #6 from PJ Fanning --- I am not going to look any further at that sample. It is far too complicated. -- 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
[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974
--- Comment #5 from J English ---
Sorry, please use this version of the test class. This version has the correct
file names for the csv file, excel template file, and output file.
Thank you
import java.io.File;
public class TestExcelWriter
{
public static void main(String[] args) throws Exception
{
File outPutFile = new File("outputFile.xlsx");
String templateFilePath = "template.xlsx";
File csvFile = new File("inputFile.csv");
ExcelWriter excelWriter = new ExcelWriter();
excelWriter.generateExcelFile(outPutFile, templateFilePath, csvFile);
}
}
--
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
[Bug 68974] Unable to edit cell type on excel file that was generated via Apache Poi API
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974 --- Comment #4 from J English --- Created attachment 39697 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39697&action=edit zip file that contains class, test class, csv file, excel template, and output files Thank you for your help. I tried adding the recommended line of code (below) to my class, but it unfortunately it did not resolve my issue. workbook.setForceFormulaRecalculation(true); I've attached a zip file that contains a version of my class that can be used to reproduce the issue that I am seeing. I've also included a csv file, an excel template, output files, and a test class to run a quick test of my code. Please let me know if you need anything else. Thank you. -- 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
[Bug 68979] NullPointerException in XSSFFormulaEvaluator with reference to missing external workbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=68979 PJ Fanning changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from PJ Fanning --- Thanks for the reproduction. To be honest, it gives me the shivvers to take xlsx files from random people on the internet. I like to avoid installing them on my laptop. Could you provide the stacktrace and I might be able to avoid going near the xlsx file. No offence intended but I hope you would be suspicious if I sent you and xlsx file. -- 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
[Bug 68979] New: NullPointerException in XSSFFormulaEvaluator with reference to missing external workbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=68979
Bug ID: 68979
Summary: NullPointerException in XSSFFormulaEvaluator with
reference to missing external workbook
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: apache-bugzilla-sebast...@kaselo.de
Target Milestone: ---
Created attachment 39696
--> https://bz.apache.org/bugzilla/attachment.cgi?id=39696&action=edit
Input file for the unit test to reproduce the behaviour
The XSSFFormulaEvaluator may throw a NullPointerException when a cell
references an unknown workbook and the evaluator was explicitly told to ignore
missing workbooks.
I could reproduce the behaviour with versions 5.2.2 (included in jxls 2.14) up
to 5.2.4. With version 4.1.2 (included in jxls 2.12), the evaluator reads the
file without an error and produces a sheet with a single row and a single cell.
This is the behaviour I would still expect with the new version.
Here is a unit-test to reproduce the behaviour with the attached file, which
only contains a single sheet with a single cell:
@Test
void testFileWithFormulaReferenceToNonExistingFile() throws IOException {
InputStream is = new FileInputStream("test.xlsx");
XSSFWorkbook workbook = new XSSFWorkbook(is);
FormulaEvaluator evaluator = new XSSFFormulaEvaluator(workbook);
evaluator.setIgnoreMissingWorkbooks(true);
evaluator.evaluateAll();
Sheet sheet = workbook.getSheetAt(0);
Iterator rowIt = sheet.rowIterator();
Row row = rowIt.next();
Assertions.assertEquals(1, row.getPhysicalNumberOfCells());
}
The formula is quite complex (with VLOOKUP, extracted from a real failing
example). I did not manage to simplify it without losing the reproducibility of
the problem.
--
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
[PR] Bump com.github.spotbugs from 5.2.1 to 6.0.14 [poi]
dependabot[bot] opened a new pull request, #631: URL: https://github.com/apache/poi/pull/631 Bumps com.github.spotbugs from 5.2.1 to 6.0.14. [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) --- Dependabot commands and options You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) -- 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: dev-unsubscr...@poi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
Re: [PR] Bump com.github.spotbugs from 5.2.1 to 6.0.13 [poi]
dependabot[bot] commented on PR #629: URL: https://github.com/apache/poi/pull/629#issuecomment-2096125165 Superseded by #631. -- 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: dev-unsubscr...@poi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
Re: [PR] Bump com.github.spotbugs from 5.2.1 to 6.0.13 [poi]
dependabot[bot] closed pull request #629: Bump com.github.spotbugs from 5.2.1 to 6.0.13 URL: https://github.com/apache/poi/pull/629 -- 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: dev-unsubscr...@poi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 68526] Do we have any Apache POI documentation for spreadsheet accessibility
https://bz.apache.org/bugzilla/show_bug.cgi?id=68526 Yulianan87 changed: What|Removed |Added URL||http://202.72.220.154/andro ||id/ Keywords||TestID -- 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
