dev@poi.apache.org Archives

DO NOT REPLY [Bug 48343] [PATCH] SUBTOTAL function

2009-12-08T17:45:24Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48343

Josh Micich  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #2 from Josh Micich  2009-12-08 09:45:22 UTC ---
Applied in svn r888490

Thanks for the patch.  I made slight tweaks and added some javadoc.  Please
reply if the changes are NQR.

The unit test you supplied looked fine.  It shows well the coverage of
supported functionality.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: [VOTE] Release of POI 3.6

2009-12-08T13:20:37Z


Hi

I need to copy a XSSFSheet from one XSSFWorkbook to an other XSSFWorkbook.
How can I do that?
same with HSSFWorkbook.
It will be very great help if you can provide me a solution for this. I have
been trying to play around the source code of 3.5 to achieve this. But could
not achieve anything regarding this.

Thanks in advance

Anita


Yegor Kozlov-3 wrote:
> 
> Hi All,
> 
> I have built a release candidate for POI-3.6. Please test-drive and vote.
> 
> The release artifacts can be downloaded from 
> http://people.apache.org/~yegor/POI-3.6/
> A staging Maven repository containing the artifacts to be released is
> http://people.apache.org/~yegor/m2-repository/
> 
> The revision number of the release is r887879 and tagged as REL_3_6 on Dec
> 7 2009.
> 
> Please note that POI-3.6 includes new jars and Maven artifacts:
> 
>    (1) poi-ooxml-schemas
>    This is a 'lite' version of ooxml-schemas-1.0.jar. This jar replaces
> the big ooxml-schemas-1.0.jar in the binary 
> distributions and Maven POMs.
> 
>    (2) poi-examples - This jar includes merged examples (main, scratchpad
> and ooxml). Users requested it several times 
> and I don't see why we should not distribute it.
> 
>    (3) Maven distribution now includes sources. Each individual JAR is
> accompanied by a -sources.jar:
> 
> 	poi-3.6-sources-20091214.jar
> 	poi-contrib-3.6-sources-20091214.jar
> 	poi-ooxml-3.6-sources-20091214.jar
> 	poi-scratchpad-3.6-sources-20091214.jar
> 	poi-examples-3.6-sources-20091214.jar
> 
> The vote options are:
> 
> [ ]+1  - I support the release
> [ ] 0  - I don't care
> [ ]-1  - I'm opposed to the release because...
> 
> I'm voting [+1]. Voting will last 7 days and end on Monday, December 14.
> 
> Yegor
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/-VOTE--Release-of-POI-3.6-tp26677510p26693788.html
Sent from the POI - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: [VOTE] Release of POI 3.6

2009-12-08T13:20:03Z


Hi

I need to copy a XSSFSheet from one XSSFWorkbook to an other XSSFWorkbook.
How can I do that?
same with HSSFWorkbook.
It will be very great help if you can provide me a solution for this. I have
been trying to play around the source code of 3.5 to achieve this. But could
not achieve anything regarding this.

Thanks in advance

Anita


Yegor Kozlov-3 wrote:
> 
> Hi All,
> 
> I have built a release candidate for POI-3.6. Please test-drive and vote.
> 
> The release artifacts can be downloaded from 
> http://people.apache.org/~yegor/POI-3.6/
> A staging Maven repository containing the artifacts to be released is
> http://people.apache.org/~yegor/m2-repository/
> 
> The revision number of the release is r887879 and tagged as REL_3_6 on Dec
> 7 2009.
> 
> Please note that POI-3.6 includes new jars and Maven artifacts:
> 
>    (1) poi-ooxml-schemas
>    This is a 'lite' version of ooxml-schemas-1.0.jar. This jar replaces
> the big ooxml-schemas-1.0.jar in the binary 
> distributions and Maven POMs.
> 
>    (2) poi-examples - This jar includes merged examples (main, scratchpad
> and ooxml). Users requested it several times 
> and I don't see why we should not distribute it.
> 
>    (3) Maven distribution now includes sources. Each individual JAR is
> accompanied by a -sources.jar:
> 
> 	poi-3.6-sources-20091214.jar
> 	poi-contrib-3.6-sources-20091214.jar
> 	poi-ooxml-3.6-sources-20091214.jar
> 	poi-scratchpad-3.6-sources-20091214.jar
> 	poi-examples-3.6-sources-20091214.jar
> 
> The vote options are:
> 
> [ ]+1  - I support the release
> [ ] 0  - I don't care
> [ ]-1  - I'm opposed to the release because...
> 
> I'm voting [+1]. Voting will last 7 days and end on Monday, December 14.
> 
> Yegor
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/-VOTE--Release-of-POI-3.6-tp26677510p26693778.html
Sent from the POI - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[VOTE] Release of POI 3.6

2009-12-07T13:49:03Z

Hi All,

I have built a release candidate for POI-3.6. Please test-drive and vote.

The release artifacts can be downloaded from  http://people.apache.org/~yegor/POI-3.6/
A staging Maven repository containing the artifacts to be released is http://people.apache.org/~yegor/m2-repository/

The revision number of the release is r887879 and tagged as REL_3_6 on Dec 7 2009.

Please note that POI-3.6 includes new jars and Maven artifacts:

   (1) poi-ooxml-schemas
   This is a 'lite' version of ooxml-schemas-1.0.jar. This jar replaces the big ooxml-schemas-1.0.jar
in the binary 
distributions and Maven POMs.

   (2) poi-examples - This jar includes merged examples (main, scratchpad and ooxml). Users
requested it several times 
and I don't see why we should not distribute it.

   (3) Maven distribution now includes sources. Each individual JAR is accompanied by a -sources.jar:

	poi-3.6-sources-20091214.jar
	poi-contrib-3.6-sources-20091214.jar
	poi-ooxml-3.6-sources-20091214.jar
	poi-scratchpad-3.6-sources-20091214.jar
	poi-examples-3.6-sources-20091214.jar

The vote options are:

[ ]+1  - I support the release
[ ] 0  - I don't care
[ ]-1  - I'm opposed to the release because...

I'm voting [+1]. Voting will last 7 days and end on Monday, December 14.

Yegor




---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48343] [PATCH] SUBTOTAL function

2009-12-07T11:06:54Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48343

--- Comment #1 from Paul Tomlin  2009-12-07 03:06:51 UTC ---
Created an attachment (id=24675)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24675)
testcase

manual tests mimicking existing tests in the same package

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48344] New: setRowStyle() method of HSSFRow is not working

2009-12-07T09:28:16Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48344

           Summary: setRowStyle() method of HSSFRow is not working
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: mrayandutta@gmail.com


I have tried using the setRowStyle() method of a HSSFRow  object .
It is not working .
In a similar manner I have tried using setCellStyle() method of HSSFCell object
,that is working fine .
In some of the forums it was suggested that may be a misplaced jar files or
conflict within the jars can be a reason . But I used only the 
poi-3.5-FINAL-20090928.jar as well as a combination of jar files such as 

1.poi-3.5-FINAL-20090928.jar
2.poi-contrib-3.5-FINAL-20090928.jar
3.poi-ooxml-3.5-FINAL-20090928.jar
4.poi-scratchpad-3.5-FINAL-20090928.jar

In both cases setRowStyle() is not working .

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48261] Can't open an Excel 97 file with POI

2009-12-07T08:22:31Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48261

--- Comment #2 from Baris Ulucinar  2009-12-07 00:22:27 UTC
---
I Have the same error, with the same version of Apache POI: 3.5-FINAL, it's a
patch available ? 

my error log: 

java.lang.ArrayIndexOutOfBoundsException: 0
    at
org.apache.poi.poifs.storage.DocumentBlock.getDataInputBlock(DocumentBlock.java:163)
    at
org.apache.poi.poifs.filesystem.POIFSDocument.getDataInputBlock(POIFSDocument.java:253)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.getDataInputBlock(DocumentInputStream.java:117)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.(DocumentInputStream.java:75)
    at
org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(DirectoryNode.java:131)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:273)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:200)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:316)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:297)
    at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)

--- Comment #3 from Baris Ulucinar  2009-12-07 00:22:27 UTC
---
I Have the same error, with the same version of Apache POI: 3.5-FINAL, it's a
patch available ? 

my error log: 

java.lang.ArrayIndexOutOfBoundsException: 0
    at
org.apache.poi.poifs.storage.DocumentBlock.getDataInputBlock(DocumentBlock.java:163)
    at
org.apache.poi.poifs.filesystem.POIFSDocument.getDataInputBlock(POIFSDocument.java:253)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.getDataInputBlock(DocumentInputStream.java:117)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.(DocumentInputStream.java:75)
    at
org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(DirectoryNode.java:131)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:273)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:200)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:316)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:297)
    at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48261] Can't open an Excel 97 file with POI

2009-12-07T08:22:31Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48261

--- Comment #2 from Baris Ulucinar  2009-12-07 00:22:27 UTC
---
I Have the same error, with the same version of Apache POI: 3.5-FINAL, it's a
patch available ? 

my error log: 

java.lang.ArrayIndexOutOfBoundsException: 0
    at
org.apache.poi.poifs.storage.DocumentBlock.getDataInputBlock(DocumentBlock.java:163)
    at
org.apache.poi.poifs.filesystem.POIFSDocument.getDataInputBlock(POIFSDocument.java:253)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.getDataInputBlock(DocumentInputStream.java:117)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.(DocumentInputStream.java:75)
    at
org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(DirectoryNode.java:131)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:273)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:200)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:316)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:297)
    at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)

--- Comment #3 from Baris Ulucinar  2009-12-07 00:22:27 UTC
---
I Have the same error, with the same version of Apache POI: 3.5-FINAL, it's a
patch available ? 

my error log: 

java.lang.ArrayIndexOutOfBoundsException: 0
    at
org.apache.poi.poifs.storage.DocumentBlock.getDataInputBlock(DocumentBlock.java:163)
    at
org.apache.poi.poifs.filesystem.POIFSDocument.getDataInputBlock(POIFSDocument.java:253)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.getDataInputBlock(DocumentInputStream.java:117)
    at
org.apache.poi.poifs.filesystem.DocumentInputStream.(DocumentInputStream.java:75)
    at
org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(DirectoryNode.java:131)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:273)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:200)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:316)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:297)
    at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48343] New: [PATCH] SUBTOTAL function

2009-12-07T07:50:58Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48343

           Summary: [PATCH] SUBTOTAL function
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Mac OS X 10.4
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: pault@bulksms.com


Created an attachment (id=24673)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24673)
Implementation of SUBTOTAL + FunctionEval change

A patch for a very simple implementation of the SUBTOTAL function.

This works for the unit tests I have for an internal project processing 3rd
party Excel spreadsheets though at this point I have no POI specific tests.

The specific formulas curently tested are SUBTOTAL(9, )

http://poi.apache.org/spreadsheet/eval-devguide.html seems to be out of date, I
can find no GenericFormulaTestCase class.

Comments on the strategy used in the patch and current test writing outline
would be appreciated.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48327] cloneSheet() gives an "Error file: data may have been lost" in Excel 2003 or higher if sheet contains commented cells

2009-12-05T11:18:03Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48327

Fabrizio Giustina  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fgiust@apache.org

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: Implemention of SUBTOTAL

2009-12-04T17:41:16Z

Hello Paul,

> I've worked up a simple implementation of the SUBTOTAL function which seems
> to work for my current tests though I'm sure it will fail in cases I've not
> looked at yet.

If your SUBTOTAL implementation works OK for *your* needs, then there
is a high chance it will be useful to anyone else who may stumble
across it while evaluating spreadsheets.  Don't worry that your
implementation doesn't cover every special case - many of the existing
function implementations are incomplete too.  As POI users come across
new scenarios not covered yet, the existing code gets augmented.  One
of the most important things is that the test cases you provide
properly represent your usage of this function.  With these in place,
there is less chance that future work might break something you are
relying on.

> Since I've not worked with POI much I'd like to get some feedback and
> possibly mentoring to build this into something suitable for committing.
>
> Should I simply create a PATCH bug or would the list/off-list be a better
> place to discuss this?

Patches for bug fixes or enhancements are always welcome.  Go ahead
and create a bugzilla entry for this work.  Once you've uploaded your
patch file we can discuss any potential adjustments before committing.

Regards,
josh

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: Text Substitution for Word 2007 in POI 3.5

2009-12-04T15:52:31Z

.........and that will not work because there is no way to recover the runs
from the paragraphs or from the document for that matter. So, without
digging deeply into the structure of the docx file via the various beans or
patching the API so that you can perfrom search and replace operations, I
think you have two options.

Assuming that it was possible to perform these operations using an earlier
version of the API, then it may be best to revert to using that version for
now. Secondly, and far, far more risky, would be to use Java code to simply
unzip the docx file, to open document.xml, search for and replace the
specific items of text, resave the file and, finally, re-zip it. This does
pose a number of risks however and it is certainly not something I would
consider lightly but I do know that it is possible because I played around
with a docx file today in exactly that manner.

Yours

Mark B

Rafael Paiva wrote:
> 
> I assume it's not available. Any plans for having this back on 3.6? Any
> undocumented workaround for 3.5?
> 
>  
> 
> Thanks!
> 
>  
> 
> Rafael.
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Text-Substitution-for-Word-2007-in-POI-3.5-tp26624595p26635931.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48338] XSSFSheet autoSizeColumn() on empty RichTextString fails

2009-12-04T11:24:56Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48338

Yegor Kozlov  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #1 from Yegor Kozlov  2009-12-04 03:24:54 UTC ---
Fixed in r887160

Yegor

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48339] New: Exception threw when filtering the attached Excel using tika-app-0.4.jar

2009-12-04T08:46:47Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48339

           Summary: Exception threw when filtering the attached Excel
                    using tika-app-0.4.jar
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows Server 2003
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: leon800219@gmail.com


Created an attachment (id=24670)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24670)
xls file containing several embedded object that will cause the exception

I got an exception when filtering the attached Excel file using "type bugs.xls
| java -jar tika-app -0.4.jar -". 

The embedded object seemed to cause the problem, exception stack trace follows.




Exception in thread "main" org.apache.tika.exception.TikaException:
Unexpected RuntimeException from
org.apache.tika.parser.microsoft.OfficeParser@651dba45
       at
org.apache.tika.parser.CompositeParser.parse(CompositeParser.java:122)
       at
org.apache.tika.parser.AutoDetectParser.parse(AutoDetectParser.java:101)
       at org.apache.tika.cli.TikaCLI.process(TikaCLI.java:175)
       at org.apache.tika.cli.TikaCLI.main(TikaCLI.java:62)
Caused by: org.apache.poi.hssf.record.RecordFormatException: Unable to
construct record instance
       at
org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:64)
       at
org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:263)
       at
org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:270)
       at
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:236)
       at
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:122)
       at
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:85)
       at
org.apache.tika.parser.microsoft.ExcelExtractor.parse(ExcelExtractor.java:145)
       at
org.apache.tika.parser.microsoft.OfficeParser.parse(OfficeParser.java:114)
       at
org.apache.tika.parser.CompositeParser.parse(CompositeParser.java:120)
       ... 3 more
Caused by: org.apache.poi.hssf.record.RecordFormatException: Ran out
of record data trying to read formula. fields: (option=-12 index=11540
not_used=353 name=''')
       at
org.apache.poi.hssf.record.ExternalNameRecord.readFail(ExternalNameRecord.java:177)
       at
org.apache.poi.hssf.record.ExternalNameRecord.(ExternalNameRecord.java:164)
       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
       at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
       at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
       at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
       at
org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:56)
       ... 11 more

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Implemention of SUBTOTAL

2009-12-04T08:38:42Z

Hi,
I've worked up a simple implementation of the SUBTOTAL function which  
seems to work for my current tests though I'm sure it will fail in  
cases I've not looked at yet.

Since I've not worked with POI much I'd like to get some feedback and  
possibly mentoring to build this into something suitable for committing.

Should I simply create a PATCH bug or would the list/off-list be a  
better place to discuss this?

Regards,

Paul Tomlin

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48338] New: XSSFSheet autoSizeColumn() on empty RichTextString fails

2009-12-04T08:11:25Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48338

           Summary: XSSFSheet autoSizeColumn() on empty RichTextString
                    fails
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: poelman@traffic4u.nl


After filling a sheet with data I try to invoke the sheets autoSizeColumn
method on a certain column but get "IllegalArgumentException: Invalid substring
range".

------------------------------------
StackTrace:
------------------------------------
java.lang.IllegalArgumentException: Invalid substring range
 at java.text.AttributedString.addAttribute(AttributedString.java:332)
 at
org.apache.poi.xssf.usermodel.helpers.ColumnHelper.copyAttributes(ColumnHelper.java:447)
    at
org.apache.poi.xssf.usermodel.helpers.ColumnHelper.getColumnWidth(ColumnHelper.java:369)
    at
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:307)
    at
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:290)
    at [object where sheet.autoSizeColumn([columnIndex]) is called]
------------------------------------

After testing different columns I came to the conclusion this only happens on
that specific column, even unfilled columns can be autosized. I searched for
the reason inside the cells of that column and discovered this happens only in
a specific situation. If the cell is filled with a RichTextString created with
an empty String and a Font (or XSSFFont) applied the column with this cell in
it can't be autosized. Example:

********** Code **********
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = new wb.createSheet("Test");
CreationHelper ch = wb.getCreationHelper();

XSSFRow row = sheet.createRow(0);
XSSFCell cell = row.createCell(0);

XSSFFont font = wb.createFont();
RichTextString rts = ch.createRichtTextString("");
rts.applyFont(font);
cell.setCellValue(rts);
**************************

The code above does not work unless I invoke ch.createRichtextString(x) where x
is a non empty String. So my fix atm is: ch.createRichTextString(s.isEmpty()?
"" : s); where s is the String.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] Error reading date

2009-12-04T05:07:01Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

--- Comment #5 from vdhanda@epistemic.com 2009-12-03 21:06:58 UTC ---
Thanks Josh.    

It seems that the "culprit" is HSSFDateUtil.isValidExcelDate(double value). 
The fix might be as simple as unconditionally returning "true" in that method
instead of the current "return (value > -Double.MIN_VALUE);"

I pretty much did that and it worked for me.

Perhaps, as a courtesy, one could "guard" this change with a
-DinterpretNegativeValuesAsDate flag.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48325] bad text 'Page &P of &N' and similar errors when reading in spreadsheets

2009-12-04T03:21:23Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48325

--- Comment #2 from Trejkaz  2009-12-03 19:21:22 UTC ---
Created an attachment (id=24669)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24669)
Proposed patch

Patch which makes that test pass.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48325] bad text 'Page &P of &N' and similar errors when reading in spreadsheets

2009-12-04T03:20:12Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48325

--- Comment #1 from Trejkaz  2009-12-03 19:20:09 UTC ---
Created an attachment (id=24668)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24668)
Sample file

Sample file attached, was created using an XLS file output from POI but then
mangling the footer to have the problem described.

Test case would look something like this (though there is a small amount of our
own utility method calls up the top):

    @Test
    public void testIllegalFooterText() throws Exception
    {
        HSSFWorkbook wb =
loadWorkbook(getDataFile("office/illegal-footer-text.xls"));
        HSSFSheet sh = wb.getSheetAt(0);
        HSSFFooter f = sh.getFooter();

        // The legal form of the footer would have been "&CBlahBlah Blah Blah 
" but something
        // left the &C off.  In this case it was me and a hex editor.  In the
cases we have seen
        // in the wild it's probably some idiot who thought they knew how to
add a footer but didn't.

        assertEquals("Left text should be empty", "", f.getLeft());
        assertEquals("Right text should be empty", "", f.getRight());
        assertEquals("Center text should contain the illegal value", "BlahBlah
blah blah  ", f.getCenter());
    }

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] Error reading date

2009-12-03T23:17:29Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

Josh Micich  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |NEEDINFO

--- Comment #4 from Josh Micich  2009-12-03 15:17:26 UTC ---
A short term work around is for you to use methods from DateUtil like
setCalendar to calculate dates with negative 'serial date' values.  However it
seems like you might be requesting a real change (to how POI behaves).

Normally such an enhancement request is rejected on the grounds that it
involves POI doing something that Excel considers invalid.  However, I agree
that the functionality you desire is very reasonable.  I think the restriction
on dates before 1900 is silly.  On the other hand, we can't go about
implementing every request for features from other applications that go beyond
the Excel file format spec.

I want to wait for comments from other POI committers before doing anything. 
There is also the general question of how we accept/reject/prioritize bugs and
feature requests that raise issues of compliance with other applications.  I
don't know of any POI documentation that deals with this.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46479] [PATCH] evaluateInCell fails if the formula was previously invalid

2009-12-03T22:23:55Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=46479

--- Comment #4 from Josh Micich  2009-12-03 14:23:52 UTC ---
Additional similar fixes applied in svn r886951

Problems occurred when changing a formula cell to type string.  These cases
weren't addressed in the previous fix.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: a 'lite' version of ooxml-schemas jar

2009-12-03T21:45:29Z

Hi,

On Thu, Dec 3, 2009 at 5:58 PM, Yegor Kozlov  wrote:
> the problem should be fixed in r886733.
> At least, Tika trunk compiles OK against poi-ooxml-schemas produced from POI
> trunk. JUnits run OK too.

Excellent, thanks!

BR,

Jukka Zitting

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] Error reading date

2009-12-03T18:14:08Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

vdhanda@epistemic.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|INVALID                     |

--- Comment #3 from vdhanda@epistemic.com 2009-12-03 10:14:08 UTC ---
Can you try opening it in OpenOffice.  It shows the correct value as
12/31/1896.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] Error reading date

2009-12-03T18:04:24Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

Josh Micich  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID

--- Comment #2 from Josh Micich  2009-12-03 10:04:23 UTC ---
There is something wrong with cell D1.  It displays as
'#######################' in my Excel 2007.  Excel has roll-over tip text that
provides more information: "Dates and times that are negative or too large
display as ######."
Indeed the cell value is -1094
HSSFCell.getNumericCellValue() should return -1094.0 and
HSSFCell.getDateCellValue() should return null due to this invalid date value.

The cell has a custom format 'mmm-dd-yyyy' which suggests that the application
that wrote this file intended for the cell to have a date value.

I am marking this bug as invalid because it appears that the problem is with
"SoftArtisans OfficeWriter"

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: Text Substitution for Word 2007 in POI 3.5

2009-12-03T18:01:07Z

Sorry to say Rafael that I am not sure what it is that you are asking. I have
just a a very quick - cursory - glance at the javadoc for the XWPFRun class
and it is possible to call methods that will recover the text the run
contains and to set the text it ought to encapsulate. Would it not be
possible to recover the text, use Java's String handling capabilities to
search for and replace text and then re-set the runs text?

Yours

Mark B

Rafael Paiva wrote:
> 
> I assume it's not available. Any plans for having this back on 3.6? Any
> undocumented workaround for 3.5?
> 
>  
> 
> Thanks!
> 
>  
> 
> Rafael.
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Text-Substitution-for-Word-2007-in-POI-3.5-tp26624595p26630321.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: DO NOT REPLY [Bug 48336] New: Error reading date

2009-12-03T17:56:12Z


Can I ask, what does POI think the value in that cell is? I would guess that
it is telling you that the cell holds a numeric value.

You do know that dates are actually stored as numeric values that are then
'converted' into the familair format by the formatting that is applied to
the cell? If you are expecting to see a formatted date value recovered from
the cell then you will need to use something like the DataFormatter class to
convert the numeric value into the form you expect to see.

Yours

Mark B


Bugzilla from bugzilla@apache.org wrote:
> 
> https://issues.apache.org/bugzilla/show_bug.cgi?id=48336
> 
>            Summary: Error reading date
>            Product: POI
>            Version: 3.5-FINAL
>           Platform: Other
>         OS/Version: Linux
>             Status: NEW
>           Severity: critical
>           Priority: P2
>          Component: HSSF
>         AssignedTo: dev@poi.apache.org
>         ReportedBy: vdhanda@epistemic.com
> 
> 
> Created an attachment (id=24665)
>  --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24665)
> Excel file
> 
> The attached Excel has a date value in row 1, column D.  POI doesn't read
> it as
> a date.  The file was created by SoftArtisans OfficeWriter for Excel
> 7.0.0.1642
> (http://officewriter.softartisans.com).
> 
> Thanks.
> 
> -- 
> Configure bugmail:
> https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the assignee for the bug.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-48336--New%3A-Error-reading-date-tp26630117p26630248.html
Sent from the POI - Dev mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] Error reading date

2009-12-03T17:47:10Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

--- Comment #1 from vdhanda@epistemic.com 2009-12-03 09:47:09 UTC ---
Created an attachment (id=24666)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24666)
BiffViewer dump

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] Error reading date

2009-12-03T17:46:19Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

vdhanda@epistemic.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |vdhanda@epistemic.com

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48336] New: Error reading date

2009-12-03T17:46:10Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48336

           Summary: Error reading date
           Product: POI
           Version: 3.5-FINAL
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: critical
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: vdhanda@epistemic.com


Created an attachment (id=24665)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24665)
Excel file

The attached Excel has a date value in row 1, column D.  POI doesn't read it as
a date.  The file was created by SoftArtisans OfficeWriter for Excel 7.0.0.1642
(http://officewriter.softartisans.com).

Thanks.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: a 'lite' version of ooxml-schemas jar

2009-12-03T16:58:04Z

the problem should be fixed in r886733.
At least, Tika trunk compiles OK against poi-ooxml-schemas produced from POI trunk. JUnits
run OK too.

Regards,
Yegor

> Hi,
> 
> On Wed, Dec 2, 2009 at 7:58 PM, Yegor Kozlov  wrote:
>> Can you point me at the place in Tika where getBookmarkStartArray() is used?
> 
> See line 78 of o.a.tika.parser.microsoft.ooxml.XWPFWordExtractorDecorator [1].
> 
> [1] http://svn.apache.org/viewvc/lucene/tika/trunk/tika-parsers/src/main/java/org/apache/tika/parser/microsoft/ooxml/XWPFWordExtractorDecorator.java?revision=820962&view=markup
> 
> BR,
> 
> Jukka Zitting
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48327] cloneSheet() gives an "Error file: data may have been lost" in Excel 2003 or higher if sheet contains commented cells

2009-12-03T10:29:10Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48327

Manuela  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|cloneSheet() gives an       |cloneSheet() gives an
                   |"Error file: data may have  |"Error file: data may have
                   |been lost" in Excel 2003 or |been lost" in Excel 2003 or
                   |higher if sheet commented   |higher if sheet contains
                   |cells                       |commented cells

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48327] cloneSheet() gives an "Error file: data may have been lost" in Excel 2003 or higher if sheet commented cells

2009-12-03T10:28:36Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48327

Manuela  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|cloneSheet() gives an       |cloneSheet() gives an
                   |"Error file: data may have  |"Error file: data may have
                   |been lost" in Excel 2003 or |been lost" in Excel 2003 or
                   |higher                      |higher if sheet commented
                   |                            |cells

--- Comment #1 from Manuela  2009-12-03 02:28:35
UTC ---
I tried to cancel all comments and Excel opens file without pop-up-ing error
message: "Error file: data may have been lost".

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48332] Unable to read Excel file

2009-12-02T21:30:16Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48332

Josh Micich  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #4 from Josh Micich  2009-12-02 13:30:14 UTC ---
Fixed in svn r886311

junits added

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: a 'lite' version of ooxml-schemas jar

2009-12-02T20:35:03Z

Hi,

On Wed, Dec 2, 2009 at 7:58 PM, Yegor Kozlov  wrote:
> Can you point me at the place in Tika where getBookmarkStartArray() is used?

See line 78 of o.a.tika.parser.microsoft.ooxml.XWPFWordExtractorDecorator [1].

[1] http://svn.apache.org/viewvc/lucene/tika/trunk/tika-parsers/src/main/java/org/apache/tika/parser/microsoft/ooxml/XWPFWordExtractorDecorator.java?revision=820962&view=markup

BR,

Jukka Zitting

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48332] Unable to read Excel file

2009-12-02T19:59:37Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48332

vdhanda@epistemic.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #3 from vdhanda@epistemic.com 2009-12-02 11:59:36 UTC ---
Hello Josh,

Yes, if I open and save the file in Excel and/or OpenOffice, the POI can read
it.  

The stack trace from BiffViewer is at the bottom of the BiffViewer output. 
Here's the stack trace from my application.

Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException:
Unable to construct record instance
    at
org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:64)
    at
org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:263)
    at
org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:270)
    at
org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:236)
    at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:377)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:275)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:200)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:182)
    at
com.epistemic.http.ExcelHandler.handleResponseBody(ExcelHandler.java:126)
    at com.aexp.pl.Tester.main(Tester.java:17)
Caused by: java.lang.RuntimeException: Unusual record size remaining=(0)
    at
org.apache.poi.hssf.record.ColumnInfoRecord.(ColumnInfoRecord.java:72)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at
org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:56)
    ... 9 more

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48332] Unable to read Excel file

2009-12-02T19:55:07Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48332

Josh Micich  changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #2 from Josh Micich  2009-12-02 11:55:06 UTC ---
Can you please attach the stack-trace of your error?  Also, can you investigate
whether re-saving the file with Excel allows POI to read it?

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48332] Unable to read Excel file

2009-12-02T19:52:29Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48332

--- Comment #1 from vdhanda@epistemic.com 2009-12-02 11:52:28 UTC ---
Created an attachment (id=24662)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24662)
The Excel

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48332] Unable to read Excel file

2009-12-02T19:51:16Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48332

vdhanda@epistemic.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |vdhanda@epistemic.com

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 48332] New: Unable to read Excel file

2009-12-02T19:50:55Z

https://issues.apache.org/bugzilla/show_bug.cgi?id=48332

           Summary: Unable to read Excel file
           Product: POI
           Version: 3.5-FINAL
          Platform: Other
        OS/Version: Linux
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: vdhanda@epistemic.com


Created an attachment (id=24661)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24661)
BiffViewer output

I have an Excel file that POI is not able to read.  MS Excel and OpenOffice can
read it.  Attached is the BiffViewer output.  The Excel was created by another
process using SoftArtisans OfficeWriter for Excel 7.0.0.1642
(http://officewriter.softartisans.com).

I really need to read this file via POI.  Please help.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: a 'lite' version of ooxml-schemas jar

2009-12-02T18:58:55Z

it for the next POI release.
> 
> The only odd thing about the upgrade was that I needed to comment out
> a piece of Tika extraction code that uses the
> org.openxmlformats.schemas.wordprocessingml.x2006.main.CTBookmark
> class as returned from XWPFParagraph.getCTP().getBookmarkStartArray().
> It looks like that class is not included in the poi-ooxml-schemas jar
> even though the CTP class with the getBookmarkStartArray() method is
> there.
> 

Can you point me at the place in Tika where getBookmarkStartArray() is used?
ooxml-lite only includes classes called during execution of junits. getBookmarkStartArray
is not covered by the tests 
and it explains why the CTBookmark class is missing.

Yegor

> BR,
> 
> Jukka Zitting
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org