30d9106d9a
- Bug 51585 - WorkbookFactory.create() hangs when creating a workbook
...
- 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
2014-01-26 02:18:53 +00:00
1eba8faedb
Bug 35897 - Password protected files
...
+ Junit4 modifications, needed for expected exceptions
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1557281 13f79535-47bb-0310-9956-ffa450edef68
2014-01-10 23:14:03 +00:00
2a08a1dd10
Bug 55850: fix NullPointerException during extraction from XSSF
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1549007 13f79535-47bb-0310-9956-ffa450edef68
2013-12-08 08:35:20 +00:00
18f9a3e88e
Bug 55640, added reproducer, a fix for the Exception cases and some 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
2013-12-02 19:14:03 +00:00
6618473e64
Bug 55745: fix handling of tables in XSSF if there are comments as well, 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
2013-11-28 15:15:59 +00:00
4ae76ffddc
Unit tests for Shrink To Fit cell style support ( #55661 )
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539850 13f79535-47bb-0310-9956-ffa450edef68
2013-11-07 22:39:11 +00:00
d45b6acef3
Patch from Andreas Beeker from bug #49237 - HSSF Row Style XfIndex is 12 not 16 bits of data
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539837 13f79535-47bb-0310-9956-ffa450edef68
2013-11-07 21:56:49 +00:00
224b66e8d4
Bug 55742: fixed mirr FormulaEvalTestData.xls tests
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539451 13f79535-47bb-0310-9956-ffa450edef68
2013-11-06 20:09:43 +00:00
fc086aba47
Bug 55724: implementation of Excel PERCENTILE function
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1539154 13f79535-47bb-0310-9956-ffa450edef68
2013-11-05 22:11:18 +00:00
d8c54be1aa
Bug 55024: MIRR Formula implementation review, added error handling and FormulaEvalTest.xls
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538795 13f79535-47bb-0310-9956-ffa450edef68
2013-11-04 22:52:06 +00:00
eab0adda8b
Bug 54535: Bug in INTERCEPT and SLOPE, review and integration test added to FormulaEvalTestData.xls
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538772 13f79535-47bb-0310-9956-ffa450edef68
2013-11-04 21:27:12 +00:00
6cb3b01753
Bug 55742: Apply patch for Oct2Dec and refactor Hex2Dec to also use BaseNumberUtils.convertToDecimal
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538765 13f79535-47bb-0310-9956-ffa450edef68
2013-11-04 21:09:40 +00:00
8d345b13d0
Fix Bug 54400 by updating the index in the LinkTable whenever sheets are
...
removed.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1538163 13f79535-47bb-0310-9956-ffa450edef68
2013-11-02 10:01:01 +00:00
b43a685b6c
Bug 55036: patch for missing function Dec2HEx
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531395 13f79535-47bb-0310-9956-ffa450edef68
2013-10-11 19:16:43 +00:00
1d8a31724a
Bug 55057: patch for missing function Hex2Dec
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531393 13f79535-47bb-0310-9956-ffa450edef68
2013-10-11 19:06:33 +00:00
c70043f1d5
Bug 55116: patch for missing function Dec2Bin
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531390 13f79535-47bb-0310-9956-ffa450edef68
2013-10-11 18:49:19 +00:00
be144a48fd
Bug 55055: patch for missing function Bin2Dec
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531386 13f79535-47bb-0310-9956-ffa450edef68
2013-10-11 18:39:22 +00:00
ed1fc84a38
Bug 55058: patch for missing function FactDouble
...
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
2013-10-10 10:10:54 +00:00
8c2e38892e
Bug 55081: patch for missing function WEEKNUM
...
Add simple spreadsheet with Excel 2003, and another with 2013 (both fresh files)
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1530256 13f79535-47bb-0310-9956-ffa450edef68
2013-10-08 12:54:35 +00:00
f49f20daec
Bug 55037: patch for missing function DELTA
...
Add missing TestDeltaFunctionsFromSpreadsheet and register Delta in AnalysisToolPak
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1529809 13f79535-47bb-0310-9956-ffa450edef68
2013-10-07 09:42:38 +00:00
43b74b0253
Apply patch from bug 55341
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1527397 13f79535-47bb-0310-9956-ffa450edef68
2013-09-29 20:23:20 +00:00
e6ed66a126
Bug 53798: Add fix for XmlValueDisconnectException during shifting rows
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1521012 13f79535-47bb-0310-9956-ffa450edef68
2013-09-09 09:24:05 +00:00
17e8880dcd
Bug 54524: Fix border case in FormulaShifter
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1517676 13f79535-47bb-0310-9956-ffa450edef68
2013-08-26 20:09:19 +00:00
b79d4fda52
Tried to reproduce Bug 47090, but seems to be fixed now.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516982 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:56:32 +00:00
13e08c3e92
Add testcase which tries to reproduce Bug 48495, but seems to be fixed
...
now.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516981 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:56:11 +00:00
1249614bc8
Bug 50298: Fix corruption of Workbook when setting sheet order. The
...
boundssheets themselves were adjusted, but not the corresponding
records.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516313 13f79535-47bb-0310-9956-ffa450edef68
2013-08-21 22:08:20 +00:00
72d3a7d2a3
Bug 55043: patch for missing function QUOTIENT
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1514847 13f79535-47bb-0310-9956-ffa450edef68
2013-08-16 18:54:35 +00:00
67f198e752
Bug 55082: patch for missing function ROMAN
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1514834 13f79535-47bb-0310-9956-ffa450edef68
2013-08-16 18:28:18 +00:00
7962fc2a9e
Bug 55080: patch for missing function IMREAL
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1514830 13f79535-47bb-0310-9956-ffa450edef68
2013-08-16 18:13:40 +00:00
aba46897dc
Bug 55079: patch for missing function IMAGINARY
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1514824 13f79535-47bb-0310-9956-ffa450edef68
2013-08-16 17:59:01 +00:00
a727830c61
Bug 54720: Support for Row/Col Area Range like 8:8 or H:H
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1514812 13f79535-47bb-0310-9956-ffa450edef68
2013-08-16 17:35:16 +00:00
09555c446b
POI-55292
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1508691 13f79535-47bb-0310-9956-ffa450edef68
2013-07-31 00:19:07 +00:00
9b4c6724fa
testing svn commit with test doc for 55292
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1508158 13f79535-47bb-0310-9956-ffa450edef68
2013-07-29 18:15:20 +00:00
6367b8b74e
Add reproducing unit tests to TestUnfixedBugs for Bug 53798 and Bug 54071
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1501263 13f79535-47bb-0310-9956-ffa450edef68
2013-07-09 13:55:54 +00:00
067c62168e
Bug 54084: Add testcase which reproduces the bug, no fix available yet
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1498190 13f79535-47bb-0310-9956-ffa450edef68
2013-06-30 22:47:26 +00:00
dbd1a59416
Patch from Andrew Novikov from bug #53972 - Presence of PLV record shouldn't affect HSSF Data Validation
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1496499 13f79535-47bb-0310-9956-ffa450edef68
2013-06-25 14:48:16 +00:00
cb4dfced34
Patch and unit test from Tim Allen from bug #54686 - Improve how DataFormatter handles fractions
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1494986 13f79535-47bb-0310-9956-ffa450edef68
2013-06-20 13:37:26 +00:00
426a6f3451
Bug 54607: Add unit test and fix NPE for getTopRow() and getLeftCol()
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1493686 13f79535-47bb-0310-9956-ffa450edef68
2013-06-17 09:06:39 +00:00
2135b0741c
Bug 55047: REPT formula support
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1488811 13f79535-47bb-0310-9956-ffa450edef68
2013-06-02 23:39:41 +00:00
abd5fcd939
missing tests for Bug 55041 - CODE formula support
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1488810 13f79535-47bb-0310-9956-ffa450edef68
2013-06-02 23:32:24 +00:00
ecb8b8240c
added missing tests for Bug 55042: patch for missing function COMPLEX
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1488808 13f79535-47bb-0310-9956-ffa450edef68
2013-06-02 23:25:07 +00:00
76fac97865
Bug 54673 - [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1457243 13f79535-47bb-0310-9956-ffa450edef68
2013-03-16 12:33:08 +00:00
decfde00ff
Bugzilla 54469 - Support for financial functions IPMT and PPMT
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1451886 13f79535-47bb-0310-9956-ffa450edef68
2013-03-02 13:17:53 +00:00
e80c3aabc1
Bugzilla 54436: Fixed metadata for GETPIVOTDATA function
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1451875 13f79535-47bb-0310-9956-ffa450edef68
2013-03-02 11:38:09 +00:00
8d7d3f54c0
Fix bug #54506 - Add "BOOK" to the list of unusual-but-largely-ok Workbook directory entry names list, alongside WORKBOOK, plus tests
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1443745 13f79535-47bb-0310-9956-ffa450edef68
2013-02-07 21:53:07 +00:00
0023138765
Bugzilla 54356: Support of statistical function INTERCEPT
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1426485 13f79535-47bb-0310-9956-ffa450edef68
2012-12-28 12:50:15 +00:00
5b76ca72b6
Bugs 54228,53672 - Fixed XSSF to read cells with missing R attribute
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1417379 13f79535-47bb-0310-9956-ffa450edef68
2012-12-05 12:21:08 +00:00
7d6b730202
Bug 54206: ValueRecordsAggregate.updateFormulasAfterRowShift doesn't update shared formulas
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1416917 13f79535-47bb-0310-9956-ffa450edef68
2012-12-04 12:44:33 +00:00
baa610fa5e
removed svn:executable from test files
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1413341 13f79535-47bb-0310-9956-ffa450edef68
2012-11-25 12:19:05 +00:00
489a9b47f3
Bug #53282 - Avoid exception when parsing OPC relationships with non-breaking spaces
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1403195 13f79535-47bb-0310-9956-ffa450edef68
2012-10-29 08:42:54 +00:00
Andreas Beeker