Commit Graph

5445 Commits

Author SHA1 Message Date
Nick Burch 01b276b2f3 Allow formatting of formula error cells, giving back the error string that Excel shows #55729
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1537552 13f79535-47bb-0310-9956-ffa450edef68
2013-10-31 16:53:03 +00:00
Dominik Stadler d08ab9dc0d Slightly more test-coverage in HSSFSheet/XSSFSheet/SXSSFSheet and fix some Eclipse warnings
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1537331 13f79535-47bb-0310-9956-ffa450edef68
2013-10-30 22:26:13 +00:00
Dominik Stadler 3fdf865d88 Add scratchpad-resources to .classpath make TestExtractorFactory run in Eclipse
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1536065 13f79535-47bb-0310-9956-ffa450edef68
2013-10-27 08:33:59 +00:00
Dominik Stadler f82527ecb1 Re-use functionality from HSSFWorkbook in dev-tools to find the
dir-entry-name to make special names like WORKBOOK or BOOK work, handle
a special case in ExternalNameRecord when the flag states that there is
data, but no data remains in the stream, slightly improve error-output
in DirectoryNode, adjust all dev-tools-tests to not report stack-traces
any more for expected failures and try with HSSFWorkbook to decide if it
is an expected failure or now.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1536062 13f79535-47bb-0310-9956-ffa450edef68
2013-10-27 08:16:29 +00:00
Dominik Stadler 0342f9602d Add reproducer tests for Bug 53515, disabled as we do not fix any of the
reported issues. Also fix some Ecliipse warnings.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1535959 13f79535-47bb-0310-9956-ffa450edef68
2013-10-26 10:05:24 +00:00
Dominik Stadler 5644fcbaa0 Bug 49940: Apply patch to avoid XmlValueDisconnectedException when
saving a file twice and enable reproducing unit test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1535938 13f79535-47bb-0310-9956-ffa450edef68
2013-10-26 07:31:47 +00:00
Dominik Stadler 780aec8ad2 Add a number of tests for the dev-tools. The tests iterate over all .xls
files that are found under test-data, any newly added file or
code-change which breaks one of the dev-tools will cause the tests to
fail in the future. Known broken files can be excluded.

Also fixes two points where some files could cause BiffViewer to fail.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1535885 13f79535-47bb-0310-9956-ffa450edef68
2013-10-25 21:57:48 +00:00
Yegor Kozlov 616238f8e2 Patch 55612 - Performance improvement in HSSFCellStyle.getDataFormatString()
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1535810 13f79535-47bb-0310-9956-ffa450edef68
2013-10-25 18:41:24 +00:00
Dominik Stadler 5ad89d96b6 Fix some Eclipse warnings, remove trailing whitespaces
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1535517 13f79535-47bb-0310-9956-ffa450edef68
2013-10-24 19:58:19 +00:00
Nick Burch b646166b6c Have HSSFWorkbook check for an encrypted .xlsx file when opening, and give a helpful error if found, plus tests. Fixes #55692
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1534967 13f79535-47bb-0310-9956-ffa450edef68
2013-10-23 09:43:28 +00:00
Nick Burch 5ac455fd72 Patch from bug #55650 from Andrej - Avoid AIOOBE if a non-existant Xfs is requested for a styleAvoid AIOOBE if a non-existant Xfs is requested for a style
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1534818 13f79535-47bb-0310-9956-ffa450edef68
2013-10-22 22:04:16 +00:00
Nick Burch a32a1cf538 Try to make the eclipse classpath more general - place the output under /build/, remove hard coded jar source paths, re-order entries to make it easier to see what we have, and use the default JDK not a hard coded version
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1534750 13f79535-47bb-0310-9956-ffa450edef68
2013-10-22 19:35:41 +00:00
Dominik Stadler 1bf79ee0cf Bug 55369: Add support for collapsing rows in SXSSF
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1533932 13f79535-47bb-0310-9956-ffa450edef68
2013-10-20 18:04:08 +00:00
Yegor Kozlov 689f027749 Patch 55611 - Performance improvement in DateUtil.isADateFormat(int, String)
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1533768 13f79535-47bb-0310-9956-ffa450edef68
2013-10-19 14:12:15 +00:00
Yegor Kozlov 4243b72fc2 Patch 55611 - Performance improvement in DateUtil.isADateFormat(int, String)
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1533764 13f79535-47bb-0310-9956-ffa450edef68
2013-10-19 13:53:19 +00:00
Dominik Stadler c7ae557a5c Add Eclipse project files and settings to make it easier to start hacking on POI in Eclipse
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1532876 13f79535-47bb-0310-9956-ffa450edef68
2013-10-16 19:59:29 +00:00
Dominik Stadler 3b4538cfb4 Bug 55658: don't fail in SXSSF if a numeric cell is overwritten with a string
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1532873 13f79535-47bb-0310-9956-ffa450edef68
2013-10-16 19:47:21 +00:00
Dominik Stadler 9d98d6e309 Change from having actual zero bytes in java code to java-string notation for unicode-zero to avoid trouble with this file in Sonar when using PostgreSQL (which seems to fall over binary data in text files). The resulting test should be the same with the \u0000 notation
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1532037 13f79535-47bb-0310-9956-ffa450edef68
2013-10-14 19:44:30 +00:00
Yegor Kozlov cf7a4c117a Bugzilla 55578 - Support embedding OLE1.0 packages in HSSF
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531623 13f79535-47bb-0310-9956-ffa450edef68
2013-10-13 07:39:40 +00:00
Yegor Kozlov 489b0b5bdb Bugzilla 49658 - Support embedding EMF/WMF pictures in HSSF
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531622 13f79535-47bb-0310-9956-ffa450edef68
2013-10-13 07:20:36 +00:00
Cédric Walter 451d9eb4af Bug 55036: fixed red build (Dec2Hex)
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531506 13f79535-47bb-0310-9956-ffa450edef68
2013-10-12 06:28:51 +00:00
Cédric Walter 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
Cédric Walter 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
Cédric Walter 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
Cédric Walter 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
Cédric Walter 61f1130e38 Bug 55649: WORKDAY Function returns incorrect date when spanning a weekend, or the start date is a weekend
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531124 13f79535-47bb-0310-9956-ffa450edef68
2013-10-10 21:54:52 +00:00
Nick Burch f15a35ec45 Fix #55647 - When creating a temp file, ensure the name isn't already taken
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1531040 13f79535-47bb-0310-9956-ffa450edef68
2013-10-10 16:20:07 +00:00
Cédric Walter 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
Cédric Walter 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
Cédric Walter 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
Dominik Stadler 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
Tim Allison 3e1208af44 Potential NPE in PPExtractor; found while working on TIKA-1171
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1527041 13f79535-47bb-0310-9956-ffa450edef68
2013-09-27 19:35:14 +00:00
Tim Allison 1e8ffef6a6 increment build beta version to 3.10-beta3; forgot to as part of last release...doh.
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1526965 13f79535-47bb-0310-9956-ffa450edef68
2013-09-27 15:53:53 +00:00
Tim Allison 58dd7d7c0c POI-54722 table text in ppt files
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1526960 13f79535-47bb-0310-9956-ffa450edef68
2013-09-27 15:45:55 +00:00
Nick Burch ad8b09095e Support more hashing formats for OOXML protected documents, for bug #55544
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1522074 13f79535-47bb-0310-9956-ffa450edef68
2013-09-11 22:22:30 +00:00
Nick Burch 5c9f325bf3 Sample file from bug #55544 - encrypted with sha512 as the hash algorythm
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1522067 13f79535-47bb-0310-9956-ffa450edef68
2013-09-11 22:08:12 +00:00
Dominik Stadler 4a3c974e3b Remove Eclipse warnings, remove duplicate test, rename tests to also run tests in base class
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1521015 13f79535-47bb-0310-9956-ffa450edef68
2013-09-09 09:41:31 +00:00
Dominik Stadler 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
Dominik Stadler 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
Dominik Stadler 84ef8c5970 Fix regression introduced by r1516969
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1517180 13f79535-47bb-0310-9956-ffa450edef68
2013-08-24 18:33:00 +00:00
Dominik Stadler 18d369ed86 Exclude TestUnfixedBugs from OOXMLLite to avoid confusing output in ant-build of ooxml-lite
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1517179 13f79535-47bb-0310-9956-ffa450edef68
2013-08-24 18:32:45 +00:00
Nick Burch 673864cdc5 More unit tests for column conversion, and avoid the use of Math.pow based on the suggestion from github-6
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516983 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 19:00:01 +00:00
Dominik Stadler 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
Dominik Stadler 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
Dominik Stadler f8f998b80b Some Eclipse warnings removed
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516980 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:54:05 +00:00
Nick Burch 689aa10390 Add some explicit tests for column letter to/from number conversion
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516978 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:52:18 +00:00
Nick Burch 8b0334c701 Remove some @author tags, as per http://poi.apache.org/guidelines.html#CodeStyle
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516975 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:42:57 +00:00
Nick Burch f04c20ce5d Start to remove @author tags, as per http://poi.apache.org/guidelines.html#CodeStyle
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516973 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:36:41 +00:00
Nick Burch 95fb311279 Inspired by github pull-6, use a StringBuilder for quicker string appending
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516969 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 18:30:01 +00:00
Dominik Stadler bff0813e48 fix some Eclipse warnings, adjust some unit tests slightly
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1516818 13f79535-47bb-0310-9956-ffa450edef68
2013-08-23 10:44:39 +00:00