]> source.dussan.org Git - poi.git/log
poi.git
16 years agoChange the behaviour on short last blocks to be a warning not an exception, as some...
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

16 years agoChangelog update for last patch
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

16 years agoBig patch from Josh from bug #44504 - lots of formula parser improvements
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

16 years agoProblem files from bug #44501
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

16 years agoFix indent, add more documentation, and make the error message more helpful
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

16 years agoPatch from Josh from bug #44508 - Fix formula evaluation with evaluateInCell on boole...
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

16 years agoPatch from Josh from bug #44510 - Fix how DVALRecord works with dropdowns
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

16 years agoPatch from Josh from bug #44495 - Handle named cell ranges in formulas that have...
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

16 years agoFix from Yegor from bug #44491 - don't have the new style handy POIDocument property...
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

16 years agoPatch from Paolo from bug #44481 - getVerticallyCenter shouldn't take a parameter...
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

16 years agoBug #44471 - Crystal Reports generates files with short StyleRecords, which isn't...
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

16 years agoPatch from Josh from bug #44450 - VLookup and HLookup support, and improvements to...
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

16 years agoAt the request of legal-discuss, shuffle the ooxml xsd licence details into LICENSE...
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

16 years agoAdd a disabled test for a file with whacky StyleRecords that trigger an AIOOB
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

16 years agoPatch from Josh from bug #44449 - Handle SharedFormulas better, for where there are...
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

16 years agoPatch from Josh from bug #44437 - improved unit test for poifs
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

16 years agoPatch from Josh from bug #44437 - improved unit test for poifs
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

16 years agoPatch from Josh from bug #44366 - InputStreams passed to POIFSFileSystem are now...
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

16 years agoPatch from Josh from bug #44371 - support for OFFSET function, and various tweaks...
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

16 years agoFix bug 38921, where HSSFPalette.findSimilar() wasn't working properly, and add tests...
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

16 years agoUse the right way to figure out how many rows on a sheet, so we display the row numbe...
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

16 years agoFix from Josh from bug #44456 - Update contrib SViewer to not fail if a HSSFRow is...
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

16 years agoPatch from Josh from bug #44403 - Further support for unusual, but valid, arguments...
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

16 years agoUpdate notice for latest guidance on ooxml xsd licence, and update getting involved...
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

16 years agoFurther support for whole-column references, including formula strings and the evalua...
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

16 years agoPartial fix for bug #44410 - support whole column ranges such as C:C in the formula...
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

16 years agoFix from Josh from bug #44421 - Update Match function to properly support Area references
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

16 years agoFix from Josh from bug #44417 - Improved handling of references for the need to quote...
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

16 years agoFix for bug #44413 from Josh - Fix for circular references in INDEX, OFFSET, VLOOKUP...
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

16 years agoFix for bug #44403 - Have mid use the third argument properly, and test
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

16 years agoTo avoid confusion and repeated changes in svn, update the TestDataValidation test...
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

16 years agoBig formula update from Josh from bug #44364 - support for Match, NA and SumProduct...
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

16 years agoIn the interests of sanity, stop having hssf test data files in scratchpad and main...
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

16 years agoIf we have a document with a hpsf stream that exists, but is of the wrong type, then...
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

16 years agoAnother test relating to bug #42564 - this one is still failing
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

16 years agoTest for bug #42564 - appears to already be fixed
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

16 years agoTweak layout
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

16 years agoCopy Rainer's change note from changes.xml to status.xml, as it's needed in both
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

16 years ago- Fixed bug 44375 - HPSF now copes with a broken dictionary in Document Summary Infor...
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

16 years ago- Fixed bug 44375 - HPSF now copes with a broken dictionary in Document Summary Infor...
Rainer Klute [Fri, 8 Feb 2008 11:55:43 +0000 (11:55 +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@619848 13f79535-47bb-0310-9956-ffa450edef68

16 years agoAdd (disabled) failing testcase for bug #44375
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

16 years agoHandle timezones better with cell.setCellValue(Calendar), so now 20:00-03:00, 20...
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

16 years agoPatch from bug #44373 - Have HSSFDateUtil.isADateFormat support more date formats
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

16 years agosupport for excel hypelrinks
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

16 years agoImplement hashCode and equals for HSSFFont and HSSFCellStyle
Nick Burch [Wed, 6 Feb 2008 14:35:05 +0000 (14:35 +0000)]
Implement hashCode and equals for HSSFFont and HSSFCellStyle

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

16 years ago3.0.2-FINAL released
Yegor Kozlov [Wed, 6 Feb 2008 09:47:13 +0000 (09:47 +0000)]
3.0.2-FINAL released

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

16 years agoFew tweaks to the patching guide
Nick Burch [Tue, 5 Feb 2008 16:32:45 +0000 (16:32 +0000)]
Few tweaks to the patching guide

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

16 years agoTweaks to the iterator use guides for hssf
Nick Burch [Tue, 5 Feb 2008 16:21:21 +0000 (16:21 +0000)]
Tweaks to the iterator use guides for hssf

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

16 years agoAdd java.lang.Iterable style methods for iterating over rows and cells, but don't...
Nick Burch [Tue, 5 Feb 2008 15:51:29 +0000 (15:51 +0000)]
Add java.lang.Iterable style methods for iterating over rows and cells, but don't actually implement that, as it wasn't in jdk 1.3 or jdk 1.4, with is rather tedious

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

16 years agoMake TestHSSFSheet#testAutoSizeColumn not fail on a Mac just because of font size...
Ugo Cei [Mon, 4 Feb 2008 17:05:13 +0000 (17:05 +0000)]
Make TestHSSFSheet#testAutoSizeColumn not fail on a Mac just because of font size differences.

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

16 years agoTest file with hyperlinks on many sheets, of different types
Nick Burch [Mon, 4 Feb 2008 11:14:49 +0000 (11:14 +0000)]
Test file with hyperlinks on many sheets, of different types

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

16 years agoImplement CountA, CountIf, Index, Rows and Columns functions. Patch from Josh Micich...
Nick Burch [Mon, 4 Feb 2008 10:48:29 +0000 (10:48 +0000)]
Implement CountA, CountIf, Index, Rows and Columns functions. Patch from Josh Micich in bug #44345

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

16 years agousermodel support for excel hyperlinks
Yegor Kozlov [Sat, 2 Feb 2008 17:06:14 +0000 (17:06 +0000)]
usermodel support for excel hyperlinks

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

16 years agoMore Hyperlink support. Doesn't end up in HSSFCell just yet, as the records are in...
Nick Burch [Fri, 1 Feb 2008 16:52:58 +0000 (16:52 +0000)]
More Hyperlink support. Doesn't end up in HSSFCell just yet, as the records are in the wrong bit of the file, so don't get associated with the sheet. All tests still passing though

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

16 years agoGet the Hyperlink record code so that it doesn't break any existing tests, and add...
Nick Burch [Fri, 1 Feb 2008 15:41:32 +0000 (15:41 +0000)]
Get the Hyperlink record code so that it doesn't break any existing tests, and add in (no usermodel support yet though)

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

16 years agoMake a start on the hyperlink record support - not finished yet though, so not enabled
Nick Burch [Fri, 1 Feb 2008 15:20:55 +0000 (15:20 +0000)]
Make a start on the hyperlink record support - not finished yet though, so not enabled

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

16 years agoPatch from bug #44336 - correctly escape sheet names in formula references, including...
Nick Burch [Fri, 1 Feb 2008 13:02:06 +0000 (13:02 +0000)]
Patch from bug #44336 - correctly escape sheet names in formula references, including tests for this, and fixes to old tests that were expecting the un-escaped sheet names

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

16 years agoImprovements to how SystemOutLogger and CommonsLogger log messages with exceptions...
Nick Burch [Fri, 1 Feb 2008 12:29:38 +0000 (12:29 +0000)]
Improvements to how SystemOutLogger and CommonsLogger log messages with exceptions, and avoid an infinite loop with certain log messages with exceptions - triggered by bug #44326

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

16 years agoTweak the javadoc so it's clearer on the overview what the getFormat method does
Nick Burch [Fri, 1 Feb 2008 12:13:08 +0000 (12:13 +0000)]
Tweak the javadoc so it's clearer on the overview what the getFormat method does

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

16 years agoConvert HSSFEventFactory to using the new HSSFRecordStream, which returns fully-forme...
Nick Burch [Thu, 31 Jan 2008 17:30:16 +0000 (17:30 +0000)]
Convert HSSFEventFactory to using the new HSSFRecordStream, which returns fully-formed HSSFRecords. HSSFRecordStream allows for pull-style eventusermodel processing

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

16 years agoLots of documentation updates, to make it clearer how the code actually works
Nick Burch [Thu, 31 Jan 2008 16:41:53 +0000 (16:41 +0000)]
Lots of documentation updates, to make it clearer how the code actually works

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

16 years agoMostly fix bug 42618 (really this time...) - can now open the file properly, but...
Nick Burch [Mon, 28 Jan 2008 12:18:12 +0000 (12:18 +0000)]
Mostly fix bug 42618 (really this time...) - can now open the file properly, but getCellFormula() is still playing up (bug #44306 opened for this)

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

16 years agostart a new POI 3.1 section in the change log
Yegor Kozlov [Mon, 28 Jan 2008 08:53:19 +0000 (08:53 +0000)]
start a new POI 3.1 section in the change log

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

16 years agofix bug #44297: IntPtg must operate with unsigned short. Reading signed short results...
Yegor Kozlov [Sun, 27 Jan 2008 14:55:32 +0000 (14:55 +0000)]
fix bug #44297: IntPtg must operate with unsigned short. Reading signed short results in incorrect formula calculation.

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

16 years agofix bug #44296: HSLF Not Extracting Slide Background Image
Yegor Kozlov [Fri, 25 Jan 2008 19:37:22 +0000 (19:37 +0000)]
fix bug #44296: HSLF Not Extracting Slide Background Image

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

16 years agocommented failing test42618()
Yegor Kozlov [Fri, 25 Jan 2008 19:27:56 +0000 (19:27 +0000)]
commented failing test42618()

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

16 years agoAdd a test to show the bug #42618 appears to be incorrect
Nick Burch [Fri, 25 Jan 2008 16:33:59 +0000 (16:33 +0000)]
Add a test to show the bug #42618 appears to be incorrect

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

16 years agoDon't swap AreaPtg references from relative to absolute, by correctly processing...
Nick Burch [Fri, 25 Jan 2008 16:15:49 +0000 (16:15 +0000)]
Don't swap AreaPtg references from relative to absolute, by correctly processing the fields. Patch from bug #44293

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

16 years agoCorrectly handle the last paragraph via a fix to TableCell - patch from bug #44292
Nick Burch [Fri, 25 Jan 2008 11:52:39 +0000 (11:52 +0000)]
Correctly handle the last paragraph via a fix to TableCell - patch from bug #44292

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

16 years agoFrom bug #44254 - avoid some unread bytes warnings, and process the contents of DVALR...
Nick Burch [Thu, 24 Jan 2008 16:05:27 +0000 (16:05 +0000)]
From bug #44254 - avoid some unread bytes warnings, and process the contents of DVALRecord

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

16 years agoAdd another formula evaluation method, evaluateFormulaCell(cell), which will re-calcu...
Nick Burch [Thu, 24 Jan 2008 14:13:05 +0000 (14:13 +0000)]
Add another formula evaluation method, evaluateFormulaCell(cell), which will re-calculate the value for a formula, without affecting the formula itself. Add tests too, and update the documentation

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

16 years agoUpdate to use a newer openxml4j jar file, which contains patches from myself and Ugo
Nick Burch [Thu, 24 Jan 2008 13:08:57 +0000 (13:08 +0000)]
Update to use a newer openxml4j jar file, which contains patches from myself and Ugo

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

16 years agoextra whitespace caused the test fail on win xp. Strange, but it worked fine on *nix
Yegor Kozlov [Tue, 22 Jan 2008 17:59:27 +0000 (17:59 +0000)]
extra whitespace caused the test fail on win xp. Strange, but it worked fine on *nix

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

16 years agoFix from bug #41726 - support signed offsets from relative areas and references
Nick Burch [Tue, 22 Jan 2008 14:48:51 +0000 (14:48 +0000)]
Fix from bug #41726 - support signed offsets from relative areas and references

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

16 years agoadded a unit test for fixed bug 41139: Constructing HSSFWorkbook is failed,threw...
Yegor Kozlov [Sat, 19 Jan 2008 14:54:06 +0000 (14:54 +0000)]
added a unit test for fixed bug 41139: Constructing HSSFWorkbook is failed,threw threw ArrayIndexOutOfBoundsException for creating UnknownRecord

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

16 years agoadded unit tests for closed Bug 37684: Unhandled Continue Record Error
Yegor Kozlov [Sat, 19 Jan 2008 14:44:07 +0000 (14:44 +0000)]
added unit tests for closed Bug 37684: Unhandled Continue Record Error

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

16 years agoadd a check to prevent NPE in HSSFSheet.autoSizeColumn(). See Bug 44246
Yegor Kozlov [Sat, 19 Jan 2008 14:28:10 +0000 (14:28 +0000)]
add a check to prevent NPE in HSSFSheet.autoSizeColumn(). See Bug 44246

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

16 years agouse JDK 1.4 compatible constructor for IllegalStateException
Yegor Kozlov [Sat, 19 Jan 2008 14:27:02 +0000 (14:27 +0000)]
use JDK 1.4 compatible constructor for IllegalStateException

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

16 years agoAdd a missing bit to the compile-ooxml ant task
Nick Burch [Wed, 16 Jan 2008 17:12:52 +0000 (17:12 +0000)]
Add a missing bit to the compile-ooxml ant task

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

16 years agoTidy up the imports, remove accidental link to xmlbeans
Nick Burch [Wed, 16 Jan 2008 16:59:14 +0000 (16:59 +0000)]
Tidy up the imports, remove accidental link to xmlbeans

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

16 years agoPatch to support UncalcedRecord and usermodel code for it, to indicate formulas on...
Nick Burch [Wed, 16 Jan 2008 13:14:31 +0000 (13:14 +0000)]
Patch to support UncalcedRecord and usermodel code for it, to indicate formulas on a sheet need recalculating (from bug #44233)

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

16 years agoAdd methods to check to see if a given InputStream has a OOXML file header, or a...
Nick Burch [Wed, 16 Jan 2008 12:46:43 +0000 (12:46 +0000)]
Add methods to check to see if a given InputStream has a OOXML file header, or a OLE2 file header, so that a future factory method could figure out which class to instantiate for a given InputStraeam

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

16 years agoFix bug #44201 - support cloning of DVRecord, so validation enabled sheets can be...
Nick Burch [Tue, 15 Jan 2008 16:42:44 +0000 (16:42 +0000)]
Fix bug #44201 - support cloning of DVRecord, so validation enabled sheets can be cloned

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

16 years agoSome more updates to the records->usermodel support for hssf shapes. Still not enough...
Nick Burch [Tue, 15 Jan 2008 16:31:29 +0000 (16:31 +0000)]
Some more updates to the records->usermodel support for hssf shapes. Still not enough there to be useful to pretty much anyone, but at least there's now a framework in place that people can use if they want to support more, and some tests

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

16 years agoupdate status of the latest release on the index page
Yegor Kozlov [Sat, 12 Jan 2008 15:11:10 +0000 (15:11 +0000)]
update status of the latest release on the index page

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

16 years agofixed bug 44200: Sheet not cloneable when Note added to excel cell
Yegor Kozlov [Thu, 10 Jan 2008 18:04:38 +0000 (18:04 +0000)]
fixed bug 44200: Sheet not cloneable when Note added to excel cell

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

16 years agoMake a start on processing shapes on a sheet out of a record. For now, doesn't actual...
Nick Burch [Wed, 9 Jan 2008 23:21:35 +0000 (23:21 +0000)]
Make a start on processing shapes on a sheet out of a record. For now, doesn't actually manage to do this, but has much of the infrastructure that'll be needed. Includes ability to get an existing HSSFPatriarch for a sheet, if there are the required records, and for the HSSFPatriarch to be in a position to be given the shapes that make it up (but this isn't done yet)

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

16 years agoAdd several more test files, charting related
Nick Burch [Wed, 9 Jan 2008 23:14:32 +0000 (23:14 +0000)]
Add several more test files, charting related

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

16 years agoPut the anchors where forrest wants them
Nick Burch [Wed, 9 Jan 2008 20:50:00 +0000 (20:50 +0000)]
Put the anchors where forrest wants them

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

16 years agoUpdate documentation, and add section on whole-workbook recalculating
Nick Burch [Wed, 9 Jan 2008 20:37:06 +0000 (20:37 +0000)]
Update documentation, and add section on whole-workbook recalculating

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

16 years agoFix for SharedStringsTable in ooxml excel support, and related test updates now we...
Nick Burch [Wed, 9 Jan 2008 18:46:30 +0000 (18:46 +0000)]
Fix for SharedStringsTable in ooxml excel support, and related test updates now we have more to test

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

16 years agoFurther font size tweaks for autosizing test (macs are even odder...)
Nick Burch [Wed, 9 Jan 2008 18:38:44 +0000 (18:38 +0000)]
Further font size tweaks for autosizing test (macs are even odder...)

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

16 years agoFont sizes can vary slightly between machines, so use small ranges not absolute numbe...
Nick Burch [Wed, 9 Jan 2008 17:47:00 +0000 (17:47 +0000)]
Font sizes can vary slightly between machines, so use small ranges not absolute numbers when testing column autosizing

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

16 years agoTweak comments, layout and exceptions in IOUtils and RawDataBlock. It should now...
Nick Burch [Wed, 9 Jan 2008 16:31:25 +0000 (16:31 +0000)]
Tweak comments, layout and exceptions in IOUtils and RawDataBlock. It should now be clearer exactly what they do, and when they become unhappy. Also include a test that ensures that when reading from a slow inputstream (as per bug #42834), we really are ok with the data dribbling in, and do not require it to all come in in blocksize chunks at one

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

16 years agoProperly set the values when calling the boolean sets
Nick Burch [Wed, 9 Jan 2008 16:24:28 +0000 (16:24 +0000)]
Properly set the values when calling the boolean sets

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

16 years agoFix bug #43008, by deprecating setCellNum() on HSSFCell, and adding moveCell() to...
Nick Burch [Wed, 9 Jan 2008 14:27:51 +0000 (14:27 +0000)]
Fix bug #43008, by deprecating setCellNum() on HSSFCell, and adding moveCell() to HSSFRow, which correctly updates all the references

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

16 years agoFix for bug #43058 - handle setting row grouping for sheets that lacked gutsrecords...
Nick Burch [Wed, 9 Jan 2008 13:37:06 +0000 (13:37 +0000)]
Fix for bug #43058 - handle setting row grouping for sheets that lacked gutsrecords at that point

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

16 years agoAdd a xlsx sample file with boolean formulas and values in it, as none of the officia...
Nick Burch [Wed, 9 Jan 2008 13:04:18 +0000 (13:04 +0000)]
Add a xlsx sample file with boolean formulas and values in it, as none of the official samples include any booleans!

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

16 years agoAdd a further test to TestHSSFRow which verifies that bug #43901 is invalid
Nick Burch [Wed, 9 Jan 2008 11:12:16 +0000 (11:12 +0000)]
Add a further test to TestHSSFRow which verifies that bug #43901 is invalid

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

16 years agoAdd clone methods to DrawingRecord and AbstractEscherHolderRecord, which allows cloni...
Nick Burch [Wed, 9 Jan 2008 10:59:04 +0000 (10:59 +0000)]
Add clone methods to DrawingRecord and AbstractEscherHolderRecord, which allows cloning of some sheets with drawing objects on them. Fixes bug #31795

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