Commit Graph

266 Commits

Author SHA1 Message Date
Dominik Stadler 31adc2f269 Add verifying testcase for Bug 57423 and Bug 55752, both are still not solved, though.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1676965 13f79535-47bb-0310-9956-ffa450edef68
2015-04-30 11:54:13 +00:00
Nick Burch ef8cb7fdb4 Sample password protected xlsx file from Tika
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1676840 13f79535-47bb-0310-9956-ffa450edef68
2015-04-29 20:07:51 +00:00
Nick Burch b2a1862f19 Patch from Jon Scharff from bug #57826 - If a XSSF shape has a buFont but no bullet character, mirror Excel and treat as un-bulleted
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1676831 13f79535-47bb-0310-9956-ffa450edef68
2015-04-29 19:21:37 +00:00
Dominik Stadler d1385bbe1b Fix bug 57828, shifting more than one commit per row did not work.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1674975 13f79535-47bb-0310-9956-ffa450edef68
2015-04-20 20:13:33 +00:00
Dominik Stadler 12c220121e Bug 57163: Fix possible NullPointerException when a spreadsheet has no LinkTable and we try to adjust it during sheet removal.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1673168 13f79535-47bb-0310-9956-ffa450edef68
2015-04-13 12:19:11 +00:00
Dominik Stadler 7567838f9b Add test from bug 49423 to verify that the problem was fixed in the meantime
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1668481 13f79535-47bb-0310-9956-ffa450edef68
2015-03-22 21:45:56 +00:00
Dominik Stadler 30d20582af Bug 56295: Fix cloning of styles across workbooks and handling of default value of attribute applyFill
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1666736 13f79535-47bb-0310-9956-ffa450edef68
2015-03-14 19:32:28 +00:00
Dominik Stadler 1849741d43 Add second verification of bug 56325 to ensure it is really fixed
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1666718 13f79535-47bb-0310-9956-ffa450edef68
2015-03-14 17:50:55 +00:00
Nick Burch cbb9c9356f Add some sample Strict ooxml files, from Excel 2013
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1666410 13f79535-47bb-0310-9956-ffa450edef68
2015-03-13 11:42:15 +00:00
Dominik Stadler e7615fdd34 Bug 57456: Fix reading XLS with empty SSTRecord where Excel puts some random number in unique-strings-count-field
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1659650 13f79535-47bb-0310-9956-ffa450edef68
2015-02-13 19:14:14 +00:00
Nick Burch b1a6afc36a Add a unit test (disabled) for bug #57535 - "Unknown error type: -60" fetching formula error value
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1658186 13f79535-47bb-0310-9956-ffa450edef68
2015-02-08 15:17:47 +00:00
Nick Burch b25e4ca87d 57482 Handle XSLX files with no shared strings table in read-only mode
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1653825 13f79535-47bb-0310-9956-ffa450edef68
2015-01-22 12:15:59 +00:00
Nick Burch ca33983388 Unit test from Isao Kadowaki from bug #57482
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1653814 13f79535-47bb-0310-9956-ffa450edef68
2015-01-22 11:45:40 +00:00
Nick Burch 9866864ccf Add a sample Excel 3 file from TIKA-1515, and a disabled unit test for it
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1651451 13f79535-47bb-0310-9956-ffa450edef68
2015-01-13 19:32:50 +00:00
Dominik Stadler c8bf92f963 Bug 57196: Resolve RefEval to it's inner ValueEval in Hex2Dec
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1650597 13f79535-47bb-0310-9956-ffa450edef68
2015-01-09 16:51:02 +00:00
Dominik Stadler c15f7bc929 Add reproducer for bug 57074
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1650059 13f79535-47bb-0310-9956-ffa450edef68
2015-01-07 14:13:34 +00:00
Dominik Stadler 0819dd3b9f Update tests for ExcelAntWorkbookUtil, remove some unnecessary null-checks that can never happen, fix setting failed state on error in evaluation
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1649311 13f79535-47bb-0310-9956-ffa450edef68
2015-01-04 10:23:45 +00:00
Dominik Stadler a0248ff4f0 Bug 57007: Add initial implementations of DMIN and DGET functions
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1648166 13f79535-47bb-0310-9956-ffa450edef68
2014-12-28 10:47:41 +00:00
Dominik Stadler 0c580c8f45 Add a test-suite which performs integration/stress tests which load and handle all stored test files in various ways.
It works by using handlers for each type of file which perform various operations on the files, e.g. loading,
iterating content, modify, ... This will trigger changes which break working with the available test-files and
thus provides another layer of regression testing which hopefully prevents some failures from making it into
releases.

It is runnable via a new ant-target 'test-integration' and also added to the jenkins-target.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647885 13f79535-47bb-0310-9956-ffa450edef68
2014-12-25 09:16:44 +00:00
Dominik Stadler 1db7f3bd3b Bug 57362: Properly initialize chart axis when loading a workbook which already contains a chart.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647317 13f79535-47bb-0310-9956-ffa450edef68
2014-12-22 14:16:23 +00:00
Dominik Stadler 76b750b420 Bug 56511: Add missing sample-file
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647309 13f79535-47bb-0310-9956-ffa450edef68
2014-12-22 13:07:48 +00:00
Dominik Stadler 0b6867d1d5 Bug 56644: Fix adding cells if MissingCellPolicy is set to NULL_FOR_BLANK and the last column in a row is empty
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647291 13f79535-47bb-0310-9956-ffa450edef68
2014-12-22 11:11:34 +00:00
Dominik Stadler 0fdfac62c9 Bug 57171 and 57163: Adjust the active sheet in setSheetOrder() and removeSheet() for both HSSF and XSSF
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647264 13f79535-47bb-0310-9956-ffa450edef68
2014-12-22 09:00:18 +00:00
Dominik Stadler 76af8804d5 Bug 57231: Add missing ArrayRecord.clone()
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647255 13f79535-47bb-0310-9956-ffa450edef68
2014-12-22 08:17:56 +00:00
Dominik Stadler 12353bca7f Bug 57236: Add reproducer, although I am not sure if we should and how to fix this...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1647254 13f79535-47bb-0310-9956-ffa450edef68
2014-12-22 07:57:03 +00:00
Nick Burch 544b21405c Add some formatted numbers to the test biff5 files, and commented out tests using them
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1642559 13f79535-47bb-0310-9956-ffa450edef68
2014-11-30 16:01:28 +00:00
Nick Burch 101f66c789 Begin adding Excel 5 support to OldExcelExtractor for TIKA-1490
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1642548 13f79535-47bb-0310-9956-ffa450edef68
2014-11-30 14:22:06 +00:00
Nick Burch 48ab7bf987 Start on a Text Extractor for the pre-OLE2 Excel formats like Excel 4, for TIKA-1490
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1642490 13f79535-47bb-0310-9956-ffa450edef68
2014-11-30 00:16:23 +00:00
Andreas Beeker 45fb6c5b18 Picture method to resize with different scales in width and height
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1638623 13f79535-47bb-0310-9956-ffa450edef68
2014-11-12 00:19:00 +00:00
Dominik Stadler eb44db4d9c Bug 57003: Add implementation of function FIXED
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1637361 13f79535-47bb-0310-9956-ffa450edef68
2014-11-07 12:29:05 +00:00
Nick Burch 3300ac2a56 FilePassRecord type of 4 is now documented as the same as 2 & 3, see bug #35897
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1636776 13f79535-47bb-0310-9956-ffa450edef68
2014-11-04 23:22:50 +00:00
Nick Burch 663171c6c2 Add unit test for bug #57176
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1636634 13f79535-47bb-0310-9956-ffa450edef68
2014-11-04 16:20:05 +00:00
Dominik Stadler 2e283f2ebf Apply patch for bug 55864 - XSSFImportFromXML.importFromXML() does not support optional elements
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1633404 13f79535-47bb-0310-9956-ffa450edef68
2014-10-21 15:56:45 +00:00
Nick Burch f9754de0cd Add disabled unit tests for bug #46670 - failing on both HSSF and XSSF, but for different reasons
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1633257 13f79535-47bb-0310-9956-ffa450edef68
2014-10-20 23:22:02 +00:00
Dominik Stadler 8dde4b0ae4 Revert parts of an inadvertent previous checkin, keep build.xml and @Override changes
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1629653 13f79535-47bb-0310-9956-ffa450edef68
2014-10-06 13:39:35 +00:00
Dominik Stadler d254ec8ec1 Print out current version of java before building to allow to see in build output if we use a supported Java VM version
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1629644 13f79535-47bb-0310-9956-ffa450edef68
2014-10-06 13:20:12 +00:00
Andreas Beeker ff053aa4cd Bug 51483 - XSSF locking of specific features not working
Added some documentation to the crypto functions and adapted xor1verifier code to the OFFCrypto-Docs

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1622577 13f79535-47bb-0310-9956-ffa450edef68
2014-09-04 22:50:28 +00:00
Andreas Beeker 0cbbbfe5d5 Bug 51222 - XSSFColor.getARGBHex() returns wrong color for Excel 2007 xlsx file
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1621393 13f79535-47bb-0310-9956-ffa450edef68
2014-08-29 22:14:55 +00:00
Dominik Stadler 67fcf46d4c Bug 56730: Fix exporting XML if schema contains ref-elements
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1621209 13f79535-47bb-0310-9956-ffa450edef68
2014-08-28 21:41:30 +00:00
Nick Burch 07771c3d8c Add another test file for #54764, and a test that uses it
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1615731 13f79535-47bb-0310-9956-ffa450edef68
2014-08-04 19:18:20 +00:00
Nick Burch 236c3c52a9 Apply suggestions from Uwe Schindler for more secure xml defaults for #54764 and #56164, for xml parsers which support them
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1615720 13f79535-47bb-0310-9956-ffa450edef68
2014-08-04 18:17:26 +00:00
Nick Burch 0e44d8da73 Fix bug #56800 - Provide a helpful exception, XLSBUnsupportedException, if XSSFWorkbook is passed a .xlsb file
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1615118 13f79535-47bb-0310-9956-ffa450edef68
2014-08-01 14:33:17 +00:00
Nick Burch 4bfe3c6784 Fix bug #56502 - When shifting XSSF rows with formula cells, if the formula can't be parsed, log + leave it unchanged rather than failing
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614916 13f79535-47bb-0310-9956-ffa450edef68
2014-07-31 15:07:27 +00:00
Nick Burch 65e23c7ea9 Fix bug #53984 - Support the ColInfoRecord coming after the cells, rather than before as is normal, and also handle things so that if an unsupported BofRecord is found for a sheet, warn and skip rather than breaking
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614884 13f79535-47bb-0310-9956-ffa450edef68
2014-07-31 13:31:01 +00:00
Nick Burch bdb9bbccc1 Start on details tests for bug #53433
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614786 13f79535-47bb-0310-9956-ffa450edef68
2014-07-30 22:43:31 +00:00
Nick Burch fd68083ea0 Slightly modified test file for bug #56132 - xlsx file with inline references to other files (no external links used)
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614728 13f79535-47bb-0310-9956-ffa450edef68
2014-07-30 18:07:14 +00:00
Nick Burch 7844d4dafb Updated patch from Marc from #55927 - handle date formulas too
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614696 13f79535-47bb-0310-9956-ffa450edef68
2014-07-30 16:10:56 +00:00
Dominik Stadler a9f946ef70 Add simple unit test to verify that Bug 42016 was fixed already by some other fixes
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1614135 13f79535-47bb-0310-9956-ffa450edef68
2014-07-28 19:10:54 +00:00
Nick Burch a4e73e3dc8 Unit test to show that bug #52111 (intersect formulas) was already solved
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613737 13f79535-47bb-0310-9956-ffa450edef68
2014-07-26 22:39:16 +00:00
Nick Burch 5d9f8945c9 HSSF and XSSF Multi-Sheet formula reference tests from Radoslav from bug #55906
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613654 13f79535-47bb-0310-9956-ffa450edef68
2014-07-26 15:20:06 +00:00