635c570598
Bugzilla 47363 - Fixed HSSFSheet to allow addition of data validations after sheet protection
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@784240 13f79535-47bb-0310-9956-ffa450edef68
2009-06-12 19:17:59 +00:00
ac526f039b
fixed CommonObjectDataSubRecord.field_2_objectId to be unsigned, also fixed HSSFCell.findCellComment to handle sheets with more than 65536 comments
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@782398 13f79535-47bb-0310-9956-ffa450edef68
2009-06-07 14:54:49 +00:00
190684164a
Bugzilla 46776 - Added clone() method to MulBlankRecord to fix crash in Sheet.cloneSheet()
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@782177 13f79535-47bb-0310-9956-ffa450edef68
2009-06-06 00:46:41 +00:00
3f7db41945
Removed RCS tags from src/java javadocs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@781869 13f79535-47bb-0310-9956-ffa450edef68
2009-06-04 23:07:15 +00:00
3280064978
Bugzilla 47244 - Fixed HSSFSheet to handle missing header / footer records
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@781645 13f79535-47bb-0310-9956-ffa450edef68
2009-06-04 03:38:52 +00:00
93b121eb01
Fix for javadoc error in Cell.setCellValue(Date) found by Mike Curwen
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@781624 13f79535-47bb-0310-9956-ffa450edef68
2009-06-04 00:08:33 +00:00
b7d7f53ea6
rolling back r781622
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@781623 13f79535-47bb-0310-9956-ffa450edef68
2009-06-04 00:06:31 +00:00
f7148c9431
Fix for javadoc error in Cell.setCellValue(Date) found by Mike Curwen
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@781622 13f79535-47bb-0310-9956-ffa450edef68
2009-06-03 23:57:31 +00:00
fd7ce95af9
Bugzilla 47312 - Fixed formula parser to properly reject cell references with a '0' row component
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@781616 13f79535-47bb-0310-9956-ffa450edef68
2009-06-03 23:23:13 +00:00
522d5c6892
Changed CRLF to LF in remaining trunk/src files
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780878 13f79535-47bb-0310-9956-ffa450edef68
2009-06-01 23:21:13 +00:00
dd7e611bda
Fixed non-use of 10 sample files (named 'BigSSTRecord*'). Resurrected SSTRecord test (commented out in r353769).
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780874 13f79535-47bb-0310-9956-ffa450edef68
2009-06-01 23:13:29 +00:00
e6149cca3a
removed '@version $Id:$' tags (all were in javadoc comments)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780832 13f79535-47bb-0310-9956-ffa450edef68
2009-06-01 21:07:20 +00:00
e939bb7d88
removed obsolete classes
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780822 13f79535-47bb-0310-9956-ffa450edef68
2009-06-01 20:47:11 +00:00
5fc9eb4718
Code cleanup in hssf.model.Sheet. Minor re-formatting and compiler warning fixes.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780792 13f79535-47bb-0310-9956-ffa450edef68
2009-06-01 19:18:43 +00:00
bffe0432f6
Bugzilla 47199 - Fixed PageSettingsBlock/Sheet to tolerate margin records after other non-PSB records
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780774 13f79535-47bb-0310-9956-ffa450edef68
2009-06-01 18:41:10 +00:00
e7d06ec34c
Fixed HSSFSheet#getFirstRowNum and HSSFSheet#getLastRowNum to return correct values after removal of all rows
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@780245 13f79535-47bb-0310-9956-ffa450edef68
2009-05-30 11:31:14 +00:00
5a9db459c4
Bugzilla 47250 - Fixed FontRecord to expect unicode flags even when name length is zero
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@777717 13f79535-47bb-0310-9956-ffa450edef68
2009-05-22 21:30:50 +00:00
0cc03d5e13
Made constructor parameter type less restrictive
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@777660 13f79535-47bb-0310-9956-ffa450edef68
2009-05-22 19:04:49 +00:00
bd15957a5b
Bugzilla 47198 - Fixed formula evaluator comparison of -0.0 and 0.0
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@777392 13f79535-47bb-0310-9956-ffa450edef68
2009-05-22 06:25:58 +00:00
394445888b
Bugzilla 47229 - Fixed ExternalNameRecord to handle DDE links
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@777275 13f79535-47bb-0310-9956-ffa450edef68
2009-05-21 21:41:47 +00:00
b707cd8b48
Added debug methods to decode BIFF record types from record IDs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@777270 13f79535-47bb-0310-9956-ffa450edef68
2009-05-21 21:32:54 +00:00
54a729eb7d
removed unused class
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@776513 13f79535-47bb-0310-9956-ffa450edef68
2009-05-20 01:09:21 +00:00
52d7b774bf
Changed CRLF to LF in function implementations. Removed subclasses of NotImplementedFunction. Minor fixes for compiler warnings, and formatting.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@776505 13f79535-47bb-0310-9956-ffa450edef68
2009-05-20 00:14:19 +00:00
718d1bcf43
Changed CRLF to LF in poi/ddf, Minor fixes for compiler warnings, and formatting
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@776424 13f79535-47bb-0310-9956-ffa450edef68
2009-05-19 19:21:12 +00:00
bae270a565
Changed CRLF to LF in .java base src files. Minor reformatting fixes.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@776377 13f79535-47bb-0310-9956-ffa450edef68
2009-05-19 16:29:51 +00:00
8cfca324f1
Tweaked patch from bug #46287 - Control of header and footer extraction in ExcelExtractor / XSSFExcelExtractor
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775738 13f79535-47bb-0310-9956-ffa450edef68
2009-05-17 18:49:29 +00:00
c444cd27e9
Allow columns greater than 255 and rows greater than 0x100000 in XSSF formulas
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775701 13f79535-47bb-0310-9956-ffa450edef68
2009-05-17 16:35:25 +00:00
2b1d0dd9ab
encapsulated hasUnlimitedVarags() logic into FunctionMetadata
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775575 13f79535-47bb-0310-9956-ffa450edef68
2009-05-17 02:02:48 +00:00
508e2c83cb
Code clean-up in HSSFDataFormat etc. Removed bad characters from TestHSSFDataFormatter. Added comment about international formats.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775570 13f79535-47bb-0310-9956-ffa450edef68
2009-05-17 00:10:36 +00:00
ad56447d05
Base class for "old version" exceptions, and new HSLF detection + use of old versions exception
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775526 13f79535-47bb-0310-9956-ffa450edef68
2009-05-16 20:51:29 +00:00
cf0d23d3de
Fix bug #47154 - Handle the cell format @ as the same as General
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775500 13f79535-47bb-0310-9956-ffa450edef68
2009-05-16 17:39:31 +00:00
eaa9c19074
Bugzilla 47048 - Fixed evaluation of defined names with the 'complex' flag set
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775376 13f79535-47bb-0310-9956-ffa450edef68
2009-05-15 22:47:33 +00:00
b92b2d556b
Fix for bug noticed while investigating bugzilla 47048. Made INDEX() support missing args.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@775360 13f79535-47bb-0310-9956-ffa450edef68
2009-05-15 21:36:25 +00:00
df9cd1738e
Fix bug (broken junit) introduced in r773412. Also hooked up test.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@773441 13f79535-47bb-0310-9956-ffa450edef68
2009-05-11 00:50:45 +00:00
93c369411f
Introduced CustomViewSettingsRecordAggregate. Also reverted some debug changes to EscherAggregate from r773412
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@773438 13f79535-47bb-0310-9956-ffa450edef68
2009-05-11 00:28:45 +00:00
98524ddaf8
Created ChartSubstreamRecordAggregate to manage chart sub-streams. Not fully incorporated yet.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@773434 13f79535-47bb-0310-9956-ffa450edef68
2009-05-10 23:54:29 +00:00
e2793ef74b
Bug 46953 - fixed PageSettingsBlock parsing logic in Sheet. Bug caused sheet EOFs to get misplaced.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@773412 13f79535-47bb-0310-9956-ffa450edef68
2009-05-10 21:34:28 +00:00
f9b0e77d90
Fix javadocs for AbortableHSSFListener, and add unit test to show it all works
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@771865 13f79535-47bb-0310-9956-ffa450edef68
2009-05-05 16:02:06 +00:00
3842f1ff22
Fixed POIFSFileSystem to set CLSID of root when constructing instances from InputStream, see bugzilla 39056
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@766757 13f79535-47bb-0310-9956-ffa450edef68
2009-04-20 17:09:09 +00:00
fe50c3f15c
moved 'throw' into else clause avoiding exception on every call of cloneStyleFrom, see bugzilla 47054
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@766755 13f79535-47bb-0310-9956-ffa450edef68
2009-04-20 16:58:29 +00:00
db553fd510
read GutsRecord in in the Sheet(RecordStream rs)
...
constructor (see bugzilla 46186); always call sheet.setAlternativeExpression in conjuction with sheet.setRowSumsBelow, see bugzilla 46714 and 30714
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@766273 13f79535-47bb-0310-9956-ffa450edef68
2009-04-18 09:06:16 +00:00
62b0595b83
Allow 255 arguments for excel functions in XSSF, see bugzilla 46279
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@766251 13f79535-47bb-0310-9956-ffa450edef68
2009-04-18 07:12:38 +00:00
f41239ad03
Fix for bug 46987 - allow RecordFactory to handle non-zero padding at the end of the workbook stream
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@765866 13f79535-47bb-0310-9956-ffa450edef68
2009-04-17 06:53:49 +00:00
10ee56f313
added Workbook.getName(String) method. Fixed javadoc on related methods
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@765751 13f79535-47bb-0310-9956-ffa450edef68
2009-04-16 20:34:13 +00:00
be1fb69d9b
Fix bug #47034 - Reading the name of a NameRecord when the name is > 127
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@765163 13f79535-47bb-0310-9956-ffa450edef68
2009-04-15 12:42:53 +00:00
050f386bba
removed unused imports of deprecated classes, fixed javadoc errors
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@764203 13f79535-47bb-0310-9956-ffa450edef68
2009-04-11 14:15:27 +00:00
806706b135
Bugzilla 47001 - Fixed WriteAccessRecord and LinkTable to handle unusual format written by Google Docs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@763391 13f79535-47bb-0310-9956-ffa450edef68
2009-04-08 21:01:43 +00:00
bb1ce91342
moved common interfaces from src/ooxml/interfaces-jdk15 to src/java, they do belong there
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@763332 13f79535-47bb-0310-9956-ffa450edef68
2009-04-08 17:51:33 +00:00
60fd0a0fae
Bugzilla 46973 - fixed defined names to behave better when refersToFormula is unset
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@762479 13f79535-47bb-0310-9956-ffa450edef68
2009-04-06 19:57:21 +00:00
6ceeb39a45
consolidate limits specific to Excel version(Excel97, Excel2007) in SpreadsheetVersion enum, allow merged regions with columns greater than 255 or rows bigger than 65536 in XSSF
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@762372 13f79535-47bb-0310-9956-ffa450edef68
2009-04-06 15:06:23 +00:00
527b4c7fc5
Bug 46951 - fixed formula parser to better handle range operators and whole row/column refs.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@762250 13f79535-47bb-0310-9956-ffa450edef68
2009-04-06 08:22:25 +00:00
dc2630494d
Added toString debug method to MemAreaPtg
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@761862 13f79535-47bb-0310-9956-ffa450edef68
2009-04-04 02:53:08 +00:00
0d76928c37
fixed compiler error from r761723
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@761836 13f79535-47bb-0310-9956-ffa450edef68
2009-04-03 23:16:44 +00:00
3bcd8fd479
added SpreadsheetVersion enum to hold version-specific properties such as maximum number of rows and columns, etc.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@761723 13f79535-47bb-0310-9956-ffa450edef68
2009-04-03 16:42:39 +00:00
b558d99132
Changed cell and area ref Ptgs to allow creation using CellReference and AreaReference
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@761553 13f79535-47bb-0310-9956-ffa450edef68
2009-04-03 07:41:29 +00:00
0e7da90f77
Fix for bug 46948 - Range operator can now take area-refs for operands
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@761023 13f79535-47bb-0310-9956-ffa450edef68
2009-04-01 19:41:12 +00:00
fba33cf5a4
Fix for 46918 - Allow shorter format for ExtendedPivotTableViewFieldsRecord(SXVDEX) record
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@760646 13f79535-47bb-0310-9956-ffa450edef68
2009-03-31 21:12:47 +00:00
6fb401a724
Bugzilla 46818 (patch from Wayne Clingingsmith) - added implementation for HYPERLINK function
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@760343 13f79535-47bb-0310-9956-ffa450edef68
2009-03-31 06:09:06 +00:00
91a91b2301
Fix for bug 46898 - Formula evaluator should not cache intermediate circular-reference error results
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@760162 13f79535-47bb-0310-9956-ffa450edef68
2009-03-30 20:46:51 +00:00
51d71180ab
more refactoring of common ss tests
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@759714 13f79535-47bb-0310-9956-ffa450edef68
2009-03-29 16:10:40 +00:00
52ab464cab
improved test cases: moved common hssf-xssf test to org.apache.poi.ss namespace, removed duplicate tests, refactored code to throw same exceptions, etc
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@759112 13f79535-47bb-0310-9956-ffa450edef68
2009-03-27 11:50:52 +00:00
ecf6617071
Fix for bug 46917 - PageItemRecord(SXPI) can contain multiple field infos
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@758770 13f79535-47bb-0310-9956-ffa450edef68
2009-03-26 17:42:18 +00:00
46590f58a1
Fix the block allocation test, but still leave the recent blocks hssf bug fixed
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@758353 13f79535-47bb-0310-9956-ffa450edef68
2009-03-25 17:22:06 +00:00
579a4b95a4
Explicit cast
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@757904 13f79535-47bb-0310-9956-ffa450edef68
2009-03-24 17:00:00 +00:00
d8af6dfdd4
Fix bug #46904 , for old biff5/biff7 files where the block chain is terminated incorrectly
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@757873 13f79535-47bb-0310-9956-ffa450edef68
2009-03-24 16:07:49 +00:00
ef93bdc6ae
Fix for bug 46840 - PageSettingsBlock should include HEADERFOOTER record
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@757520 13f79535-47bb-0310-9956-ffa450edef68
2009-03-23 19:42:39 +00:00
4f4ad37765
Abstracted record construction
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@754828 13f79535-47bb-0310-9956-ffa450edef68
2009-03-16 07:03:13 +00:00
032d57431f
updated url in comment
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@750316 13f79535-47bb-0310-9956-ffa450edef68
2009-03-05 04:54:27 +00:00
e4d94add7f
support built-in data formats in XSSFDataFormat
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@749054 13f79535-47bb-0310-9956-ffa450edef68
2009-03-01 16:24:40 +00:00
1dfecf377c
improved shifting of sheet-level names, also fixed an incorrect Bugzilla number in status.xml
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@748064 13f79535-47bb-0310-9956-ffa450edef68
2009-02-26 09:10:35 +00:00
bebc51def9
more improvements in shiftRows: 1. shift named ranges and merged regions, JUnit added. 2. fixed shiftRows in XSSF to preserve row heights, see bugzilla 46719.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@747894 13f79535-47bb-0310-9956-ffa450edef68
2009-02-25 19:12:06 +00:00
55dfa11284
fixed non-standard ASF license headers
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@747348 13f79535-47bb-0310-9956-ffa450edef68
2009-02-24 11:30:08 +00:00
4862f72197
added setDisplayZeros / isDisplayZeros and getMergedRegion(int) to common interface org.apache.poi.ss.usermodel.Sheet; more progress on testing common xssf-hssf interfaces
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@747307 13f79535-47bb-0310-9956-ffa450edef68
2009-02-24 08:38:16 +00:00
d707f50d5d
Should have been part of c746085 (More fixes to allow EscherContainerRecord to exclusively maintain 'child records' field due to r745976 / r746018)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@746086 13f79535-47bb-0310-9956-ffa450edef68
2009-02-20 01:57:45 +00:00
8dcd0c8c58
More fixes to allow EscherContainerRecord to exclusively maintain 'child records' field. (due to r745976 / r746018)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@746085 13f79535-47bb-0310-9956-ffa450edef68
2009-02-20 01:55:47 +00:00
8a77c05b99
Fix for bug introduced in r745976. EscherContainerRecord shouldn't hand out it's private 'child records' field.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@746018 13f79535-47bb-0310-9956-ffa450edef68
2009-02-19 22:02:14 +00:00
3e6f2bbf80
Added Apache License text to files where it was missing. Also fixed some compiler warnings in those files.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@745976 13f79535-47bb-0310-9956-ffa450edef68
2009-02-19 19:50:20 +00:00
d527d61af4
fixed typo in toString()
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@745972 13f79535-47bb-0310-9956-ffa450edef68
2009-02-19 19:05:06 +00:00
6fa67727ea
fixed autoSizeColumn() to use cached formula values when processing formula cells, see bug #46736
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@745937 13f79535-47bb-0310-9956-ffa450edef68
2009-02-19 17:29:55 +00:00
5d5f76be67
Fixed formula parser to handle names with backslashes
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@744749 13f79535-47bb-0310-9956-ffa450edef68
2009-02-15 20:45:24 +00:00
7c870ecd41
fixed compiler warnings. added some TODO comments
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@744257 13f79535-47bb-0310-9956-ffa450edef68
2009-02-13 22:11:16 +00:00
521656d9c2
Bugzilla 46660 - added 'hidden' property to Workbook
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@744253 13f79535-47bb-0310-9956-ffa450edef68
2009-02-13 21:46:44 +00:00
8edb507a89
Fix for bug 46693 - serialization errors in CHARTFORMAT, SHTPROPS, SXVD and SXVDEX records
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@743601 13f79535-47bb-0310-9956-ffa450edef68
2009-02-12 02:28:43 +00:00
ffe6fd7a23
Minor code clean-up
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@743484 13f79535-47bb-0310-9956-ffa450edef68
2009-02-11 20:23:08 +00:00
12321616a3
fixed record name in toString() close element
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@742839 13f79535-47bb-0310-9956-ffa450edef68
2009-02-10 03:41:08 +00:00
4b5616a6ca
Refactored common CellValueRecordInterface code into a new superclass CellRecord
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@742785 13f79535-47bb-0310-9956-ffa450edef68
2009-02-09 23:16:49 +00:00
771369c409
Fixed serialization of multiple blank records (should get aggregated into MulBlankRecord)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@741850 13f79535-47bb-0310-9956-ffa450edef68
2009-02-07 07:39:23 +00:00
23cf469315
changed. Sheet.setColumnWidth to throw IllegalArgumentException if the column width argument is greater than 255 characters (the maximum column width in Excel)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@741678 13f79535-47bb-0310-9956-ffa450edef68
2009-02-06 18:59:24 +00:00
aac8563019
Fix for bug 46654 - HSSFRow/RowRecord needs to properly update cell boundary indexes
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@741036 13f79535-47bb-0310-9956-ffa450edef68
2009-02-05 07:39:57 +00:00
d7c95a10c8
Fixed deprecated references to HSSFSheet.getRow(short) etc. Removed all deprecated warnings from hssf.usermodel.examples.*
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@740179 13f79535-47bb-0310-9956-ffa450edef68
2009-02-03 01:19:13 +00:00
011fafc7ae
Modified formula parser to encode SUM taking a single argument as tAttrSum (from comment 7 of bugzilla 46643)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@740159 13f79535-47bb-0310-9956-ffa450edef68
2009-02-02 23:53:22 +00:00
e3775b8b1d
Fix for bug 46643 - formula parser should encode range operator with tMemFunc
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@740146 13f79535-47bb-0310-9956-ffa450edef68
2009-02-02 23:10:30 +00:00
7cbc3b9067
Added toString methods to help debugging
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@740123 13f79535-47bb-0310-9956-ffa450edef68
2009-02-02 22:11:48 +00:00
4057cb7cf0
Fix for bug 46647 - COUNTIF NE operator and other special cases involving type conversion
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@740088 13f79535-47bb-0310-9956-ffa450edef68
2009-02-02 19:42:57 +00:00
7a842bc264
fixed bugs 40520 and 46553: HSSFFont.applyFont() formats wrong parts of HSSFRichTextString
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@738908 13f79535-47bb-0310-9956-ffa450edef68
2009-01-29 16:03:52 +00:00
980ff2cf30
Fix for bug 46545 - ObjRecord should ignore excessive padding written by previous POI versions
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@738709 13f79535-47bb-0310-9956-ffa450edef68
2009-01-29 01:57:22 +00:00
0b692dd75c
Fix for bug 46613 - evaluator should perform case insensitive string comparisons
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@738188 13f79535-47bb-0310-9956-ffa450edef68
2009-01-27 19:02:13 +00:00
c3258085c7
Follow-up fix for r737173 and r737238 (patch 46544) - filename arg was not properly parsed.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@737248 13f79535-47bb-0310-9956-ffa450edef68
2009-01-23 23:34:22 +00:00
184ec62cf4
Follow-up fix for r737173 (patch 46544) - filename arg was not properly parsed.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@737238 13f79535-47bb-0310-9956-ffa450edef68
2009-01-23 23:06:56 +00:00
d800ec6a84
Bugzilla 45644 - adding a command line interface to hssf ExcelExtractor
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@737173 13f79535-47bb-0310-9956-ffa450edef68
2009-01-23 20:12:13 +00:00
59e334e8a5
Replaced ErrorEval.FUNCTION_NOT_IMPLEMENTED with new exception NotImplementedException. Removed test case involving ISREF which was working for the wrong reasons.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@736505 13f79535-47bb-0310-9956-ffa450edef68
2009-01-22 00:26:28 +00:00
c013d9b7c9
Fixing compiler warnings
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@736479 13f79535-47bb-0310-9956-ffa450edef68
2009-01-21 23:17:45 +00:00
6756ffefe0
Fixed HSSFCell/FormulaRecordAggregate to properly remove StringRecord when cached result type changes.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@736476 13f79535-47bb-0310-9956-ffa450edef68
2009-01-21 23:11:45 +00:00
07fd83a278
Fix for bug 46547 - Allow for addition of conditional formatting when data validations are present. Avoid creation of and empty conditional formatting table while shifting formulas.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@736175 13f79535-47bb-0310-9956-ffa450edef68
2009-01-21 00:19:49 +00:00
73a498fb35
Removed unused, erroneous import
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@735208 13f79535-47bb-0310-9956-ffa450edef68
2009-01-17 02:27:13 +00:00
306c28cc28
Bug 46548 - fixes for Page Settings Block (patch from Dmitriy Kumshayev + some mods)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@735179 13f79535-47bb-0310-9956-ffa450edef68
2009-01-16 23:13:11 +00:00
98a6bded10
Updated class comment
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@735174 13f79535-47bb-0310-9956-ffa450edef68
2009-01-16 22:54:42 +00:00
7dad2164cd
Fixing bug 46551 - spelling mistakes in xSSFCell.checkBounds(). Also fixed 0/1-based index error for cell range checks in XSSF.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@735061 13f79535-47bb-0310-9956-ffa450edef68
2009-01-16 17:31:29 +00:00
b280b299a0
resolved error constants in BoolErrRecord
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@734281 13f79535-47bb-0310-9956-ffa450edef68
2009-01-14 00:22:00 +00:00
d4ec8ceb11
Bugzilla 46523 - added implementation for SUMIF
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@734252 13f79535-47bb-0310-9956-ffa450edef68
2009-01-13 22:02:52 +00:00
9c05b68576
Improvements to countif implementation in preparation for sumif
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@734243 13f79535-47bb-0310-9956-ffa450edef68
2009-01-13 21:22:37 +00:00
ea421dab2b
Support for reading HSSF column styles
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@732112 13f79535-47bb-0310-9956-ffa450edef68
2009-01-06 20:49:02 +00:00
68e203d5e6
Fix bug #46472 - Avoid NPE in HPSFPropertiesExtractor when no properties exist
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@732058 13f79535-47bb-0310-9956-ffa450edef68
2009-01-06 18:59:42 +00:00
6e2f255f14
Fix for bug 46479 - conversion of cached formula values and HSSFFormulaEvaluator.evaluateInCell()
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@731715 13f79535-47bb-0310-9956-ffa450edef68
2009-01-05 20:58:02 +00:00
3bdb856e58
Fix for 45031 - added implementation for CHOOSE function.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@730469 13f79535-47bb-0310-9956-ffa450edef68
2008-12-31 20:32:47 +00:00
df7d120dc6
Simplifying ValueEval hierarchy, added comments to Function and OperationEval.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@730450 13f79535-47bb-0310-9956-ffa450edef68
2008-12-31 19:32:44 +00:00
d9df585ca5
Patch 46410 from Steven Butler - added impl for TIME() function.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@730309 13f79535-47bb-0310-9956-ffa450edef68
2008-12-31 05:31:42 +00:00
0e193f895b
added HSSFPictureData.getFormat() as requested in #46320
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@730213 13f79535-47bb-0310-9956-ffa450edef68
2008-12-30 18:51:56 +00:00
49297979bb
move hyperlinks when shifting rows
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@730076 13f79535-47bb-0310-9956-ffa450edef68
2008-12-30 09:24:15 +00:00
177533e23b
fixed formula parser to correctly resolve sheet-level names
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@729028 13f79535-47bb-0310-9956-ffa450edef68
2008-12-23 16:19:07 +00:00
98121b7691
1. added support for shared formulas in XSSF, see bug #464332 . improved validation of workbook-global and sheet-global names
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@728749 13f79535-47bb-0310-9956-ffa450edef68
2008-12-22 19:32:44 +00:00
9a665498f8
Added getters to parent objects: HSSFSheet.getWorkbook(), HSSFRow.getSheet() and HSSFCell.getRow()
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@727469 13f79535-47bb-0310-9956-ffa450edef68
2008-12-17 18:55:07 +00:00
60afb94fdb
Fix for bug 46385 (by patch 46362 from Matsuyama Tomohiro) fixed serialization of StyleRecord with unicode name
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@726969 13f79535-47bb-0310-9956-ffa450edef68
2008-12-16 05:44:32 +00:00
13860fc475
1. fixed HSSFCell.setCellFormula to call HSSFFormulaParser.parse before any cell modifications, if it fails the cell must be left in the state prior to the invocation. 2. added @throws javadoc to HSSFRow.createCell and XSSFRow.createCell, see bug #10393 3. fixed incorrect condition type in CFRuleRecord if the rule is a formula
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@726049 13f79535-47bb-0310-9956-ffa450edef68
2008-12-12 15:36:05 +00:00
015af7c141
Fix bug #46368 - HSSFRichTextRun and strings longer than 32768 characters
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@724848 13f79535-47bb-0310-9956-ffa450edef68
2008-12-09 19:36:53 +00:00
2ae887e98c
1. Support sheet-level names2. Fixed XSSFCell to properly handle cell references with column numbers up to XFD3. when pasring formula, HSSFName.setRefersToFormula must set type of operands to Ptg.CLASS_REF, otherwise created named don't appear in the dropdown to the left of formula bar in Excel
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723392 13f79535-47bb-0310-9956-ffa450edef68
2008-12-04 18:38:00 +00:00
b91e7e7cbb
fixed compiler error due unused import
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723195 13f79535-47bb-0310-9956-ffa450edef68
2008-12-04 02:51:01 +00:00
11cc164f26
Initial add of ForkedEvaluator functionality
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723194 13f79535-47bb-0310-9956-ffa450edef68
2008-12-04 02:48:24 +00:00
1869eb5186
should have been part of c723161 (re-arranging methods getRecordSize and getDataSize in Record / StandardRecord / ContinuableRecord hierarchy)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723164 13f79535-47bb-0310-9956-ffa450edef68
2008-12-04 00:15:54 +00:00
8be658a251
re-arranging methods getRecordSize and getDataSize in Record / StandardRecord / ContinuableRecord hierarchy
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723161 13f79535-47bb-0310-9956-ffa450edef68
2008-12-04 00:08:45 +00:00
2ebe3f7e32
Minor code improvements, fixed comments
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723146 13f79535-47bb-0310-9956-ffa450edef68
2008-12-03 23:39:11 +00:00
3a9e4eb667
Improvements to arg checking in constructor
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723141 13f79535-47bb-0310-9956-ffa450edef68
2008-12-03 23:35:18 +00:00
bff86351a1
more generics compiler warnings fixes for poi.ss.formula
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723104 13f79535-47bb-0310-9956-ffa450edef68
2008-12-03 22:34:26 +00:00
d289d148b3
fixed generics compiler warnings for poi.ss.formula
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@723021 13f79535-47bb-0310-9956-ffa450edef68
2008-12-03 19:22:45 +00:00
ed2b70b976
modified EvaluationCell to make Evaluation API more easily wrapable.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@722778 13f79535-47bb-0310-9956-ffa450edef68
2008-12-03 05:07:31 +00:00
ba3de4c4d2
Final fix for bug 44914 - Removed warning message "WARN. Unread n bytes of record 0xNN"
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@722401 13f79535-47bb-0310-9956-ffa450edef68
2008-12-02 08:46:13 +00:00
b2713da293
Fix for bug 46156 - improved POI's number rendering to more closely match Excel's
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@722284 13f79535-47bb-0310-9956-ffa450edef68
2008-12-01 23:24:23 +00:00
8be4abf717
Generics warnings and other clean-up in HSSFSheet
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@722223 13f79535-47bb-0310-9956-ffa450edef68
2008-12-01 20:52:27 +00:00
2014a596be
Fix for bug 46312 - ValueRecordsAggregate should handle removal of new empty row
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@722206 13f79535-47bb-0310-9956-ffa450edef68
2008-12-01 19:59:46 +00:00
886de704ff
Improved error message when attempting to read BIFF2 file (bugzilla 46269)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721620 13f79535-47bb-0310-9956-ffa450edef68
2008-11-29 03:12:39 +00:00
5f3c3d71a3
Simplified logic in getStyleRecord() (investigating bug 46259)
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721614 13f79535-47bb-0310-9956-ffa450edef68
2008-11-29 02:07:49 +00:00
2b6a9c351e
Fixed generics compiler warnings in Workbook. Other minor code clean-up.
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721602 13f79535-47bb-0310-9956-ffa450edef68
2008-11-29 00:46:33 +00:00
45287875d7
Fix for bug 46206 - tolerate missing DIMENSION records
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721586 13f79535-47bb-0310-9956-ffa450edef68
2008-11-28 23:24:06 +00:00
c87a1fe88a
improved toString methods
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721043 13f79535-47bb-0310-9956-ffa450edef68
2008-11-27 00:17:28 +00:00
b780e3173a
removed unused method
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721037 13f79535-47bb-0310-9956-ffa450edef68
2008-11-26 23:39:35 +00:00
5e29862bea
Patch 46301 - (from Patrick Cheng) - added some pivot table records: SXDI, SXVDEX, SXPI, SXIDSTM, SXVIEW, SXVD, SXVS, and others.
...
Improved command line parsing in BiffViewer
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@721007 13f79535-47bb-0310-9956-ffa450edef68
2008-11-26 22:32:07 +00:00
e95e166390
fixed NPE in HyperlinkRecord.toString()
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@720997 13f79535-47bb-0310-9956-ffa450edef68
2008-11-26 22:00:29 +00:00
7735bb1b3b
Fix for bug 46280 - RowRecordsAggregate should allow for ContinueRecords after UnkownRecords, and PivotTable records should not get in the RowRecordsAggregate at all
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@720318 13f79535-47bb-0310-9956-ffa450edef68
2008-11-24 22:40:46 +00:00
796a0eea4f
renamed Name.setFormula to more descriptive setRefersToFormula, also misc improvements in the site docs
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@719547 13f79535-47bb-0310-9956-ffa450edef68
2008-11-21 09:22:07 +00:00
e796abd3fa
Fixes / additions for reserialization of HyperlinkRecord
...
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@719546 13f79535-47bb-0310-9956-ffa450edef68
2008-11-21 09:09:25 +00:00
Josh Micich