headers
bugzilla | 18 May 21:04
Picon
Favicon

[Bug 53264] New: unable to create record instance..Not enough data (0) to read requested (6) bytes

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

          Priority: P2
            Bug ID: 53264
          Assignee: dev <at> poi.apache.org
           Summary: unable to create record instance..Not enough data (0)
                    to read requested (6) bytes
          Severity: major
    Classification: Unclassified
                OS: Windows XP
          Reporter: csekhar406 <at> gmail.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: HSSF
           Product: POI

I am using Poi latest final 3.8 version to fix this issue.but still i am
getting the fallowing exception.

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)
(Continue reading)

Permalink | Reply | 0 comments |
headers
bugzilla | 18 May 15:50
Picon
Favicon

[Bug 53262] New: XSSFCellStyle.getFillForegroundXSSFColor returs null if theme color is set as Accent color in the Styles panel

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

          Priority: P2
            Bug ID: 53262
          Assignee: dev <at> poi.apache.org
           Summary: XSSFCellStyle.getFillForegroundXSSFColor returs null
                    if theme color is set as Accent color in the Styles
                    panel
          Severity: normal
    Classification: Unclassified
          Reporter: andrei.astrouski <at> gmail.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: XSSF
           Product: POI

If bg color is set in the Style panel, xml node (in styles.xml) <cellXfs> ->
<xf> doesn't have 'applyFill' attribute, and getFillForegroundXSSFColor method
checks this parameter. As a result method returns null.

--

-- 
You are receiving this mail because:
You are the assignee for the bug.
Permalink | Reply | 1 comment |
headers
bugzilla | 17 May 22:20
Picon
Favicon

[Bug 53255] New: Row Grouping Code Which Works in XSSF Produces Invalid Excel in SXSSF

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

          Priority: P2
            Bug ID: 53255
          Assignee: dev <at> poi.apache.org
           Summary: Row Grouping Code Which Works in XSSF Produces Invalid
                    Excel in SXSSF
          Severity: critical
    Classification: Unclassified
          Reporter: gjungman <at> utilinc.com
          Hardware: PC
            Status: NEW
           Version: 3.8-dev
         Component: SXSSF
           Product: POI

Hello,

I have code that groups and collapses rows as shown below:

       sheet.groupRow(startGroup, endGroup);
       sheet.setRowGroupCollapsed(startGroup, true);

It works fine in XSSF, but if I change to SXSSF it produces an Excel workbook
that Excel claims is corrupt.

Very large workbooks is when both of these feature are most useful.

Thanks!
(Continue reading)

Permalink | Reply | 1 comment |
headers
bugzilla | 17 May 01:50
Picon
Favicon

[Bug 53250] New: Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

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

          Priority: P2
            Bug ID: 53250
          Assignee: dev <at> poi.apache.org
           Summary: Blocked when instantiate of XSSFExcelExtractor or
                    XSSFWorkbook
          Severity: critical
    Classification: Unclassified
          Reporter: toplinuxer <at> gmail.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: XSSF
           Product: POI

Hi~

when I instantiate XSSFWorkbook or XSSFExcelExtractor for getText().

New instantiate about them is blocked with attached XSLX file.

I write code like below

#
# case 1
#
OPCPackage pkg = OPCPackage.open(fileName);

// blocked below code, no exception.. no response..
(Continue reading)

Permalink | Reply | 5 comments |
headers
bugzilla | 16 May 17:43
Picon
Favicon

[Bug 53243] New: Extract Tables from word document

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

          Priority: P2
            Bug ID: 53243
          Assignee: dev <at> poi.apache.org
           Summary: Extract Tables from word document
          Severity: normal
    Classification: Unclassified
                OS: Windows XP
          Reporter: ayah683 <at> gmail.com
          Hardware: PC
            Status: NEW
           Version: unspecified
         Component: HWPF
           Product: POI

Created attachment 28793
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=28793&action=edit
word document file

i used POI 3.8 to extract tables from word document
but i can't get all tables in Doc
i write this code to get this action

    public static void main(String[] args) {
        String fileName = "C:\\fjn3312r.doc";
        try {
            InputStream fis = new FileInputStream(fileName);
            POIFSFileSystem fs = new POIFSFileSystem(fis);
            HWPFDocument doc = new HWPFDocument(fs);
(Continue reading)

Permalink | Reply | 0 comments |
headers
abc | 16 May 05:47
Picon

How to Convert MS PowerPoint 2003/2007 into HTML using APACHE POI or Else?

I need to convert PowerPoint 2003/2007(ppt/pptx) to HTML. But I have not
found any code how to do this. So, how to Convert MS PowerPoint
2003/2007(ppt/pptx) into HTML using APACHE POI or Else? I have found Apache
POI. But don't know what code can do the trick

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-Convert-MS-PowerPoint-2003-2007-into-HTML-using-APACHE-POI-or-Else-tp5709774.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Permalink | Reply | 4 comments |
headers
bugzilla | 14 May 10:10
Picon
Favicon

[Bug 53227] New: Scaled image not visible in SXSSFWorkbook

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

          Priority: P2
            Bug ID: 53227
          Assignee: dev <at> poi.apache.org
           Summary: Scaled image not visible in SXSSFWorkbook
          Severity: major
    Classification: Unclassified
          Reporter: edwin.roth <at> unycom.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: SXSSF
           Product: POI

Created attachment 28774
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=28774&action=edit
not working XSL

After replacing org.apache.poi.hssf.usermodel.HSSFWorkbook by its streaming
equivalent org.apache.poi.xssf.streaming.SXSSFWorkbook in 
the AddDimensionedImage.java sample:

package org.apache.poi.ss.examples;
public class AddDimensionedImage {
    public static void main(String[] args) {
        Workbook workbook = null;
        //...
            //workbook = new HSSFWorkbook();
            workbook=new SXSSFWorkbook(100);
(Continue reading)

Permalink | Reply | 10 comments |
headers
Alex Vb | 11 May 11:36
Picon

RuntimeException when external excel not found

When evaluating a formula in a cell, I got a runtime exception with the
following (partial) stacktrace:

    at
org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:89)
    at
org.apache.poi.ss.formula.OperationEvaluationContext.getRef3DEval(OperationEvaluationContext.java:249)
    at
org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:607)
    at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:493)
    at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287)
    at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:229)
    at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:354)
    at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:185)

It seems the class org.apache.poi.ss.formula.OperationEvaluationContext
throws a runtime exception if an external workbook is not found. Is there a
reason for this design decision?

I would suggest:
- a formula error (e.g. "#REF")
- or a checked exception
- or if all else fails, an unchecked exception but a subtype so we don't
have to catch RuntimeException and a mention of this behavior in the
javadocs because until it occurred I had no idea this behavior was expected
(Continue reading)

Permalink | Reply | 0 comments |
headers
bugzilla | 9 May 21:32
Picon
Favicon

[Bug 53209] New: Too many styles corrupts the excel

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

          Priority: P2
            Bug ID: 53209
          Assignee: dev <at> poi.apache.org
           Summary: Too many styles corrupts the excel
          Severity: normal
    Classification: Unclassified
          Reporter: awm <at> mbcli.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: XSSF
           Product: POI

Having a 3250 rows x 10 cells for each row seem to be the limit the number of
styles.

3500 x 10 breaks the excel file. 

Attached is a set of files/code to replicate the issue.

--

-- 
You are receiving this mail because:
You are the assignee for the bug.
Permalink | Reply | 4 comments |
headers
Christian | 9 May 18:47
Picon
Favicon

Problems with WorkbookEvaluator.registerFunction() using German names of Excel functions

Hi all,

I receive problems when registering a not supported Excel function, in 
this case EDATE (or, in German, EDATUM).

(1) When I register this function with the name "EDATE", it won't work:

WorkbookEvaluator.registerFunction("EDATE", new EDate());

I receive the following error messages:

Exception in thread "main" 
org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating 
cell Tabelle1!B2
     at 
org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:356)
     at 
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:297)
     at 
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:229)
     at 
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:354)
     at 
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:185)
     at 
com.xls.UserDefinedFunctionExample.main(UserDefinedFunctionExample.java:55)
Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: EDATUM
     at 
org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:59)
     at
(Continue reading)

Permalink | Reply | 1 comment |
headers
bugzilla | 9 May 11:55
Picon
Favicon

[Bug 53207] New: A formula can not clear by [setCellFormula(null)]=?UTF-8?Q?=20in=20Shared=E3=80=80formulas?=.

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

          Priority: P2
            Bug ID: 53207
          Assignee: dev <at> poi.apache.org
           Summary: A formula can not clear by [setCellFormula(null)] in
                    Shared　formulas.
          Severity: normal
    Classification: Unclassified
                OS: Windows Vista
          Reporter: ishii <at> infoteria.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: XSSF
           Product: POI

Created attachment 28749
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=28749&action=edit
files for test input

[attachment : files.zip]
ok.xlsx : D1-D12 has formula
ng.xlsx : D1-D12 has shared formula

A result file[result_ng.xlsx] has break formula.
Open and Rescue by Excel, cells[D11-D12] formula is gone.

The setCellFormula method can not clear formula like this.
(*Exclude the case where only D1 is cleared.)
(Continue reading)

Permalink | Reply | 0 comments |

Gmane