[Bug 58408] Add visio schemas to the OOXML jar
https://bz.apache.org/bugzilla/show_bug.cgi?id=58408 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|REOPENED|RESOLVED --- Comment #8 from Dominik Stadler --- I think this is basically fixed, further work on refactoring the different schema-jars should be handled in separate issues. -- 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 58694] org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException
https://bz.apache.org/bugzilla/show_bug.cgi?id=58694 Dominik Stadler changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME --- Comment #2 from Dominik Stadler --- No response for some time on the request for more information, therefore I am setting closing this for now. Please reopen this with more information if you still have this problem with the latest version of POI. -- 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 58266] org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen, if so please send a mail to the developers team, thanks !
https://bz.apache.org/bugzilla/show_bug.cgi?id=58266 Dominik Stadler changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |INVALID --- Comment #4 from Dominik Stadler --- Without more info we likely cannot do much here, therefore I am closing this until we get a sample document which triggers this error message. -- 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 35897] Password protected files
https://bz.apache.org/bugzilla/show_bug.cgi?id=35897 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #37 from Dominik Stadler --- As far as I see the latest patch from Andi is applied, so I am closing this as FIXED, please open new bugs for any remaining problems as this one has quite a long history and many changes were done to the code in the meantime. -- 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 35897] Password protected files
https://bz.apache.org/bugzilla/show_bug.cgi?id=35897 Dominik Stadler changed: What|Removed |Added Attachment #32258|1 |0 is patch|| Attachment #32258|text/plain |application/zip mime type|| -- 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 56499] IFERROR fails when written to spreadsheet
https://bz.apache.org/bugzilla/show_bug.cgi?id=56499 Dominik Stadler changed: What|Removed |Added Attachment #31611|0 |1 is obsolete|| --- Comment #9 from Dominik Stadler --- Created attachment 33560 --> https://bz.apache.org/bugzilla/attachment.cgi?id=33560&action=edit Testcase to produce the incorrect 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 56499] IFERROR fails when written to spreadsheet
https://bz.apache.org/bugzilla/show_bug.cgi?id=56499 --- Comment #8 from Dominik Stadler --- Some analysis: * IFERROR is not part of the default set of Excel functions, but is marked as "external" in the parsed formula: Ptg[7]=org.apache.poi.ss.formula.ptg.FuncVarPtg [#external# nArgs=3]V * The externalname is added by POI as follows: [EXTERNALNAME] .options = 0 .ix = 0 .name= IFERROR org.apache.poi.ss.formula.ptg.ErrPtg [#REF!]. [/EXTERNALNAME] * When the file is edited and saved in Excel it is saved as follows: [NAME] .option flags = 0x038B .keyboard shortcut = 0x00 .length of the name = 13 .extSheetIx(1-based, 0=Global)= 0 .sheetTabIx = 0 .Menu text length = 0 .Description text length= 0 .Help topic text length = 0 .Status bar text length = 0 .NameIsMultibyte= false .Name (Unicode text)= _xlfn.IFERROR .Formula (nTokens=1): org.apache.poi.ss.formula.ptg.ErrPtg [#NAME?]. .Menu text = .Description text= .Help topic text = .Status bar text = [/NAME] * The external name is currently built in InternalWorkbook.getNameXPtg() -- 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 58339] [PATCH] Make OFFSET() accept missing parameters
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339 Javen O'Neal changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #6 from Javen O'Neal --- Merged in r1730606 and r1730607. Thanks for the patch, Patrick! -- 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 58418] Applying Auto Filter on SXSSFSheet leads to corrupt excel
https://bz.apache.org/bugzilla/show_bug.cgi?id=58418 Dominik Stadler changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME --- Comment #2 from Dominik Stadler --- Not enough information and no response, therefore closing this, please reopen with more information (ideally a self-sufficient unit-test and any required sample documents) if this is still a problem for 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 55476] [PATCH] Fixed: after XWPFRun.addPicture() Word considers the document as corrupted
https://bz.apache.org/bugzilla/show_bug.cgi?id=55476 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #6 from Dominik Stadler --- I tried, but could not reproduce this problem, adding pictures worked fine, Microsoft Word could open the document. See the unit-test added in r1730598. Therefore I am closing this for now, if this is still does not work for you with the latest version of POI then please provide the sample code and the exact version of Microsoft Word that you are using to allow us to reproduce this. -- 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 58339] [PATCH] Make OFFSET() accept missing parameters
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339 --- Comment #5 from Javen O'Neal --- Nevermind, TestFormulasFromSpreadsheet.java handles the extra tests. No need for new unit tests. The current attached xls/xlsx files fail at TestFormulasFromSpreadsheet.java because their locale is DE, so they use OktIndex rather than Oct2Dec, and other locale-specific functions. However, Offset passes, so the changes are good. I don't have access to EN locale Excel to copy your edits over at the moment. I'll get to this in a week if no one else beats me to it. Presumably the only changes were the addition of Offset formulas: H1040 =SUM(OFFSET(K7:L8,0,0,1,1)) I1040 =SUM(OFFSET(K7:L8,0,0,1,)) J1040 =SUM(OFFSET(K7:L8,0,0,,1)) K1040 =SUM(OFFSET(K7:L8,0,0,1)) L1040 =SUM(OFFSET(K7:L8,0,0)) M1040 =SUM(OFFSET(K7:L8,0,0,,)) N1040 =SUM(OFFSET(K7:L8,0,0,)) -- 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 58339] [PATCH] Make OFFSET() accept missing parameters
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339 --- Comment #4 from Javen O'Neal --- Is there an ignored failing unit test to show that the offset function doesn't work when one or both of the last two parameters are missing? If not, that's probably all this bug needs before it can be merged. -- 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 46136] Add an ignore warning for cells with Numbers as Text
https://bz.apache.org/bugzilla/show_bug.cgi?id=46136 --- Comment #6 from Nick Burch --- XSSF now has a suitable set of Usermodel methods, and there's a common enum of the error types + support in FeatFormulaErr2 This now needs someone to implement those same methods (+add them to the interface), by doing the necessary record finding/adding/etc -- 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 56892] [PATCH] Ignoring number-stored-as-text warnings requires going via CTWorksheet
https://bz.apache.org/bugzilla/show_bug.cgi?id=56892 Nick Burch changed: What|Removed |Added Resolution|--- |FIXED Status|NEEDINFO|RESOLVED --- Comment #8 from Nick Burch --- As of r1730543, I've moved the enum into the main ss package, and documented those entries that I can from the XLS spec. That leaves a couple needing descriptions that I think are XLSX-only. I haven't added the matching HSSF support using FeatFormulaErr2, that remains for #46136 -- 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 58339] [PATCH] Make OFFSET() accept missing parameters
https://bz.apache.org/bugzilla/show_bug.cgi?id=58339 --- Comment #3 from Patrick Zimmermann --- Is there anything I can do to get this merged or is it just missing tuits? -- 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
[GitHub] poi pull request: Adding utility method to check any protection is...
Github user asfgit closed the pull request at: https://github.com/apache/poi/pull/27 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. --- - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 58838] Some cells are null when they aren't
https://bz.apache.org/bugzilla/show_bug.cgi?id=58838 --- Comment #10 from Dominik Stadler --- initial attempt at a unit test for this: @Test public void testBug58838() throws IOException { Workbook wb = HSSFTestDataSamples.openSampleWorkbook("58838.xls"); Sheet sheet = wb.getSheet("InitCharge"); Row row = sheet.getRow(1); //int lastCol = CellReference.convertColStringToIndex("BC"); for (int c=0; c <= row.getLastCellNum(); c++) { Cell cell = row.getCell(c); if (cell != null) { System.out.print(new CellReference(1, c).formatAsString() + ", "); } else { System.out.print("(" + new CellReference(1, c).formatAsString() + "), "); } } wb.close(); } -- 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