summaryrefslogtreecommitdiffstats
path: root/test-data/spreadsheet
Commit message (Collapse)AuthorAgeFilesLines
* Bug 62836: Implementation of Excel TREND functionYegor Kozlov2018-11-021-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1845586 13f79535-47bb-0310-9956-ffa450edef68
* bug 62625 -- add special handling for REFERENCE_NAME record that may onlyTim Allison2018-10-301-0/+0
| | | | | | contain an ascii string, against the spec in VBAMacroReader git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1845238 13f79535-47bb-0310-9956-ffa450edef68
* bug 62624 -- fix npe by adding processing of module name mapping in ↵Tim Allison2018-10-291-0/+0
| | | | | | VBAMacroReader git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1845138 13f79535-47bb-0310-9956-ffa450edef68
* #62834 FormulaEvaluator.evaluateInCell() throws ExceptionGreg Woolsey2018-10-191-0/+0
| | | | | | | | | | | | added cell type = formula check when looping through the shared formula range, to ignore any non-formula cells. Also refactored a bit to enable passing in the evaluation context, as getCellFormula() uses it behind the scenes when evaluating a shared formula cell (has to shift the formula references based on the master cell). Review of these changes is welcome, as always. Checked all other code referencing the "SHARED" enum, and didn't see anything else that dealt with formula cell values and thus would need to notice non-formula cells. Added unit test based on the failing file from Bugzilla. Test failed until the fixed code was in place. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1844295 13f79535-47bb-0310-9956-ffa450edef68
* 62815 -- some numeric values not correctly extracted from xlsbTim Allison2018-10-112-0/+284
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1843553 13f79535-47bb-0310-9956-ffa450edef68
* extract valuable code from 54470 submitted patchAlain Béarez2018-10-011-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1842548 13f79535-47bb-0310-9956-ffa450edef68
* [bug-62055] Fix XSSFImportFromXML table resize. Thanks to Leonard Kappe. ↵PJ Fanning2018-02-251-0/+0
| | | | | | This closes #99 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1825315 13f79535-47bb-0310-9956-ffa450edef68
* [github-94] Add Range Copier. Thanks to Dragan Jovanović. This closes #94PJ Fanning2018-02-142-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1824266 13f79535-47bb-0310-9956-ffa450edef68
* Add test which verifies that bug 61652 is not appearing any more on latest trunkDominik Stadler2018-01-011-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1819769 13f79535-47bb-0310-9956-ffa450edef68
* Bug 58106: when a cell with a 'master' shared formula is removed, the next ↵Yegor Kozlov2017-12-301-0/+0
| | | | | | cell in the range becomes the master git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1819623 13f79535-47bb-0310-9956-ffa450edef68
* Bugzilla 61116: Formula evaluation fails when using matrix addition within ↵Yegor Kozlov2017-12-301-0/+0
| | | | | | index function call git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1819596 13f79535-47bb-0310-9956-ffa450edef68
* Implement DMAX and DSUM functions, following the pattern from DMIN. Greg Woolsey2017-12-271-0/+0
| | | | | | Refactored the D* function enum to have instances return the function implementation instances rather than using a case construct, now that Java 8 is required. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1819376 13f79535-47bb-0310-9956-ffa450edef68
* Bug 61869: updating a cell with shared formula produces an unreadable fileYegor Kozlov2017-12-201-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1818818 13f79535-47bb-0310-9956-ffa450edef68
* Bug 61859: support for evaluating comparison operators in array mode, detect ↵Yegor Kozlov2017-12-181-0/+0
| | | | | | array mode from formula ptgs git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1818587 13f79535-47bb-0310-9956-ffa450edef68
* Bug 61882 - Some paths can create an XSSFColor instance with a null CTColor ↵Greg Woolsey2017-12-111-0/+0
| | | | | | | | reference test file git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1817797 13f79535-47bb-0310-9956-ffa450edef68
* Bug #61841 - Unnecessary long computation when evaluating VLOOKUP on all ↵Greg Woolsey2017-12-061-0/+0
| | | | | | | | | | | | column reference Found some optimizations in the general evaluation framework related to blank cells in rows beyond the last defined row of a sheet. I don't see any issue with passing a bit of context down deeper into this framework, as it's all POI-internal and only had one calling path. See the above bug for the performance analysis. Not specifically related to VLOOKUP, but improves that case by more than 2/3 as well. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1817252 13f79535-47bb-0310-9956-ffa450edef68
* Fixes Bug 61764 Conditional formatting rules don't evaluate properly for ↵Greg Woolsey2017-11-154-0/+0
| | | | | | | | | | some multi-range rule definitions Fixes Bug 61761 Conditional formatting rule evaluation doesn't like comparing cells of different types fixed, with unit tests. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815298 13f79535-47bb-0310-9956-ffa450edef68
* Add test-case which shows that bug 55814 is fixed already by other changesDominik Stadler2017-11-041-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814290 13f79535-47bb-0310-9956-ffa450edef68
* add test case for bug 61701PJ Fanning2017-10-311-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1813864 13f79535-47bb-0310-9956-ffa450edef68
* Add test which shows that bug 51262 is fixed nowDominik Stadler2017-10-091-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1811595 13f79535-47bb-0310-9956-ffa450edef68
* Numeric Array Formula and Matrix Function [from Bob95132] This closes #69PJ Fanning2017-09-132-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1808297 13f79535-47bb-0310-9956-ffa450edef68
* Fixes bug #61468, caused by a confusing OOXML spec design as noted in ↵Greg Woolsey2017-08-291-0/+0
| | | | | | JavaDocs added in r1795648. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1806623 13f79535-47bb-0310-9956-ffa450edef68
* Fix 60384 and 60709: When shifting with merged regions we should correctly ↵Dominik Stadler2017-08-192-0/+0
| | | | | | check if the region is moved along or needs to be removed because it is not fully kept via the shifting. This was broken by the fix for bug 59740, now additional unit tests ensure that it works better. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1805518 13f79535-47bb-0310-9956-ffa450edef68
* Bug 61431 - Conditional formatting evaluation ignores undefined cellsGreg Woolsey2017-08-161-0/+0
| | | | | | | | now evaluating based on cell references instead, and watching out for undefined cells in rules that require a cell. Added unit test based on previously failing file. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1805245 13f79535-47bb-0310-9956-ffa450edef68
* Fix data validation value list evaluationGreg Woolsey2017-07-261-0/+0
| | | | | | | | | | | | | | | | One of my users found that my initial implementation was lacking a core distinction - most evaluations expect a single result, and "unwrap" 2/3D ValueEval results to a single value based on the input row/column. However, data validation list formulas explicitly are expected to return a 2D ValueEval. This worked when the formula was simple and evaluated to a single Ptg, but only returned one value when the formula was more complex, or referenced a named range defined as a complex formula. This change teaches WorkbookEvaluator about the distinction, by way of a new attribute for FormulaType. There is room for discussion over how it is implemented, but this works for me. Includes the failing workbook we had as a new unit test. While I was in FormulaType I went ahead and removed the deprecated, unused, and redundant code marked for removal in 3.17. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1803121 13f79535-47bb-0310-9956-ffa450edef68
* bug 61300 -- prevent really long (infinite?) loop on corrupt fileTim Allison2017-07-141-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1801989 13f79535-47bb-0310-9956-ffa450edef68
* bug 61286/bug 61287 -- allow WriteProtectRecord to have 2 bytes, and allow ↵Tim Allison2017-07-141-0/+0
| | | | | | for HeaderFooter to be empty. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1801966 13f79535-47bb-0310-9956-ffa450edef68
* bug 61294 -- prevent infinite loop in IOUtils' skipFully.Tim Allison2017-07-131-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1801844 13f79535-47bb-0310-9956-ffa450edef68
* [Bug-61281] guard against index out of bounds in XSSFExportToXml column mappingPJ Fanning2017-07-111-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1801634 13f79535-47bb-0310-9956-ffa450edef68
* Add file that failed regression tests as a unit test.Greg Woolsey2017-06-241-0/+0
| | | | | | | Adjust table style processing to allow for AlternateContent wrappers for table element style definitions. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1799733 13f79535-47bb-0310-9956-ffa450edef68
* bug 61045 -- allow for (and log!) extra bytes in FormatRecord.Tim Allison2017-06-201-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1799360 13f79535-47bb-0310-9956-ffa450edef68
* Don't try to clone a chart, this makes integration-tests work for a few more ↵Dominik Stadler2017-06-181-0/+0
| | | | | | documents, also the one added via bug 56557 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1799037 13f79535-47bb-0310-9956-ffa450edef68
* Add missing file for test for bug 56557Dominik Stadler2017-06-161-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1798926 13f79535-47bb-0310-9956-ffa450edef68
* XSSFTable should format numeric/date cells when used as Column Header names ↵Nick Burch2017-06-071-0/+0
| | | | | | as Excel does, see https://stackoverflow.com/questions/44407111/apache-poi-cant-format-filled-cells-as-numeric git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1797914 13f79535-47bb-0310-9956-ffa450edef68
* Bug 60898 - XSSFColor's getARGB() method returns a wrong color value when a ↵Greg Woolsey2017-05-261-0/+0
| | | | | | | | | | | | | | workbook has a custom indexed color teach XSSFColor and most things that create instances about indexed colors. Null is a valid value for IndexedColorMap instances - the existing built-in default colors are used. Whenever a workbook style is accessible in the call hierarchy its color mappings are passed down now. Thanks for the unit test in the issue, it now passes. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1796359 13f79535-47bb-0310-9956-ffa450edef68
* Bug 61063: Add a RefListEval to handle UnionPtg and implement it for Rank(), ↵Dominik Stadler2017-05-231-0/+0
| | | | | | may be missing for other functions where ArrayEval is currently handled git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1795963 13f79535-47bb-0310-9956-ffa450edef68
* removed invalid test fileAndreas Beeker2017-05-141-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1795122 13f79535-47bb-0310-9956-ffa450edef68
* git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1795002 ↵Greg Woolsey2017-05-122-0/+0
| | | | 13f79535-47bb-0310-9956-ffa450edef68
* 61060 - teach DataFormatter about conditional formatting rules with number ↵Greg Woolsey2017-05-051-0/+0
| | | | | | | | formats Currently only implemented for XSSF, as there is no API available for HSSF conditional formatting rule number formats (if it is even in the files). git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1794084 13f79535-47bb-0310-9956-ffa450edef68
* bug 61034: Call to XSSFReader.getSheetsData() returns duplicate sheets.Javen O'Neal2017-04-291-0/+0
| | | | | | | Thanks to Mauricio Eastmond for the Excel test file and unit test. Thanks to Sebastian Wikalinski for isolating the problem and providing a patch. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1793223 13f79535-47bb-0310-9956-ffa450edef68
* Issue #60971, handle formula chart titlesGreg Woolsey2017-04-111-0/+0
| | | | | | implemented per issue, breaking out static text vs. formula based title getters and setters, with unit test updates and additions. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1791025 13f79535-47bb-0310-9956-ffa450edef68
* Fix AIOOBE while extracting hssf pictures which are externally linkedAndreas Beeker2017-04-101-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1790897 13f79535-47bb-0310-9956-ffa450edef68
* Test for another type of xml-bombDominik Stadler2017-04-061-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1790473 13f79535-47bb-0310-9956-ffa450edef68
* Fix issue found via large corpus tests: HSSFPicture in a HSSFShapeGroup ↵Dominik Stadler2017-04-061-0/+0
| | | | | | might not have a patriarch set, so let's walk up the parents to try to find one. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1790472 13f79535-47bb-0310-9956-ffa450edef68
* 60881 and 60891 -- on further look, no need to throw an exception for an ↵Tim Allison2017-03-201-0/+0
| | | | | | encrypted xlsb. On the second, let's fix readFully to read fully. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1787846 13f79535-47bb-0310-9956-ffa450edef68
* 60823: DGET function, correct behavior with multiple result entries but only ↵Dominik Stadler2017-03-191-0/+0
| | | | | | one non-blank git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1787658 13f79535-47bb-0310-9956-ffa450edef68
* 60826 -- add initial support for streaming reading of xlsb files.Tim Allison2017-03-167-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1787228 13f79535-47bb-0310-9956-ffa450edef68
* Fixed #60858, which showed a regression of the fix for #56420 introduced by ↵Greg Woolsey2017-03-141-0/+0
| | | | | | | | my refactoring to fix #56822. Includes new unit test based on the bug sample file. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1786954 13f79535-47bb-0310-9956-ffa450edef68
* Add tests from bug 45353 to show that this now works fineDominik Stadler2017-03-102-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1786432 13f79535-47bb-0310-9956-ffa450edef68
* 51519 -- allow users to ignore or include the <rPh> (phonetic run) element ↵Tim Allison2017-03-081-0/+0
| | | | | | in the ReadOnlySharedStringsTable used in the SAX/streaming xlsx reader. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1785965 13f79535-47bb-0310-9956-ffa450edef68
generated by cgit v1.2.3 (git 2.39.1) at 2025-04-16 19:29:28 +0000