]> source.dussan.org Git - poi.git/log
poi.git
10 years agoUnit test to show that bug #52111 (intersect formulas) was already solved
Nick Burch [Sat, 26 Jul 2014 22:39:16 +0000 (22:39 +0000)]
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

10 years agoHSSF and XSSF Multi-Sheet formula reference tests from Radoslav from bug #55906
Nick Burch [Sat, 26 Jul 2014 15:20:06 +0000 (15:20 +0000)]
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

10 years agoComplete evaluation support for multi-sheet references for bug #55906
Nick Burch [Fri, 25 Jul 2014 16:42:31 +0000 (16:42 +0000)]
Complete evaluation support for multi-sheet references for bug #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613467 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBegin required interface + base-class support for multi-sheet area references for...
Nick Burch [Fri, 25 Jul 2014 16:15:47 +0000 (16:15 +0000)]
Begin required interface + base-class support for multi-sheet area references for #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613460 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAllow XSSF to evaluate multi-sheet references too, for #55906
Nick Burch [Fri, 25 Jul 2014 15:55:49 +0000 (15:55 +0000)]
Allow XSSF to evaluate multi-sheet references too, for #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613455 13f79535-47bb-0310-9956-ffa450edef68

10 years agoSplit the reference and area tests for #55906
Nick Burch [Fri, 25 Jul 2014 15:49:35 +0000 (15:49 +0000)]
Split the reference and area tests for #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613454 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate the RefEval method signature to cope with multi-sheet references, and have...
Nick Burch [Fri, 25 Jul 2014 15:46:05 +0000 (15:46 +0000)]
Update the RefEval method signature to cope with multi-sheet references, and have appropriate functions take advantage of this. For bug #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613453 13f79535-47bb-0310-9956-ffa450edef68

10 years agoStart preparing LazyAreaEval and LazyRefEval to handle sheet ranges, for #55906
Nick Burch [Fri, 25 Jul 2014 14:50:44 +0000 (14:50 +0000)]
Start preparing LazyAreaEval and LazyRefEval to handle sheet ranges, for #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613443 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate the XSSF getExternalSheet method signature, to start to prepare for sheet...
Nick Burch [Fri, 25 Jul 2014 14:23:21 +0000 (14:23 +0000)]
Update the XSSF getExternalSheet method signature, to start to prepare for sheet ranges

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613439 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMore tests for #55906, and provide a new eval that lets you get at evals for many...
Nick Burch [Fri, 25 Jul 2014 14:15:56 +0000 (14:15 +0000)]
More tests for #55906, and provide a new eval that lets you get at evals for many sheets

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613438 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAreas can have multi-sheet references too, so add FormulaParser support to these...
Nick Burch [Fri, 25 Jul 2014 13:59:07 +0000 (13:59 +0000)]
Areas can have multi-sheet references too, so add FormulaParser support to these as well

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613437 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate Ref3DPxg to support multi-sheet ranges too, for #55906
Nick Burch [Fri, 25 Jul 2014 10:22:21 +0000 (10:22 +0000)]
Update Ref3DPxg to support multi-sheet ranges too, for #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613376 13f79535-47bb-0310-9956-ffa450edef68

10 years agoRefactor to reduce clutter
Nick Burch [Fri, 25 Jul 2014 10:10:52 +0000 (10:10 +0000)]
Refactor to reduce clutter

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613374 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMore progress towards #55906 - Have the ExternSheet references set up for multi-sheet...
Nick Burch [Fri, 25 Jul 2014 10:05:57 +0000 (10:05 +0000)]
More progress towards #55906 - Have the ExternSheet references set up for multi-sheet references

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613373 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMore progress towards #55906 - FormulaParser is able to identify and parse multi...
Nick Burch [Thu, 24 Jul 2014 22:44:51 +0000 (22:44 +0000)]
More progress towards #55906 - FormulaParser is able to identify and parse multi-sheet references, but not yet fully round-trip them. (No evaluation support yet either)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613317 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMore internal method signature updates, for HSSF external sheets being possible range...
Nick Burch [Thu, 24 Jul 2014 21:35:47 +0000 (21:35 +0000)]
More internal method signature updates, for HSSF external sheets being possible ranges, for #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613307 13f79535-47bb-0310-9956-ffa450edef68

10 years agoRename some of the internal HSSF sheet lookup methods which deal with external sheet...
Nick Burch [Thu, 24 Jul 2014 21:25:45 +0000 (21:25 +0000)]
Rename some of the internal HSSF sheet lookup methods which deal with external sheet indicies, to make it clear when they return the first sheet name/index, and add support for getting the last one too (will be the same as the first if not a range)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613305 13f79535-47bb-0310-9956-ffa450edef68

10 years ago#55906 Extern Sheet References can have a last as well as a first sheet
Nick Burch [Thu, 24 Jul 2014 21:10:13 +0000 (21:10 +0000)]
#55906 Extern Sheet References can have a last as well as a first sheet

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613302 13f79535-47bb-0310-9956-ffa450edef68

10 years agoDisabled unit tests for multi-sheet references, see bug #55906
Nick Burch [Thu, 24 Jul 2014 20:48:29 +0000 (20:48 +0000)]
Disabled unit tests for multi-sheet references, see bug #55906

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613282 13f79535-47bb-0310-9956-ffa450edef68

10 years agoPatch from Shaun Kalley from bug #56023 - Allow XSSF event model to find + return...
Nick Burch [Thu, 24 Jul 2014 20:13:54 +0000 (20:13 +0000)]
Patch from Shaun Kalley from bug #56023 - Allow XSSF event model to find + 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

10 years agoPatch from thaichat04 from bug #56194 - HPSF thumbnail format tags are int not unit
Nick Burch [Thu, 24 Jul 2014 19:34:19 +0000 (19:34 +0000)]
Patch from thaichat04 from bug #56194 - HPSF thumbnail format tags are int not unit

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613256 13f79535-47bb-0310-9956-ffa450edef68

10 years agoPatch from Raúl Wegmann from bug #56735 / GitHub Pull #10 - Rationalise POI temp...
Nick Burch [Thu, 24 Jul 2014 18:58:27 +0000 (18:58 +0000)]
Patch from Raúl Wegmann from bug #56735 / GitHub Pull #10 - Rationalise POI temp file creation to the TempFile util class, and allow a system wide setting of where Temp files (eg for SXSSF) go, via TempFile / TempFileCreationStrategy

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613246 13f79535-47bb-0310-9956-ffa450edef68

10 years agoTo avoid problems on strange platforms, tell xmlbeans to use UTF-8 for strings by...
Nick Burch [Thu, 24 Jul 2014 17:14:00 +0000 (17:14 +0000)]
To avoid problems on strange platforms, tell xmlbeans to use UTF-8 for strings by default, for bug #56683

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613193 13f79535-47bb-0310-9956-ffa450edef68

10 years agoXSSF table example, from Sofia Larsson from bug #55562
Nick Burch [Thu, 24 Jul 2014 17:09:23 +0000 (17:09 +0000)]
XSSF table example, from Sofia Larsson from bug #55562

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613191 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFor places where an ordered collection is created and used within the context of...
Nick Burch [Thu, 24 Jul 2014 16:41:43 +0000 (16:41 +0000)]
For places where an ordered collection is created and used within the context of a single thread, and there are no thread safety concerns, use ArrayList not Vector. See bug #54838

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613186 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix javadoc warning
Nick Burch [Thu, 24 Jul 2014 16:26:34 +0000 (16:26 +0000)]
Fix javadoc warning

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613176 13f79535-47bb-0310-9956-ffa450edef68

10 years agoCorrect HSSFOptimiser logic for the case where the to-keep style wasn't previously...
Nick Burch [Thu, 24 Jul 2014 16:25:58 +0000 (16:25 +0000)]
Correct HSSFOptimiser logic for the case where the to-keep style wasn't previously in use. Fixes #54443

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613175 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix inconsistent whitespace
Nick Burch [Thu, 24 Jul 2014 16:22:28 +0000 (16:22 +0000)]
Fix inconsistent whitespace

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613174 13f79535-47bb-0310-9956-ffa450edef68

10 years agoWhen evaluating a name in another workbook, need to use an OperationEvaluationContext...
Nick Burch [Thu, 24 Jul 2014 14:56:23 +0000 (14:56 +0000)]
When evaluating a name in another workbook, need to use an OperationEvaluationContext tied to that Workbook, and do so such that XSSF references work too

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613154 13f79535-47bb-0310-9956-ffa450edef68

10 years agoDon't fetch the name, convert to a ptg, then convert back again, instead simply retur...
Nick Burch [Thu, 24 Jul 2014 14:37:09 +0000 (14:37 +0000)]
Don't fetch the name, convert to a ptg, then convert back again, instead simply return the name directly

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1613153 13f79535-47bb-0310-9956-ffa450edef68

10 years agoGet further with the XSSF formula reference evaluation testing
Nick Burch [Wed, 23 Jul 2014 19:09:45 +0000 (19:09 +0000)]
Get further with the XSSF formula reference evaluation testing

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612926 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFurther XSSF external name evaluation lookup support
Nick Burch [Wed, 23 Jul 2014 19:09:25 +0000 (19:09 +0000)]
Further XSSF external name evaluation lookup support

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612925 13f79535-47bb-0310-9956-ffa450edef68

10 years agoJaCoCo 0.7.x requires asm-5
Dominik Stadler [Wed, 23 Jul 2014 17:41:40 +0000 (17:41 +0000)]
JaCoCo 0.7.x requires asm-5

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612887 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix test to make it work on different date as well
Dominik Stadler [Wed, 23 Jul 2014 07:55:48 +0000 (07:55 +0000)]
Fix test to make it work on different date as well

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612786 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBug 56688: Fix border cases in EDATE function: handle RefEval and BlankEval and also...
Dominik Stadler [Tue, 22 Jul 2014 12:31:56 +0000 (12:31 +0000)]
Bug 56688: Fix border cases in EDATE function: handle RefEval and BlankEval 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

10 years agoFix formatting of trailing comma in HexDumps, cover class fully with tests
Dominik Stadler [Tue, 22 Jul 2014 07:47:14 +0000 (07:47 +0000)]
Fix formatting of trailing comma in HexDumps, cover class fully with tests

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612496 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUse the link table when looking up external xssf names
Nick Burch [Mon, 21 Jul 2014 16:52:19 +0000 (16:52 +0000)]
Use the link table when looking up external xssf names

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612347 13f79535-47bb-0310-9956-ffa450edef68

10 years agoGeneralise the CollaboratingWorkbooksEnvironment setup, so that XSSF can use it too
Nick Burch [Mon, 21 Jul 2014 12:23:54 +0000 (12:23 +0000)]
Generalise the CollaboratingWorkbooksEnvironment setup, so that XSSF can use it too

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612254 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix inconsistent whitespace
Nick Burch [Mon, 21 Jul 2014 09:45:44 +0000 (09:45 +0000)]
Fix inconsistent whitespace

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612219 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAllow creating a CollaboratingWorkbooksEnvironment from a Map too, not only a pair...
Nick Burch [Mon, 21 Jul 2014 09:44:21 +0000 (09:44 +0000)]
Allow creating a CollaboratingWorkbooksEnvironment from a Map too, not only a pair of arrays

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612218 13f79535-47bb-0310-9956-ffa450edef68

10 years agoCorrect non-sheet-based NameXPxg formula rendering, and add tests
Nick Burch [Mon, 21 Jul 2014 07:35:09 +0000 (07:35 +0000)]
Correct non-sheet-based NameXPxg formula rendering, and add tests

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612203 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMore unit tests for #56737 and #56752
Nick Burch [Sun, 20 Jul 2014 19:24:42 +0000 (19:24 +0000)]
More unit tests for #56737 and #56752

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612157 13f79535-47bb-0310-9956-ffa450edef68

10 years agoComments updates
Nick Burch [Sun, 20 Jul 2014 19:13:45 +0000 (19:13 +0000)]
Comments updates

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612156 13f79535-47bb-0310-9956-ffa450edef68

10 years agoChange how we update sheet names in XSSF formulas and names, when renaming sheets...
Nick Burch [Sun, 20 Jul 2014 18:56:35 +0000 (18:56 +0000)]
Change how we update sheet names in XSSF formulas and names, when renaming sheets, to take advantage of the simpler structure that Pxg now offers

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612151 13f79535-47bb-0310-9956-ffa450edef68

10 years agoXSSF Pxgs must escape sheet names where required when generating the formula string
Nick Burch [Sun, 20 Jul 2014 18:53:27 +0000 (18:53 +0000)]
XSSF Pxgs must escape sheet names where required when generating the formula string

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612150 13f79535-47bb-0310-9956-ffa450edef68

10 years agoCommon interface across the XSSF Ptg / Pxg classes
Nick Burch [Sun, 20 Jul 2014 18:48:48 +0000 (18:48 +0000)]
Common interface across the XSSF Ptg / Pxg classes

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612149 13f79535-47bb-0310-9956-ffa450edef68

10 years agoRename missing from previous commit
Nick Burch [Sun, 20 Jul 2014 18:14:47 +0000 (18:14 +0000)]
Rename missing from previous commit

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612140 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate the formula evaluator to support XSSF style external named ranges too
Nick Burch [Sun, 20 Jul 2014 17:51:51 +0000 (17:51 +0000)]
Update the formula evaluator to support XSSF style external named ranges too

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1612133 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBetter reporting on why a test is failing, and partial NameXPxg eval
Nick Burch [Sat, 19 Jul 2014 21:27:28 +0000 (21:27 +0000)]
Better reporting on why a test is failing, and partial NameXPxg eval

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611969 13f79535-47bb-0310-9956-ffa450edef68

10 years agoComplete the XSSF Formula Parser tests for #56737
Nick Burch [Sat, 19 Jul 2014 21:00:21 +0000 (21:00 +0000)]
Complete the XSSF Formula Parser tests for #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611963 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMove towards supporting same workbook named ranges in external style for xssf
Nick Burch [Sat, 19 Jul 2014 20:51:23 +0000 (20:51 +0000)]
Move towards supporting same workbook named ranges in external style for xssf

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611961 13f79535-47bb-0310-9956-ffa450edef68

10 years agoStart to add XSSF specific handling for NameX (named ranges or functions from another...
Nick Burch [Sat, 19 Jul 2014 20:30:31 +0000 (20:30 +0000)]
Start to add XSSF specific handling for NameX (named ranges or functions from another file) #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611958 13f79535-47bb-0310-9956-ffa450edef68

10 years agoProvide XSSF-style external sheet support for areas, similar to the recent cell refer...
Nick Burch [Sat, 19 Jul 2014 19:42:07 +0000 (19:42 +0000)]
Provide XSSF-style external sheet support for areas, similar to the recent cell reference support. #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611950 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix inconsistent indents/whitespace
Nick Burch [Sat, 19 Jul 2014 19:23:13 +0000 (19:23 +0000)]
Fix inconsistent indents/whitespace

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611949 13f79535-47bb-0310-9956-ffa450edef68

10 years agoStart to update how the formula parser looks up sheets from formula ptgs, to account...
Nick Burch [Sat, 19 Jul 2014 19:19:06 +0000 (19:19 +0000)]
Start to update how the formula parser looks up sheets from formula ptgs, to account for the differences in how HSSF and XSSF store references to external sheets. For #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611948 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix inconsistent indents
Nick Burch [Sat, 19 Jul 2014 19:11:54 +0000 (19:11 +0000)]
Fix inconsistent indents

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611947 13f79535-47bb-0310-9956-ffa450edef68

10 years agoThe Event User Model fake-workbook for formula evaluations needs to know about the...
Nick Burch [Sat, 19 Jul 2014 19:10:47 +0000 (19:10 +0000)]
The Event User Model fake-workbook for formula evaluations needs to know about the sheet names

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611946 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix Generics warnings
Nick Burch [Sat, 19 Jul 2014 19:00:09 +0000 (19:00 +0000)]
Fix Generics warnings

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611944 13f79535-47bb-0310-9956-ffa450edef68

10 years agoThe way that HSSF and XSSF stores references to external sheets are rather different...
Nick Burch [Sat, 19 Jul 2014 12:49:41 +0000 (12:49 +0000)]
The way that HSSF and XSSF stores references to external sheets are rather different, so begin to reflect that in how we parse their formulas into Ptgs

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611906 13f79535-47bb-0310-9956-ffa450edef68

10 years agoThere can be more than one linked ExternalLinks table for a workbook #56744
Nick Burch [Sat, 19 Jul 2014 11:27:46 +0000 (11:27 +0000)]
There can be more than one linked ExternalLinks table for a workbook #56744

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611890 13f79535-47bb-0310-9956-ffa450edef68

10 years agoTurns out that .xlsx files can have multiple link tables, add a test file which shows...
Nick Burch [Sat, 19 Jul 2014 10:09:00 +0000 (10:09 +0000)]
Turns out that .xlsx files can have multiple link tables, add a test file which shows this (support to follow)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611878 13f79535-47bb-0310-9956-ffa450edef68

10 years agoConvert test to junit 4, and stub out the additional 3d ref tests we need to pass...
Nick Burch [Sat, 19 Jul 2014 10:08:20 +0000 (10:08 +0000)]
Convert test to junit 4, and stub out the additional 3d ref tests we need to pass for #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611877 13f79535-47bb-0310-9956-ffa450edef68

10 years agoStub the unit test which is the next thing to need to work for progress on #56737
Nick Burch [Fri, 18 Jul 2014 23:02:51 +0000 (23:02 +0000)]
Stub the unit test which is the next thing to need to work for progress on #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611833 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBit more towards XSSF name support for #56737, will need some deeper changes though...
Nick Burch [Fri, 18 Jul 2014 22:50:54 +0000 (22:50 +0000)]
Bit more towards XSSF name support for #56737, will need some deeper changes though to fully implement

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611830 13f79535-47bb-0310-9956-ffa450edef68

10 years agoInitial support for XSSF External Links tables, which hold references to other workbo...
Nick Burch [Fri, 18 Jul 2014 22:48:59 +0000 (22:48 +0000)]
Initial support for XSSF External Links tables, which hold references to other workbooks referenced by formulas and names. #56744

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611828 13f79535-47bb-0310-9956-ffa450edef68

10 years agoLeave part disabled for now
Nick Burch [Fri, 18 Jul 2014 18:30:54 +0000 (18:30 +0000)]
Leave part disabled for now

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611755 13f79535-47bb-0310-9956-ffa450edef68

10 years agoStart to support formula parsing of sheet-specified named ranges, required for a...
Nick Burch [Fri, 18 Jul 2014 18:30:16 +0000 (18:30 +0000)]
Start to support formula parsing of sheet-specified named ranges, required for a full fix to bug #56737

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611753 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate bug reference numbers, and bring over part of a test from unfixed that is...
Nick Burch [Fri, 18 Jul 2014 17:27:37 +0000 (17:27 +0000)]
Update bug reference numbers, and bring over part of a test from unfixed that is now working (rest remains broken)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611728 13f79535-47bb-0310-9956-ffa450edef68

10 years agoHave WorkbookEvaluator process NameXPtgs, rather than returning a NameXEval which...
Nick Burch [Fri, 18 Jul 2014 16:58:38 +0000 (16:58 +0000)]
Have WorkbookEvaluator process NameXPtgs, rather than returning a NameXEval which later places didn't handle. Largely allows us to process the .xls version of the test file for #56737 (but filenames aren't quite the same as in Excel)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611711 13f79535-47bb-0310-9956-ffa450edef68

10 years ago#56737 Sometimes Excel writes an internal reference to a local name in an odd way...
Nick Burch [Fri, 18 Jul 2014 15:59:55 +0000 (15:59 +0000)]
#56737 Sometimes Excel writes an internal reference to a local name in an odd way, without an ExternalNameRecord, try to detect and work around those

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611681 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAdd disabled unit tests for bug #56737, which currently fails (differently) for HSSF...
Nick Burch [Thu, 17 Jul 2014 16:18:39 +0000 (16:18 +0000)]
Add disabled unit tests for bug #56737, which currently fails (differently) for HSSF and XSSF

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611400 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix for #56702 - If a cell is of type numeric but has an empty <v/> tag, return as 0
Nick Burch [Mon, 14 Jul 2014 18:53:39 +0000 (18:53 +0000)]
Fix for #56702 - If a cell is of type numeric but has an empty <v/> tag, return as 0

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1610482 13f79535-47bb-0310-9956-ffa450edef68

10 years agoThis bug has been fixed, so re-enable the unit test
Nick Burch [Thu, 3 Jul 2014 14:46:32 +0000 (14:46 +0000)]
This bug has been fixed, so re-enable the unit test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607662 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAdd a disabled unit test for bug #56420
Nick Burch [Thu, 3 Jul 2014 14:30:47 +0000 (14:30 +0000)]
Add a disabled unit test for bug #56420

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607661 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate the CheckFunctionsSupported example to take advantage of the new NotImplemente...
Nick Burch [Thu, 3 Jul 2014 11:21:03 +0000 (11:21 +0000)]
Update the CheckFunctionsSupported example to take advantage of the new NotImplementedFunctionException to identify the function that is missing

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607589 13f79535-47bb-0310-9956-ffa450edef68

10 years agoWhen throwing an exception during formula evaluation, if this is due to an unimplemen...
Nick Burch [Thu, 3 Jul 2014 11:20:32 +0000 (11:20 +0000)]
When throwing an exception during formula evaluation, if this is due to an unimplemented function, have a more specific exception type

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607588 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFormula evaluation and error handling example - reports what cells can't be evaluated...
Nick Burch [Thu, 3 Jul 2014 10:56:25 +0000 (10:56 +0000)]
Formula evaluation and error handling example - reports what cells can't be evaluated, and (TODO) what functions are used but not implemented

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607583 13f79535-47bb-0310-9956-ffa450edef68

10 years agoNow that XSSFWorkbook can be closed, the older path based constructor no longer needs...
Nick Burch [Thu, 3 Jul 2014 05:45:21 +0000 (05:45 +0000)]
Now that XSSFWorkbook can be closed, the older path based constructor no longer needs to be deprecated #56537

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607536 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBug 56537: Update javadoc to reflect the addition of Closeable to Workbook
Dominik Stadler [Wed, 2 Jul 2014 15:05:05 +0000 (15:05 +0000)]
Bug 56537: Update javadoc to reflect the addition of Closeable to Workbook

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607390 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpgrade to latest JaCoCo 0.7.1
Dominik Stadler [Wed, 2 Jul 2014 14:48:59 +0000 (14:48 +0000)]
Upgrade to latest JaCoCo 0.7.1

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1607384 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBUG 54771: add class to svn
Tim Allison [Mon, 16 Jun 2014 18:53:28 +0000 (18:53 +0000)]
BUG 54771: add class to svn

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1602960 13f79535-47bb-0310-9956-ffa450edef68

10 years agoBUG 54771 extract text from SDTs at the cell level within a table row
Tim Allison [Mon, 16 Jun 2014 18:46:00 +0000 (18:46 +0000)]
BUG 54771 extract text from SDTs at the cell level within a table row

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1602955 13f79535-47bb-0310-9956-ffa450edef68

10 years agoMake a start on an Ant task to generate an OSGi jar, for #53866
Nick Burch [Mon, 16 Jun 2014 11:15:31 +0000 (11:15 +0000)]
Make a start on an Ant task to generate an OSGi jar, for #53866

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1602846 13f79535-47bb-0310-9956-ffa450edef68

10 years agoRevert upgrade to XMLBeans 2.6.0 to properly discuss on the mailinglist first
Dominik Stadler [Thu, 12 Jun 2014 07:08:21 +0000 (07:08 +0000)]
Revert upgrade to XMLBeans 2.6.0 to properly discuss on the mailinglist first

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1602075 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAdd missing @Overrides, reformat some files, increase coverage slightly,
Dominik Stadler [Wed, 11 Jun 2014 20:36:30 +0000 (20:36 +0000)]
Add missing @Overrides, reformat some files, increase coverage slightly,
comments, fix Eclipse warnings and add close() calls in some tests and
in HMEFMessage() to close files during tests correctly.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1602008 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate XMLBeans to version 2.6.0
Dominik Stadler [Wed, 11 Jun 2014 20:32:52 +0000 (20:32 +0000)]
Update XMLBeans to version 2.6.0

Conflicts:

.classpath

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1602006 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix inconsistent indent
Nick Burch [Wed, 11 Jun 2014 15:38:26 +0000 (15:38 +0000)]
Fix inconsistent indent

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1601930 13f79535-47bb-0310-9956-ffa450edef68

10 years ago#56537 close method for SXSSF too
Nick Burch [Wed, 11 Jun 2014 14:38:32 +0000 (14:38 +0000)]
#56537 close method for SXSSF too

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1601917 13f79535-47bb-0310-9956-ffa450edef68

10 years agoPartial fix for #56537 - Have Workbook offer a close() method, which in turn closes...
Nick Burch [Wed, 11 Jun 2014 13:48:54 +0000 (13:48 +0000)]
Partial fix for #56537 - Have Workbook offer a close() method, which in turn closes the NPOIFS or OPC resource from which it was loaded

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1601901 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAdd a note about file resources, see bug #56537
Nick Burch [Wed, 4 Jun 2014 16:34:16 +0000 (16:34 +0000)]
Add a note about file resources, see bug #56537

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1600326 13f79535-47bb-0310-9956-ffa450edef68

10 years agoWhen finding the CTCol object for a XSSF Sheet column, as we often have to traverse...
Nick Burch [Wed, 4 Jun 2014 15:58:14 +0000 (15:58 +0000)]
When finding the CTCol object for a XSSF Sheet column, as we often have to traverse most of the list, and we are mostly reading not changing, switch to fetching all the objects as an array in one go, rather than fetching one at a time, which is hopefully faster. Aims to help bug #56556

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1600319 13f79535-47bb-0310-9956-ffa450edef68

10 years agoAdd workaround for IBM JDK where Ant populates classname instead of className for...
Dominik Stadler [Thu, 29 May 2014 12:04:51 +0000 (12:04 +0000)]
Add workaround for IBM JDK where Ant populates classname instead of className for some reason

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1598264 13f79535-47bb-0310-9956-ffa450edef68

10 years agoHSSFCell should follow XSSF, and allow setting a null-style to return to the default...
Nick Burch [Thu, 29 May 2014 11:39:50 +0000 (11:39 +0000)]
HSSFCell should follow XSSF, and allow setting a null-style to return to the default style, fixes bug #56572

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1598258 13f79535-47bb-0310-9956-ffa450edef68

10 years agoUpdate to latest Ant 1.9.4 and add ant-launcher which is used in
Dominik Stadler [Thu, 29 May 2014 09:16:29 +0000 (09:16 +0000)]
Update to latest Ant 1.9.4 and add ant-launcher which is used in
ExcelAnt tests to make it easier to run these tests in Eclipse

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1598226 13f79535-47bb-0310-9956-ffa450edef68

10 years agoRemove null-checks that can never be reached
Dominik Stadler [Thu, 29 May 2014 09:15:33 +0000 (09:15 +0000)]
Remove null-checks that can never be reached
add test for ExcelAnt setString

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1598225 13f79535-47bb-0310-9956-ffa450edef68

10 years agoIncrease the font-inaccuracy for one unit test as some machines have fonts that lead...
Dominik Stadler [Tue, 27 May 2014 20:45:25 +0000 (20:45 +0000)]
Increase the font-inaccuracy for one unit test as some machines have fonts that lead to lower values, e.g. we get only 770 instead of 980 for Jenkins build on IBM JDK and on some local Windows machines

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1597873 13f79535-47bb-0310-9956-ffa450edef68

10 years agoFix for 56563 - Multithreading bug when reading 2 similar files
Dominik Stadler [Mon, 26 May 2014 20:03:08 +0000 (20:03 +0000)]
Fix for 56563 - Multithreading bug when reading 2 similar files

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1597637 13f79535-47bb-0310-9956-ffa450edef68

10 years agoIf a NoteRecord has no author tag, it seems it can sometimes be double padded. Fixes...
Nick Burch [Fri, 23 May 2014 14:07:20 +0000 (14:07 +0000)]
If a NoteRecord has no author tag, it seems it can sometimes be double padded. Fixes #47251

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1597098 13f79535-47bb-0310-9956-ffa450edef68

10 years agoHandle date format strings in an iso8601 style format, with a T in them. Fixes bug...
Nick Burch [Fri, 23 May 2014 09:18:16 +0000 (09:18 +0000)]
Handle date format strings in an iso8601 style format, with a T in them. Fixes bug #54034

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1597038 13f79535-47bb-0310-9956-ffa450edef68

10 years agoPatch from Yaniv Kunda from bug #56274 - Fix SXSSF writing of tables when creating...
Nick Burch [Wed, 21 May 2014 17:08:25 +0000 (17:08 +0000)]
Patch from Yaniv Kunda from bug #56274 - Fix SXSSF writing of tables when creating from a template

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1596624 13f79535-47bb-0310-9956-ffa450edef68