source.dussan.org Git

Josh Micich [Mon, 7 Apr 2008 03:23:04 +0000 (03:23 +0000)]

30311 - More work on Conditional Formatting - patch from Dmitriy

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

commit | commitdiff | tree

Josh Micich [Mon, 7 Apr 2008 03:02:03 +0000 (03:02 +0000)]

refactored all hssf junits to get test sample data in the in one place

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

commit | commitdiff | tree

Josh Micich [Thu, 3 Apr 2008 21:17:26 +0000 (21:17 +0000)]

Follow up fix after r644473 (bug 44739) TestHSSFConditionalFormatting had a bug and wasn't yet included in the test suite hierarchy

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

commit | commitdiff | tree

Josh Micich [Thu, 3 Apr 2008 20:25:53 +0000 (20:25 +0000)]

Fix for bug 44739 - Conditional formatting (regions with max row/col index)

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

commit | commitdiff | tree

Nick Burch [Thu, 3 Apr 2008 15:04:52 +0000 (15:04 +0000)]

Make a bit of a start on being able to edit chart titles, based on the email to user@poi from Russ on the 2nd of April. Not quite there though

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

commit | commitdiff | tree

Yegor Kozlov [Wed, 2 Apr 2008 10:25:18 +0000 (10:25 +0000)]

Fixed inconsistency between HSSFSHeet.getColumnWidth and HSSFSheet.getDefaultColumnWidth: getColumnWidth should always return width measured in 1/256th units.

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

commit | commitdiff | tree

Yegor Kozlov [Wed, 2 Apr 2008 10:20:31 +0000 (10:20 +0000)]

added set accessor to indentation level

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

commit | commitdiff | tree

Rainer Klute [Wed, 2 Apr 2008 00:55:52 +0000 (00:55 +0000)]

Restored an entry that had been deleted by chance.

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

commit | commitdiff | tree

Rainer Klute [Wed, 2 Apr 2008 00:50:45 +0000 (00:50 +0000)]

44694 - HPSF: Support for property sets without sections

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

commit | commitdiff | tree

Josh Micich [Tue, 1 Apr 2008 23:53:51 +0000 (23:53 +0000)]

fix for bug 44710 - Incorrect skip() of second formula in DATAVALIDATION record

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

commit | commitdiff | tree

Josh Micich [Tue, 1 Apr 2008 22:18:25 +0000 (22:18 +0000)]

Bug #44733 - DPRODUCT function should be index 189, not 191

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

commit | commitdiff | tree

Yegor Kozlov [Mon, 31 Mar 2008 09:58:27 +0000 (09:58 +0000)]

Implement Sheet.removeShape(Shape shape) in HSLF

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

commit | commitdiff | tree

Josh Micich [Mon, 31 Mar 2008 06:55:04 +0000 (06:55 +0000)]

changes/status for #44675, #44695, #44691

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

commit | commitdiff | tree

Josh Micich [Mon, 31 Mar 2008 05:56:11 +0000 (05:56 +0000)]

silenced noisy tests

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

commit | commitdiff | tree

Josh Micich [Mon, 31 Mar 2008 05:19:00 +0000 (05:19 +0000)]

removed incorrect test case methods

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

commit | commitdiff | tree

Josh Micich [Mon, 31 Mar 2008 05:10:35 +0000 (05:10 +0000)]

More work on Conditional Formatting (bug 30311) junit and fixes from Dmitriy. Some other clean-up.

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

commit | commitdiff | tree

Nick Burch [Sun, 30 Mar 2008 13:40:34 +0000 (13:40 +0000)]

Update Formula test spreadsheet for count, and also do a copy as an ooxml .xlsx file

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

commit | commitdiff | tree

Nick Burch [Sun, 30 Mar 2008 13:39:51 +0000 (13:39 +0000)]

Count implementation from ooxml branch

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

commit | commitdiff | tree

Nick Burch [Sat, 29 Mar 2008 18:27:08 +0000 (18:27 +0000)]

Documentation update

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

commit | commitdiff | tree

Nick Burch [Sat, 29 Mar 2008 18:23:33 +0000 (18:23 +0000)]

Move the FormulaEvaluator code out of scratchpad

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

commit | commitdiff | tree

Nick Burch [Sat, 29 Mar 2008 18:11:48 +0000 (18:11 +0000)]

Merge several bug tests into one file

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

commit | commitdiff | tree

Nick Burch [Sat, 29 Mar 2008 18:00:16 +0000 (18:00 +0000)]

Update docs now that missing record aware eventusermodel has moved

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

commit | commitdiff | tree

Nick Burch [Sat, 29 Mar 2008 17:45:28 +0000 (17:45 +0000)]

Move the missing record aware eventusermodel code out of scratchpad

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

commit | commitdiff | tree

Nick Burch [Sat, 29 Mar 2008 17:35:53 +0000 (17:35 +0000)]

Looks like trunk will now produce 3.0.3, and ooxml branch will be 3.1, so update build.xml in trunk accordingly

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

commit | commitdiff | tree

Nick Burch [Fri, 28 Mar 2008 13:35:37 +0000 (13:35 +0000)]

Add test to show that bug #44693 is incorrect

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

commit | commitdiff | tree

Josh Micich [Thu, 27 Mar 2008 21:54:21 +0000 (21:54 +0000)]

(real) fix for bug #44691. Modified Pmt.java to allow for 3 arguments. Added TestPmt junit.

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

commit | commitdiff | tree

Josh Micich [Thu, 27 Mar 2008 20:15:13 +0000 (20:15 +0000)]

annotated previous changelist(641964) with wrong buzilla number. Previous changes were for bug #44695.

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

commit | commitdiff | tree

Josh Micich [Thu, 27 Mar 2008 20:03:29 +0000 (20:03 +0000)]

fixes for ExternalNameRecord serialisation bug #44691

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

commit | commitdiff | tree

Nick Burch [Thu, 27 Mar 2008 18:24:39 +0000 (18:24 +0000)]

Add failing (but disabled) test from bug #44691

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

commit | commitdiff | tree

Nick Burch [Thu, 27 Mar 2008 12:54:32 +0000 (12:54 +0000)]

Fix typo, and point hwpf people at the new microsoft docs

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

commit | commitdiff | tree

Nick Burch [Thu, 27 Mar 2008 12:48:55 +0000 (12:48 +0000)]

Patch from Raghu from bug #44652 - Improved handling of Pictures in Word Documents

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

commit | commitdiff | tree

Josh Micich [Wed, 26 Mar 2008 07:32:28 +0000 (07:32 +0000)]

patch 44675 - made POI capable of recognising var-args functions. Some related fixes.

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

commit | commitdiff | tree

Josh Micich [Wed, 26 Mar 2008 05:29:08 +0000 (05:29 +0000)]

more javadoc + clean-up from Dmitriy (bug 30311 att 21711)

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

commit | commitdiff | tree

Josh Micich [Tue, 25 Mar 2008 06:18:33 +0000 (06:18 +0000)]

Added class javadoc. Patch 30311 from Dmtriy.

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

commit | commitdiff | tree

Nick Burch [Sat, 22 Mar 2008 18:55:22 +0000 (18:55 +0000)]

Add note about needing to give ant more memory to run all the tests

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

commit | commitdiff | tree

Josh Micich [Fri, 21 Mar 2008 23:47:51 +0000 (23:47 +0000)]

sort to int conversion sign extension fix

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

commit | commitdiff | tree

Nick Burch [Fri, 21 Mar 2008 21:04:47 +0000 (21:04 +0000)]

Tweak how you get dataformat strings out of cell styles, to be more logical, and in keeping with how we'll want to do things for xssf too

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

commit | commitdiff | tree

Nick Burch [Fri, 21 Mar 2008 12:10:52 +0000 (12:10 +0000)]

FAQ page doesn't like the new doc dtd, so go back to the old one for it

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

commit | commitdiff | tree

Nick Burch [Thu, 20 Mar 2008 22:31:15 +0000 (22:31 +0000)]

Update a lot of the site to apache documentation format 1.3, from 1.1. Also, put note about apachecon on the homepage

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

commit | commitdiff | tree

Nick Burch [Thu, 20 Mar 2008 11:43:14 +0000 (11:43 +0000)]

Make junit happy

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

commit | commitdiff | tree

Nick Burch [Thu, 20 Mar 2008 11:02:39 +0000 (11:02 +0000)]

Fix for readCompressedUnicode not moaning about length=0, from bug #44643

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

commit | commitdiff | tree

Nick Burch [Thu, 20 Mar 2008 10:16:15 +0000 (10:16 +0000)]

Simple patch from Josh from bug #44636 - fix for RefVPtg and edit-in-excel oddness

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

commit | commitdiff | tree

Nick Burch [Thu, 20 Mar 2008 10:06:59 +0000 (10:06 +0000)]

Test relating to bug #44636

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

commit | commitdiff | tree

Nick Burch [Wed, 19 Mar 2008 12:49:35 +0000 (12:49 +0000)]

Fix bug #44627 - improve the thread safety of POILogFactory

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

commit | commitdiff | tree

Nick Burch [Wed, 19 Mar 2008 12:28:56 +0000 (12:28 +0000)]

Patch from Dmitriy from bug #30311 - Support for conditional formatting records

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

commit | commitdiff | tree

Nick Burch [Wed, 19 Mar 2008 12:01:32 +0000 (12:01 +0000)]

Add test to show that bug #43251 is already fixed

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

commit | commitdiff | tree

Nick Burch [Wed, 19 Mar 2008 11:57:38 +0000 (11:57 +0000)]

Added test to show that bug #41546 is already fixed. Also rename a test file to be more consistent

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

commit | commitdiff | tree

Nick Burch [Wed, 19 Mar 2008 11:03:42 +0000 (11:03 +0000)]

Reformat index page slightly, and add some info on ooxml support being in progress, but not yet ready

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

commit | commitdiff | tree

Yegor Kozlov [Mon, 17 Mar 2008 13:02:46 +0000 (13:02 +0000)]

support align=distributed in HSSFTextbox

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

commit | commitdiff | tree

Nick Burch [Sun, 16 Mar 2008 15:48:02 +0000 (15:48 +0000)]

Patch from Josh from bug #44609 - Handle leading spaces in formulas, such as '= 4'

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

commit | commitdiff | tree

Nick Burch [Sun, 16 Mar 2008 15:40:17 +0000 (15:40 +0000)]

Patch from Josh from bug #44608 - Support for PercentPtg in the formula evaluator

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

commit | commitdiff | tree

Nick Burch [Sun, 16 Mar 2008 15:38:09 +0000 (15:38 +0000)]

Patch from Josh from bug #44608 - Support for PercentPtg in the formula evaluator

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

commit | commitdiff | tree

Nick Burch [Sun, 16 Mar 2008 15:29:34 +0000 (15:29 +0000)]

Patch from Josh from bug #44606 - Support calculated string values for evaluated formulas

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

commit | commitdiff | tree

Nick Burch [Sun, 16 Mar 2008 15:20:47 +0000 (15:20 +0000)]

Patch from Josh, which shows that various bugs are now fixed

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

commit | commitdiff | tree

Yegor Kozlov [Fri, 14 Mar 2008 18:05:55 +0000 (18:05 +0000)]

Add accessors to horizontal and vertical alignment in HSSFTextbox

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

commit | commitdiff | tree

Nick Burch [Thu, 13 Mar 2008 15:58:34 +0000 (15:58 +0000)]

Add test to show that bug #28031 is really closed

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

commit | commitdiff | tree

Nick Burch [Thu, 13 Mar 2008 15:38:28 +0000 (15:38 +0000)]

Make a start on handling different big block sizes in POIFS, but work isn't complete. See bug #35928 for part of what we're after

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

commit | commitdiff | tree

Nick Burch [Thu, 13 Mar 2008 13:20:09 +0000 (13:20 +0000)]

Fix bug #44593 - improved handling of short DVRecords

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

commit | commitdiff | tree

Nick Burch [Thu, 13 Mar 2008 13:03:25 +0000 (13:03 +0000)]

Patch from Raghu from bug #44580 - Fix bug #28627, where hwpf Range.delete() didn't work properly

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

commit | commitdiff | tree

Nick Burch [Fri, 7 Mar 2008 12:06:18 +0000 (12:06 +0000)]

Patch largely from Josh from bug #44539 - Support for area references in formulas of rows >= 32768

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

commit | commitdiff | tree

Nick Burch [Fri, 7 Mar 2008 11:36:14 +0000 (11:36 +0000)]

Improved support for read-only recommended workbooks, fixing bug #44536

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

commit | commitdiff | tree

Nick Burch [Fri, 7 Mar 2008 11:18:02 +0000 (11:18 +0000)]

Patch from Josh from bug #43901 - Correctly update the internal last cell number when adding and removing cells (previously sometimes off-by-one)

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

commit | commitdiff | tree

Nick Burch [Thu, 6 Mar 2008 18:13:47 +0000 (18:13 +0000)]

Add broken test for bug #43901

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

commit | commitdiff | tree

Nick Burch [Thu, 6 Mar 2008 18:06:48 +0000 (18:06 +0000)]

Embeded files from bug #44524

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

commit | commitdiff | tree

Nick Burch [Thu, 6 Mar 2008 15:54:06 +0000 (15:54 +0000)]

Change the behaviour on short last blocks to be a warning not an exception, as some people seem to have "real" valid files that trigger this. Fixed bug #28231

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

commit | commitdiff | tree

Nick Burch [Tue, 4 Mar 2008 16:59:02 +0000 (16:59 +0000)]

Changelog update for last patch

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

commit | commitdiff | tree

Nick Burch [Tue, 4 Mar 2008 16:53:32 +0000 (16:53 +0000)]

Big patch from Josh from bug #44504 - lots of formula parser improvements

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

commit | commitdiff | tree

Nick Burch [Tue, 4 Mar 2008 15:06:29 +0000 (15:06 +0000)]

Problem files from bug #44501

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

commit | commitdiff | tree

Nick Burch [Mon, 3 Mar 2008 17:47:36 +0000 (17:47 +0000)]

Fix indent, add more documentation, and make the error message more helpful

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

commit | commitdiff | tree

Nick Burch [Mon, 3 Mar 2008 16:55:00 +0000 (16:55 +0000)]

Patch from Josh from bug #44508 - Fix formula evaluation with evaluateInCell on boolean formulas

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

commit | commitdiff | tree

Nick Burch [Mon, 3 Mar 2008 16:09:02 +0000 (16:09 +0000)]

Patch from Josh from bug #44510 - Fix how DVALRecord works with dropdowns

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

commit | commitdiff | tree

Nick Burch [Mon, 3 Mar 2008 15:26:38 +0000 (15:26 +0000)]

Patch from Josh from bug #44495 - Handle named cell ranges in formulas that have lower case parts

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

commit | commitdiff | tree

Nick Burch [Mon, 3 Mar 2008 15:10:46 +0000 (15:10 +0000)]

Fix from Yegor from bug #44491 - don't have the new style handy POIDocument property stuff break old style hpsf+hssf use

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

commit | commitdiff | tree

Nick Burch [Mon, 3 Mar 2008 15:01:18 +0000 (15:01 +0000)]

Patch from Paolo from bug #44481 - getVerticallyCenter shouldn't take a parameter, but leave the old version in as deprecated for now

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

commit | commitdiff | tree

Nick Burch [Fri, 22 Feb 2008 11:40:00 +0000 (11:40 +0000)]

Bug #44471 - Crystal Reports generates files with short StyleRecords, which isn't allowed in the spec. Work around this

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

commit | commitdiff | tree

Nick Burch [Fri, 22 Feb 2008 11:23:50 +0000 (11:23 +0000)]

Patch from Josh from bug #44450 - VLookup and HLookup support, and improvements to Lookup and Offset

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 16:44:46 +0000 (16:44 +0000)]

At the request of legal-discuss, shuffle the ooxml xsd licence details into LICENSE from NOTICE

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 16:22:18 +0000 (16:22 +0000)]

Add a disabled test for a file with whacky StyleRecords that trigger an AIOOB

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 15:48:52 +0000 (15:48 +0000)]

Patch from Josh from bug #44449 - Handle SharedFormulas better, for where there are formulas for the same area on two sheets, and when the shared formula flag is set incorrectly

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 15:42:06 +0000 (15:42 +0000)]

Patch from Josh from bug #44437 - improved unit test for poifs

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 15:40:34 +0000 (15:40 +0000)]

Patch from Josh from bug #44437 - improved unit test for poifs

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 15:35:59 +0000 (15:35 +0000)]

Patch from Josh from bug #44366 - InputStreams passed to POIFSFileSystem are now automatically closed. A warning is generated for people who might've relied on them not being closed before, and a wrapper to restore the old behaviour is supplied

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 15:08:44 +0000 (15:08 +0000)]

Patch from Josh from bug #44371 - support for OFFSET function, and various tweaks to the formula evaluator to support this

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 11:34:25 +0000 (11:34 +0000)]

Fix bug 38921, where HSSFPalette.findSimilar() wasn't working properly, and add tests for it

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 10:49:25 +0000 (10:49 +0000)]

Use the right way to figure out how many rows on a sheet, so we display the row number for all of them on the left hand side. Also, tidy up some imports

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

commit | commitdiff | tree

Nick Burch [Thu, 21 Feb 2008 10:36:08 +0000 (10:36 +0000)]

Fix from Josh from bug #44456 - Update contrib SViewer to not fail if a HSSFRow is null

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

commit | commitdiff | tree

Nick Burch [Wed, 20 Feb 2008 18:14:30 +0000 (18:14 +0000)]

Patch from Josh from bug #44403 - Further support for unusual, but valid, arguments to the Mid function

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

commit | commitdiff | tree

Nick Burch [Mon, 18 Feb 2008 13:08:16 +0000 (13:08 +0000)]

Update notice for latest guidance on ooxml xsd licence, and update getting involved to link to the newly released binary file format docs

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 13:50:38 +0000 (13:50 +0000)]

Further support for whole-column references, including formula strings and the evaluator. Also has some new tests for it

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 12:59:40 +0000 (12:59 +0000)]

Partial fix for bug #44410 - support whole column ranges such as C:C in the formula evaluator (so SUM(D:D) will now work). However, the formula string will still be displayed wrong

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 12:13:25 +0000 (12:13 +0000)]

Fix from Josh from bug #44421 - Update Match function to properly support Area references

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 12:04:42 +0000 (12:04 +0000)]

Fix from Josh from bug #44417 - Improved handling of references for the need to quote the sheet name for some formulas, but not when fetching a sheet by name

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 11:53:25 +0000 (11:53 +0000)]

Fix for bug #44413 from Josh - Fix for circular references in INDEX, OFFSET, VLOOKUP formulas, where a cell is actually allowed to reference itself

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 11:45:13 +0000 (11:45 +0000)]

Fix for bug #44403 - Have mid use the third argument properly, and test

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

commit | commitdiff | tree

Nick Burch [Fri, 15 Feb 2008 10:30:10 +0000 (10:30 +0000)]

To avoid confusion and repeated changes in svn, update the TestDataValidation test to output its file (that needs opening in excel to check to output) into the system tmp directory

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

commit | commitdiff | tree

Nick Burch [Thu, 14 Feb 2008 16:01:10 +0000 (16:01 +0000)]

Big formula update from Josh from bug #44364 - support for Match, NA and SumProduct functions, and initial error support in functions

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

commit | commitdiff | tree

Nick Burch [Thu, 14 Feb 2008 15:32:49 +0000 (15:32 +0000)]

In the interests of sanity, stop having hssf test data files in scratchpad and main, go to just having them in main

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

commit | commitdiff | tree

Nick Burch [Mon, 11 Feb 2008 19:14:04 +0000 (19:14 +0000)]

If we have a document with a hpsf stream that exists, but is of the wrong type, then log a warning but continue

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

commit | commitdiff | tree

Nick Burch [Mon, 11 Feb 2008 17:55:09 +0000 (17:55 +0000)]

Another test relating to bug #42564 - this one is still failing

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

commit | commitdiff | tree

Nick Burch [Sun, 10 Feb 2008 21:54:13 +0000 (21:54 +0000)]

Test for bug #42564 - appears to already be fixed

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