aboutsummaryrefslogtreecommitdiffstats
path: root/test-data/spreadsheet
Commit message (Collapse)AuthorAgeFilesLines
* HSSF and XSSF Multi-Sheet formula reference tests from Radoslav from bug #55906Nick Burch2014-07-262-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613654 13f79535-47bb-0310-9956-ffa450edef68
* More tests for #55906, and provide a new eval that lets you get at evals for ↵Nick Burch2014-07-252-0/+0
| | | | | | many sheets git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613438 13f79535-47bb-0310-9956-ffa450edef68
* Areas can have multi-sheet references too, so add FormulaParser support to ↵Nick Burch2014-07-252-0/+0
| | | | | | these as well git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613437 13f79535-47bb-0310-9956-ffa450edef68
* Disabled unit tests for multi-sheet references, see bug #55906Nick Burch2014-07-242-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613282 13f79535-47bb-0310-9956-ffa450edef68
* Patch from Shaun Kalley from bug #56023 - Allow XSSF event model to find + ↵Nick Burch2014-07-241-0/+0
| | | | | | return comments, and use this for the event based .xlsx text extractor git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613266 13f79535-47bb-0310-9956-ffa450edef68
* Bug 56688: Fix border cases in EDATE function: handle RefEval and BlankEval ↵Dominik Stadler2014-07-224-0/+0
| | | | | | and also return #VALUE, not #REF if case of error git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612557 13f79535-47bb-0310-9956-ffa450edef68
* Turns out that .xlsx files can have multiple link tables, add a test file ↵Nick Burch2014-07-191-0/+0
| | | | | | which shows this (support to follow) git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611878 13f79535-47bb-0310-9956-ffa450edef68
* Bit more towards XSSF name support for #56737, will need some deeper changes ↵Nick Burch2014-07-181-0/+0
| | | | | | though to fully implement git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611830 13f79535-47bb-0310-9956-ffa450edef68
* Add disabled unit tests for bug #56737, which currently fails (differently) ↵Nick Burch2014-07-172-0/+0
| | | | | | for HSSF and XSSF git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611400 13f79535-47bb-0310-9956-ffa450edef68
* Fix for #56702 - If a cell is of type numeric but has an empty <v/> tag, ↵Nick Burch2014-07-141-0/+0
| | | | | | return as 0 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1610482 13f79535-47bb-0310-9956-ffa450edef68
* Add a disabled unit test for bug #56420Nick Burch2014-07-031-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607661 13f79535-47bb-0310-9956-ffa450edef68
* Fix for 56563 - Multithreading bug when reading 2 similar filesDominik Stadler2014-05-262-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1597637 13f79535-47bb-0310-9956-ffa450edef68
* Handle date format strings in an iso8601 style format, with a T in them. ↵Nick Burch2014-05-231-0/+0
| | | | | | Fixes bug #54034 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1597038 13f79535-47bb-0310-9956-ffa450edef68
* Patch from Yaniv Kunda from bug #56274 - Fix SXSSF writing of tables when ↵Nick Burch2014-05-211-0/+0
| | | | | | creating from a template git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1596624 13f79535-47bb-0310-9956-ffa450edef68
* Bug 53691: Fix a copy/paste error in CFRuleRecord.clone()Dominik Stadler2014-05-201-0/+0
| | | | | | | also make CFRuleRecord.toString() print out more information which caused the bug to be much harder to find Add unit tests to verify/reproduce this git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1596251 13f79535-47bb-0310-9956-ffa450edef68
* Bug 56170: Fix a problem with cells in workbooks becoming disconnected from ↵Dominik Stadler2014-05-181-0/+0
| | | | | | XMLBeans whenever columns need to be reordered during writing the file. This happens because setCArray() disconnects any previously stored array-item but we try to re-use them. So we need to recreate the CTCell and set it in the XSSFCell to make this work in all currently tested cases. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1595659 13f79535-47bb-0310-9956-ffa450edef68
* Fix Bug 56514, add missing null-check if simple shape does not have any textDominik Stadler2014-05-161-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1595127 13f79535-47bb-0310-9956-ffa450edef68
* Bug 56325: fix Exception when removing sheets with named ranges in the workbookDominik Stadler2014-05-151-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1595048 13f79535-47bb-0310-9956-ffa450edef68
* Excel 2007 and later allows for more than 3 Conditional Formatting rules per ↵Nick Burch2014-05-021-0/+0
| | | | | | sheet, so change our hard limit to logging a compatibility warning. Test file from Pau Coma Ramirez from bug #56482 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1591959 13f79535-47bb-0310-9956-ffa450edef68
* Fix bug #56450 - Avoid a NPE if a comment has no associated NoteRecord (but ↵Nick Burch2014-04-241-0/+0
| | | | | | we still don't know where it belongs) git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1589770 13f79535-47bb-0310-9956-ffa450edef68
* Bug 56315: Make rounding in MathX.round() behave equal to Excel, ↵Dominik Stadler2014-04-181-0/+0
| | | | | | adjust/enhance some more tests in MathX git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1588538 13f79535-47bb-0310-9956-ffa450edef68
* Add another test file for bug #47251, from Joe Yuan, and a disabled testNick Burch2014-04-011-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1583825 13f79535-47bb-0310-9956-ffa450edef68
* Fix bug #56278 - Support loading .xlsx files with no Styles TableNick Burch2014-03-171-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1578518 13f79535-47bb-0310-9956-ffa450edef68
* Add missing test-file for bug 56169Dominik Stadler2014-03-151-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1577908 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55923: Fix compare/sorting of nodes in exported XMLDominik Stadler2014-02-031-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1564050 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55924: Avoid errors during exporting XML if there are numeric cells ↵Dominik Stadler2014-02-031-0/+0
| | | | | | without value, also verify in tests that XML can always be parsed git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1564045 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55926: Handle numeric formula values when exporting to XMLDominik Stadler2014-02-031-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1564028 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55927: Handle date types when exporting to XMLDominik Stadler2014-02-031-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1564011 13f79535-47bb-0310-9956-ffa450edef68
* Patch from Shaun Kalley from bug #56022 - XSSF Event Text Extractor ↵Nick Burch2014-02-021-0/+0
| | | | | | header/footer support git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1563657 13f79535-47bb-0310-9956-ffa450edef68
* Add missing test-file for Bug 56017Dominik Stadler2014-02-021-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1563588 13f79535-47bb-0310-9956-ffa450edef68
* Bug 53282 - Hyperlink with a non-breaking space throws ↵Andreas Beeker2014-02-021-0/+0
| | | | | | java.lang.IllegalStateException git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1563540 13f79535-47bb-0310-9956-ffa450edef68
* Bug 56011: Use default style if the cell style attribute is not presentDominik Stadler2014-02-011-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1563470 13f79535-47bb-0310-9956-ffa450edef68
* - Bug 51585 - WorkbookFactory.create() hangs when creating a workbookAndreas Beeker2014-01-261-0/+0
| | | | | | | - adapted relevant test-classes to Junit4 to support timeout handling - tab / space cleanup git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1561435 13f79535-47bb-0310-9956-ffa450edef68
* Bug 35897 - Password protected filesAndreas Beeker2014-01-101-0/+0
| | | | | | + Junit4 modifications, needed for expected exceptions git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1557281 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55850: fix NullPointerException during extraction from XSSFDominik Stadler2013-12-081-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1549007 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55640, added reproducer, a fix for the Exception cases and some ↵Dominik Stadler2013-12-022-0/+0
| | | | | | | | | verify-tests to ensure future changes are checked via unit tests. There might be more work pending to make grouping fully work the same way as Excel does. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1547153 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55745: fix handling of tables in XSSF if there are comments as well, ↵Dominik Stadler2013-11-281-0/+0
| | | | | | there is not much sense in leaving the loop on the first instance of comment table and skipping all the other tables. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1546385 13f79535-47bb-0310-9956-ffa450edef68
* Unit tests for Shrink To Fit cell style support (#55661)Nick Burch2013-11-072-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539850 13f79535-47bb-0310-9956-ffa450edef68
* Patch from Andreas Beeker from bug #49237 - HSSF Row Style XfIndex is 12 not ↵Nick Burch2013-11-071-0/+0
| | | | | | 16 bits of data git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539837 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55742: fixed mirr FormulaEvalTestData.xls testsCédric Walter2013-11-061-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539451 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55724: implementation of Excel PERCENTILE functionCédric Walter2013-11-051-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539154 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55024: MIRR Formula implementation review, added error handling and ↵Cédric Walter2013-11-042-0/+0
| | | | | | FormulaEvalTest.xls git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538795 13f79535-47bb-0310-9956-ffa450edef68
* Bug 54535: Bug in INTERCEPT and SLOPE, review and integration test added to ↵Cédric Walter2013-11-041-0/+0
| | | | | | FormulaEvalTestData.xls git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538772 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55742: Apply patch for Oct2Dec and refactor Hex2Dec to also use ↵Cédric Walter2013-11-041-0/+0
| | | | | | BaseNumberUtils.convertToDecimal git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538765 13f79535-47bb-0310-9956-ffa450edef68
* Fix Bug 54400 by updating the index in the LinkTable whenever sheets areDominik Stadler2013-11-021-0/+0
| | | | | | removed. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538163 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55036: patch for missing function Dec2HExCédric Walter2013-10-111-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531395 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55057: patch for missing function Hex2DecCédric Walter2013-10-111-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531393 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55116: patch for missing function Dec2BinCédric Walter2013-10-111-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531390 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55055: patch for missing function Bin2DecCédric Walter2013-10-111-0/+0
| | | | git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531386 13f79535-47bb-0310-9956-ffa450edef68
* Bug 55058: patch for missing function FactDoubleCédric Walter2013-10-102-0/+0
| | | | | | | | | | | | | | | Returns the double factorial of a number: FACTDOUBLE(number) Number is the value for which to return the double factorial. If number is not an integer, it is truncated. Remarks If number is nonnumeric, FACTDOUBLE returns the #VALUE! error value. If number is negative, FACTDOUBLE returns the #NUM! error value. Has a cache for more speed of previously calculated factorial Add additional sanity check/integration test FormulaEvalTestData.xls git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1530907 13f79535-47bb-0310-9956-ffa450edef68
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-01 17:07:14 +0000