aboutsummaryrefslogtreecommitdiffstats
path: root/test-data/spreadsheet
Commit message (Collapse)AuthorAgeFilesLines
* Do not return null for POITextExtractor.getMetadataTextExtractor() for old ↵Dominik Stadler2021-04-261-0/+0
| | | | | | | | | Excel files To adhere to the JavaDoc of the POITextExtractor interface which does not document a possible null return. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1889205 13f79535-47bb-0310-9956-ffa450edef68
* [github-235] Fix date formatting for number cell values. Thanks to Anthony ↵PJ Fanning2021-04-251-0/+0
| | | | | | Schott. This close #235 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1889179 13f79535-47bb-0310-9956-ffa450edef68
* [github-234] Ensure the hours position is correct. Thanks to Anthony Schott. ↵PJ Fanning2021-04-151-0/+0
| | | | | | This closes #234 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1888804 13f79535-47bb-0310-9956-ffa450edef68
* Allow negative numbers in conditional part of format stringDominik Stadler2021-03-191-0/+0
| | | | | | Closes #229 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1887802 13f79535-47bb-0310-9956-ffa450edef68
* Implement CONCAT function #65185Nick Burch2021-03-141-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1887656 13f79535-47bb-0310-9956-ffa450edef68
* Add the ability to edit HSLFPictureData contentsMarius Volkhart2021-02-281-0/+0
| | | | | | | | | | | | Pictures can now be edited by calling HSLFPictureData#setData(byte[]). The byte[] should contain the image data as an image viewer might read it. To enable this functionality, a tighter coupling between the EscherBSERecords of the slideshow and the HSLFPictureData was required. This ensures that changes in image data size are accurately recorded in the records. In the course of coupling the records and the HSLFPictureData, various scenarios arose where a mapping of records to pictures was non-trivial. Accordingly, the HSLFSlideShowImpl#matchPicturesAndRecords(...) function was added to perform a more sophisticated matching pass. This function is heavily exercised by org.apache.poi.hslf.usermodel.TestBugs.testFile[5] and PPTX2PNG.render[2], as well as the new TestPictures#testSlideshowWithIncorrectOffsets(). Closes #225 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1887017 13f79535-47bb-0310-9956-ffa450edef68
* [bug-65096] XLSX Streaming XML not correctly reading multiple inline StringsPJ Fanning2021-01-211-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885770 13f79535-47bb-0310-9956-ffa450edef68
* Bug 65016 - Creating a chart throws exceptionAlain Béarez2021-01-191-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885700 13f79535-47bb-0310-9956-ffa450edef68
* Integration tests - try to fix Oracle/OpenJDK vs IBM-JDK error message ↵Andreas Beeker2021-01-171-0/+0
| | | | | | differences on XXE files git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885625 13f79535-47bb-0310-9956-ffa450edef68
* integration tests: ignore hsmf/lots-of-recipients.msg because of concurrent ↵Andreas Beeker2021-01-171-0/+0
| | | | | | test errors - also takes too long to process git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885603 13f79535-47bb-0310-9956-ffa450edef68
* integration tests: Fix handling of NullPointerExceptions for Java 16+ (again ↵Andreas Beeker2021-01-161-0/+0
| | | | | | | | ...) Refactor TestAllFiles to provide an API for mass testing git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885576 13f79535-47bb-0310-9956-ffa450edef68
* integration tests: NullPointerExceptions contain now a description in Java 16+Andreas Beeker2021-01-161-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885549 13f79535-47bb-0310-9956-ffa450edef68
* #65046 - Simplify integration testsAndreas Beeker2021-01-151-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885538 13f79535-47bb-0310-9956-ffa450edef68
* Sonar fixesAndreas Beeker2021-01-081-0/+0
| | | | | | Fixed offset of compare picture in resize_compare.xlsx git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885280 13f79535-47bb-0310-9956-ffa450edef68
* Bug 64450: Allow to parse a file where the relationship-id is an empty stringDominik Stadler2021-01-031-0/+0
| | | | | | | Also improve exception reporting by including more information and not "hiding" the actual exception-cause in a log-statement. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885056 13f79535-47bb-0310-9956-ffa450edef68
* Bug 64750: Do not use CTDataValidations.getCount(), instead only rely on ↵Dominik Stadler2021-01-011-0/+0
| | | | | | | | | | | | getDataValidationArray Field "count" seems to be optional according to the schema, so by using only the array Apache POI can read data validations from workbooks that do not populate the "count" field properly. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1885011 13f79535-47bb-0310-9956-ffa450edef68
* Bug 64986: Support missing or blank match_type for function MatchDominik Stadler2020-12-301-0/+0
| | | | | | Excel and LibreOffice use the default value in this case git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1884959 13f79535-47bb-0310-9956-ffa450edef68
* Add unfixed test for bug 64759 and make the ones fail which depend on manual ↵Dominik Stadler2020-12-301-0/+0
| | | | | | opening of files in Microsoft Excel for verification git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1884957 13f79535-47bb-0310-9956-ffa450edef68
* Improve the speed of the styles-optimiser when there are many styles in a ↵Dominik Stadler2020-12-291-0/+0
| | | | | | | | | | | | | Workbook Profiling showed that the call to isUserDefined() took most of the time, so we now fetch this only once for each style and remember the result and use it in the inner loop. The attached sample-file took aprox. 1m30s on a decent machine, now it is down to around 2s. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1884917 13f79535-47bb-0310-9956-ffa450edef68
* Fix bug 64238: Make LOOKUP functions deal with empty last arg correctlyDominik Stadler2020-10-251-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1882827 13f79535-47bb-0310-9956-ffa450edef68
* Bug 64667.xlsx prevent NPE loading styles tableTim Allison2020-08-131-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1880834 13f79535-47bb-0310-9956-ffa450edef68
* [github-187] Add length validation for Excel DataValidations that are list ↵PJ Fanning2020-08-091-0/+0
| | | | | | literals. Thanks to Leo Webb. This closes #187 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1880727 13f79535-47bb-0310-9956-ffa450edef68
* [bug-64508] add guard for invalid v valuePJ Fanning2020-07-151-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1879905 13f79535-47bb-0310-9956-ffa450edef68
* [github-185] Fix if function in array formulas with 2nd argument evaluating ↵PJ Fanning2020-07-031-0/+0
| | | | | | to error. Thanks to Miłosz Rembisz. This closes #185 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1879481 13f79535-47bb-0310-9956-ffa450edef68
* move docx added to wrong test dirPJ Fanning2020-06-261-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1879229 13f79535-47bb-0310-9956-ffa450edef68
* [bug-64561] XWPFSDTContent.getText() is empty for nested SDT elementsPJ Fanning2020-06-261-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1879223 13f79535-47bb-0310-9956-ffa450edef68
* 64512 - Ole10Native aka embedded / object packager - handle UTF16 variantsAndreas Beeker2020-06-111-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1878730 13f79535-47bb-0310-9956-ffa450edef68
* [github-181] make Value function work with arrays. Thanks to Miłosz ↵PJ Fanning2020-06-061-0/+0
| | | | | | Rembisz. This closes #181 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1878541 13f79535-47bb-0310-9956-ffa450edef68
* Fix bug 64420: NPE in XSSFReader for files with macro-sheetsDominik Stadler2020-05-161-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1877814 13f79535-47bb-0310-9956-ffa450edef68
* [github-180] Add DateValue function. Thanks to Milosz Rembisz. This closes #180PJ Fanning2020-05-151-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1877793 13f79535-47bb-0310-9956-ffa450edef68
* #55505 - CountryRecord not foundAndreas Beeker2020-04-211-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1876805 13f79535-47bb-0310-9956-ffa450edef68
* 64261 -- fix handling of drop down list when items are selectedTim Allison2020-03-311-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1875956 13f79535-47bb-0310-9956-ffa450edef68
* Bug 58896 and 52834: Cache Sheet.getMergedRegions() as it seems to sometimes ↵Dominik Stadler2020-03-081-0/+0
| | | | | | be the culprit for autosize taking a very long time. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1874973 13f79535-47bb-0310-9956-ffa450edef68
* Bug 64130 -- handle empty worksheet names in OldSheetRecord more robustly.Tim Allison2020-02-101-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1873863 13f79535-47bb-0310-9956-ffa450edef68
* Fix some additional file-handle-leaks reported by unit-tests via an enhanced ↵Dominik Stadler2020-01-031-0/+0
| | | | | | | | version of the file-leak-detector Also add a test for Bug 64045 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1872287 13f79535-47bb-0310-9956-ffa450edef68
* Bug 63940: Avoid endless loop/out of memory on string-replace with empty ↵Dominik Stadler2019-12-311-0/+0
| | | | | | search string git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1872145 13f79535-47bb-0310-9956-ffa450edef68
* Bug 63700: Make D* functions work with numeric result columnDominik Stadler2019-12-311-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1872136 13f79535-47bb-0310-9956-ffa450edef68
* Fix bug 63984: AND / OR should treat missing parameters as FALSEDominik Stadler2019-12-301-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1872125 13f79535-47bb-0310-9956-ffa450edef68
* [github-164] Fix Bug in XSSFTable.setCellReferences when table is single ↵PJ Fanning2019-12-111-0/+0
| | | | | | cell. Thanks to Travis Russell. This closes #164 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1871185 13f79535-47bb-0310-9956-ffa450edef68
* Bug 63768: Adjust handling of SchemaFactoryPJ Fanning2019-09-241-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1867484 13f79535-47bb-0310-9956-ffa450edef68
* #54803 - Error opening XLSX after saving with a Drawing using POIAndreas Beeker2019-04-171-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1857671 13f79535-47bb-0310-9956-ffa450edef68
* bug 63327 allow retrieval of wmf data embedded in emfTim Allison2019-04-081-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1857136 13f79535-47bb-0310-9956-ffa450edef68
* #63302 Formula evaluation of names with offset or row function is incorrectGreg Woolsey2019-03-301-0/+0
| | | | | | thanks to John Lincoln White for the patch, including new unit tests. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1856644 13f79535-47bb-0310-9956-ffa450edef68
* pre-release maintenance:Greg Woolsey2019-03-192-0/+0
| | | | | | | | * add my key to the KEYS file * update year in NOTICE (first release of 2019) * remove svn:executable flag from random test data files git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1855799 13f79535-47bb-0310-9956-ffa450edef68
* #60724 - Partial implementation for SUBTOTAL() 'ignore hidden rows' variationsGreg Woolsey2019-03-181-0/+0
| | | | | | | | | | The function still doesn't deal with auto-filtering, but it now handles variations that should skip hidden rows. Taught the evaluation framework to know about hidden rows similar to what was already there for skipping subtotals within subtotal ranges. Added unit test cases. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1855789 13f79535-47bb-0310-9956-ffa450edef68
* Bug 61472: Convert date/time strings to numbers when evaluating formulasYegor Kozlov2019-03-161-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1855662 13f79535-47bb-0310-9956-ffa450edef68
* Bug 62980: Make D* functions ignore case in headingsYegor Kozlov2019-02-091-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1853268 13f79535-47bb-0310-9956-ffa450edef68
* Bug 60405: Add initial support for cetab functions so some macros can beDominik Stadler2019-01-271-0/+0
| | | | | | | | parsed Add some function-definitions for Excel 4 Macros and missing functions found in regression tests git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1852277 13f79535-47bb-0310-9956-ffa450edef68
* follow-up to Bug 62904. More tests and improved evaluation of IF in array modeYegor Kozlov2019-01-143-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1851263 13f79535-47bb-0310-9956-ffa450edef68
* Add reproducer for bug 60355Dominik Stadler2019-01-131-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1851208 13f79535-47bb-0310-9956-ffa450edef68
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-18 19:39:38 +0000