source.dussan.org Git

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

commit | commitdiff | tree

Nick Burch [Fri, 8 Feb 2008 18:17:29 +0000 (18:17 +0000)]

Tweak layout

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

commit | commitdiff | tree

Nick Burch [Fri, 8 Feb 2008 12:02:10 +0000 (12:02 +0000)]

Copy Rainer's change note from changes.xml to status.xml, as it's needed in both

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

commit | commitdiff | tree

Rainer Klute [Fri, 8 Feb 2008 11:56:11 +0000 (11:56 +0000)]

- Fixed bug 44375 - HPSF now copes with a broken dictionary in Document Summary Information stream. RuntimeExceptions that occured when trying to read bogus data are now caught. Dictionary entries up to but not including the bogus one are preserved, the rest is ignored.

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

commit | commitdiff | tree

Rainer Klute [Fri, 8 Feb 2008 11:55:43 +0000 (11:55 +0000)]

commit | commitdiff | tree

Nick Burch [Thu, 7 Feb 2008 17:12:09 +0000 (17:12 +0000)]

Add (disabled) failing testcase for bug #44375

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

commit | commitdiff | tree

Nick Burch [Thu, 7 Feb 2008 16:53:23 +0000 (16:53 +0000)]

Handle timezones better with cell.setCellValue(Calendar), so now 20:00-03:00, 20:00+00:00 and 20:00+03:00 will all be recorded as 20:00, and not 17:00 / 20:00 / 23:00 (pass a Date not a Calendar for old behaviour) - patch from bug #38641

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

commit | commitdiff | tree

Nick Burch [Thu, 7 Feb 2008 12:39:12 +0000 (12:39 +0000)]

Patch from bug #44373 - Have HSSFDateUtil.isADateFormat support more date formats

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

commit | commitdiff | tree

Yegor Kozlov [Thu, 7 Feb 2008 08:56:59 +0000 (08:56 +0000)]

support for excel hypelrinks

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