DO NOT REPLY [Bug 42256] unkown grbit '16' error while reading excel file.
https://issues.apache.org/bugzilla/show_bug.cgi?id=42256 Marco [EMAIL PROTECTED] changed: What|Removed |Added CC||[EMAIL PROTECTED] --- Comment #2 from Marco [EMAIL PROTECTED] 2008-03-27 02:34:34 PST --- I have the same problem on Windows XP and Linux (Ubuntu). Poi version: poi-3.0.2-FINAL-20080204.jar Exception in thread main org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:199) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:117) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:207) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:148) at it.ingeniumtech.test.excel.Poi.main(Poi.java:25) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:187) ... 4 more Caused by: org.apache.poi.hssf.record.RecordFormatException: Unknown grbit '16' at org.apache.poi.hssf.record.formula.ArrayPtg.readTokenValues(ArrayPtg.java:99) at org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens(Ptg.java:110) at org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:778) at org.apache.poi.hssf.record.Record.init(Record.java:55) at org.apache.poi.hssf.record.NameRecord.init(NameRecord.java:139) ... 8 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44674] org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=44674 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution||WORKSFORME --- Comment #3 from Nick Burch [EMAIL PROTECTED] 2008-03-27 03:54:33 PST --- Those messages indicate your FileSharingRecords aren't quite what POI was expecting, but can be worked around If they bug you, tell POILogFactory to use the NullLogger for that class, and they'll go away -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] New: Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 Summary: Insertion of multiple comments Product: POI Version: 3.0 Platform: PC OS/Version: Windows XP Status: NEW Severity: major Priority: P1 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: [EMAIL PROTECTED] I am using the 3.0.1-FINAL version of POI. I was not successful in adding comments to more than one cell in a loop. I couldn't figure out what is happening to the comment objects I am creating using the command HSSFPatriarch.createComment() function. Please look at the code I am using bellow: Scenario1: Created a comment object, added it to the cell in a for loop -- expected result, all the cells in the excel sheet should have the same comment. == Result I am getting: Only the top most cell of the excel sheet is having the comment. The cell is choosen arbritrarliy at times. Scenario2: Created a comment object, added it to the cell. Created another comment object (but not added to any cell) in a for loop -- expected result: all the cells in the excel sheet should have the first comment == Result I am getting: One cell has the first comment and another has the second comment (please note, I've never added the second comment to any of the cells). The selection of the cells is arbitrary at times. My actual requirement is to add comments to selected cells. Your help in this regard is highly appreciated. Code I've used for adding comments : HSSFPatriarch patr = finalSheet.createDrawingPatriarch(); HSSFCell cell1 = finalSheet.createRow(4).createCell((short)1); HSSFCell cell = finalSheet.createRow(5).createCell((short)1); HSSFComment comment1 = patr.createComment(new HSSFClientAnchor(0, 100, 0, 0, (short)4, 2, (short) 6, 5)); comment1.setString(new HSSFRichTextString(help me)); comment1.setAuthor(SUMIT); newCell.setCellComment(comment1); cell.setCellComment(comment1); cell1.setCellComment(comment1); -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 SUMIT [EMAIL PROTECTED] changed: What|Removed |Added CC||[EMAIL PROTECTED] -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 SUMIT [EMAIL PROTECTED] changed: What|Removed |Added Priority|P1 |P2 -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Rejection of any ENCUMBERED Microsoft Donation to POI
On Thu, 27 Mar 2008, Andrew C. Oliver wrote: No. If sourcesense is doing this as work for hire then the work is probably owned by Microsoft. I'm pretty sure the deal was structured so as not to be work for hire, for reasons just like this (amongst others). I'll let Gianugo confirm that though, as I only know that sort of thing second hand! In terms of the various checks that have been done: * Sourcesense have a CCLA on file * All the Sourcesense employees working on poi have a ICLA on file * Sourcesense have stated that they have no secret microsoft information / documentation, and are only working off the publically released specs. * Sourcesense have stated that they own all the rights to their contributions, and so are in a position to be able to cleanly contribute it all to apache * The apache legal team have ok'd the use of the schemas that come with the ooxml specification (I didn't explicitly ask about the specs themselves, but they're under the same license) Patent wise, I don't think the ooxml stuff is any different from the binary stuff - I think we're in the same boat for both. The binary file format docs were recently released under exactly the same terms as the ooxml stuff is. Gianugo - are you happy to make a public statement about the work not being work-for-hire for microsoft, and the fact that you haven't got any documentation other than the public stuff? Hopefully that'll clarify things for everyone. Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44680] autoSizeColumn dislike HSSFFont
https://issues.apache.org/bugzilla/show_bug.cgi?id=44680 --- Comment #2 from Thomas Lecavelier [EMAIL PROTECTED] 2008-03-27 04:42:44 PST --- Just to precise: autoSizeColumn works perfectly when no Style is applied to a cell scanned by the autoSizeColumn. There's no problem to apply a font *after* the autoSizeColum. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44687] Unable to Index a Visio Document.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44687 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |RESOLVED Resolution||DUPLICATE --- Comment #1 from Nick Burch [EMAIL PROTECTED] 2008-03-27 04:58:54 PST --- *** This bug has been marked as a duplicate of bug 44501 *** -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44501] ArrayIndexOutOfBoundsException when extracting text from Visio Files on Linux .
https://issues.apache.org/bugzilla/show_bug.cgi?id=44501 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added CC||[EMAIL PROTECTED] --- Comment #11 from Nick Burch [EMAIL PROTECTED] 2008-03-27 04:58:54 PST --- *** Bug 44687 has been marked as a duplicate of this bug. *** -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:02:44 PST --- I have a feeling that a comment can only be added to one cell If you create+attach one comment per cell, does it all work? -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 --- Comment #2 from SUMIT [EMAIL PROTECTED] 2008-03-27 05:14:43 PST --- --- Comment #1 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:02:44 PST --- I have a feeling that a comment can only be added to one cell If you create+attach one comment per cell, does it all work? ---Sumit i have tried this too. i am creating the object of HSSFComment and HSSFCell in a loop and try to set that new object of comment in the cell and that too in a loop expected result--comment in all the cells result--only one comment comes and that too in arbitary cell -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Insertion of multiple comments
I tried creating object of HSSFCell and HSSFComment object in a loop and try to set that new object of comment in new cell. i.e. i m always creating a new object of comment for each cell but that doest not even work. Thanks Regards Sumit Jain LT Infotech,India Mobile: +91-9920911884 Ext: 6052 Email: [EMAIL PROTECTED] https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:02:44 PST --- I have a feeling that a comment can only be added to one cell If you create+attach one comment per cell, does it all work? -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ __ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 SUMIT [EMAIL PROTECTED] changed: What|Removed |Added Status|NEEDINFO|ASSIGNED --- Comment #3 from SUMIT [EMAIL PROTECTED] 2008-03-27 05:28:09 PST --- I tried creating object of HSSFCell and HSSFComment object in a loop andtry to set that new object of comment in new cell. i.e. i m always creating a new object of comment for each cell but thatdoest not even work. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 42564] org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
https://issues.apache.org/bugzilla/show_bug.cgi?id=42564 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added CC||[EMAIL PROTECTED] --- Comment #12 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:37:12 PST --- *** Bug 42256 has been marked as a duplicate of this bug. *** -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 42256] unkown grbit '16' error while reading excel file.
https://issues.apache.org/bugzilla/show_bug.cgi?id=42256 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |RESOLVED Resolution||DUPLICATE --- Comment #3 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:37:12 PST --- *** This bug has been marked as a duplicate of bug 42564 *** -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44652] [PATCH] Patch for Better handling of Pictures ( Fixes Bug #44603)
https://issues.apache.org/bugzilla/show_bug.cgi?id=44652 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #2 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:47:13 PST --- Thanks for this patch Raghu, applied to svn trunk -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44688] Insertion of multiple comments
https://issues.apache.org/bugzilla/show_bug.cgi?id=44688 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|ASSIGNED|NEEDINFO --- Comment #4 from Nick Burch [EMAIL PROTECTED] 2008-03-27 05:50:15 PST --- If you add comments with poi, save and re-load into poi, do they appear on the correct cells then? If not, could you please knock up a quick unit test for the problem? Just something that creates a new workbook and sheet, and adds a few cells, attaches comments to those. Write a to ByteArrayOutputStream, read in again from a ByteArrayInputStream, and assert that the comments are on the right cells (this bit will fail) We'll then have something to test future fixes against -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44691] New: Error accessing formula values
https://issues.apache.org/bugzilla/show_bug.cgi?id=44691
Summary: Error accessing formula values
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=21721)
-- (https://issues.apache.org/bugzilla/attachment.cgi?id=21721)
The workbook.xls file is generated by the Java code referenced. The PMT
calculation works correctly in the workbook.
Per Nick Burch's request, I am including the Java code and generated
workbook.xls file that I referenced in a posting to the mailing list.
Following is the text from the original posting I sent:
Hi, I am new to this list and am new to POI HSSF. I am trying to find a way to
programatically invoke the PMT formula and access the resulting value. The
code below generates an Excel spreasheet file successfully and even stores the
correct value in the A1 cell when I manually open it. However, when I use the
HSSFFormulaEvaluator to access the value that the formula computes, I keep
getting a CELL_TYPE_ERROR.
package test.poi;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellReference;
public class BuildDynamicPmtWorkbook {
public void buildDynamicPmtWorkbook() {
HSSFWorkbook outWorkbook = new HSSFWorkbook();
HSSFSheet outPMTSheet = outWorkbook.createSheet(PMT Sheet);
HSSFRow row = outPMTSheet.createRow((short) 0);
HSSFCell cell = row.createCell((short) 0);
cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula(PMT(0.09/12,48,-1));
FileOutputStream fileOutputStream = null;
try {
fileOutputStream = new
FileOutputStream(workbook.xls);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
outWorkbook.write(fileOutputStream);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
fileOutputStream.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
InputStream inputStream = null;
try {
inputStream = new FileInputStream(workbook.xls);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
HSSFWorkbook inWorkbook = null;
try {
inWorkbook = new HSSFWorkbook(inputStream);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
HSSFSheet inPMTSheet = inWorkbook.getSheet(PMT Sheet);
HSSFFormulaEvaluator evaluator = new
HSSFFormulaEvaluator(inPMTSheet, inWorkbook);
CellReference cellReference = new CellReference(A1);
HSSFRow inRow = inPMTSheet.getRow(cellReference.getRow());
HSSFCell inCell = inRow.getCell(cellReference.getCol());
System.out.println(inCell type before evaluation: +
inCell.getCellType());
evaluator.setCurrentRow(inRow);
HSSFFormulaEvaluator.CellValue inCellValue =
evaluator.evaluate(inCell);
switch (inCellValue.getCellType()) {
case HSSFCell.CELL_TYPE_BOOLEAN:
System.out.println(inCellValue.getBooleanValue());
break;
case HSSFCell.CELL_TYPE_NUMERIC:
System.out.println(inCellValue.getNumberValue());
break;
case HSSFCell.CELL_TYPE_STRING:
System.out.println(inCellValue.getStringValue());
break;
case HSSFCell.CELL_TYPE_BLANK:
System.out.println(CELL_TYPE_BLANK);
break;
case HSSFCell.CELL_TYPE_ERROR:
System.out.println(CELL_TYPE_ERROR!!!);
Re: Rejection of any ENCUMBERED Microsoft Donation to POI
On Mar 27, 2008, at 12:40 PM, Nick Burch wrote: On Thu, 27 Mar 2008, Andrew C. Oliver wrote: No. If sourcesense is doing this as work for hire then the work is probably owned by Microsoft. I'm pretty sure the deal was structured so as not to be work for hire, for reasons just like this (amongst others). I'll let Gianugo confirm that though, as I only know that sort of thing second hand! In terms of the various checks that have been done: [...] Thanks you Nick! Gianugo - are you happy to make a public statement about the work not being work-for-hire for microsoft, and the fact that you haven't got any documentation other than the public stuff? Hopefully that'll clarify things for everyone. Indeed. I can confirm both statements are true. Would that be enough? -- Gianugo Rabellino Sourcesense - making sense of Open Source: http://www.sourcesense.com Blogging at http://boldlyopen.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 27153] Graphics resized when altering column widths
https://issues.apache.org/bugzilla/show_bug.cgi?id=27153 --- Comment #9 from Yegor Kozlov [EMAIL PROTECTED] 2008-03-27 09:34:32 PST --- Thanks for reminding. I opened a new bug. 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44680] autoSizeColumn dislike HSSFFont
https://issues.apache.org/bugzilla/show_bug.cgi?id=44680 --- Comment #3 from Yegor Kozlov [EMAIL PROTECTED] 2008-03-27 09:47:38 PST --- Can you post a fully working example? It would me much easier for me to diagnose the problem. I can't reproduce the problem from the supplied pieces of code. Regards, 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44693] New: HSSFSheet.rowIterator() return more rows than sheet has
https://issues.apache.org/bugzilla/show_bug.cgi?id=44693 Summary: HSSFSheet.rowIterator() return more rows than sheet has Product: POI Version: unspecified Platform: PC OS/Version: Windows XP Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: [EMAIL PROTECTED] Created an attachment (id=21722) -- (https://issues.apache.org/bugzilla/attachment.cgi?id=21722) Excel to make the error HSSFSheet.rowIterator() returns more rows than the sheet has. In the attached book, you can see 713 rows with information, but the iterator stops in the 1411 row. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44691] Error accessing formula values
https://issues.apache.org/bugzilla/show_bug.cgi?id=44691 Nick Burch [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |ASSIGNED --- Comment #1 from Nick Burch [EMAIL PROTECTED] 2008-03-27 11:23:29 PST --- Thanks for the code, I've created a failing test in svn Not sure why we're getting an error back, but at least we have something to test against. Maybe Josh might be able to enlighten us... :) -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44694] New: Unable to retrieve SummaryInformation from some Office docs; NoPropertySetStreamException thrown
https://issues.apache.org/bugzilla/show_bug.cgi?id=44694
Summary: Unable to retrieve SummaryInformation from some Office
docs; NoPropertySetStreamException thrown
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P2
Component: HPFS
AssignedTo: dev@poi.apache.org
ReportedBy: [EMAIL PROTECTED]
I get this on some Office docs, a specific PPT doc to reproduce this is
attached.
What I do is this:
POIFSFileSystem filesystem = new POIFSFileSystem(fis);
SummaryInformation si = (SummaryInformation) getPropertySet(filesystem,
SummaryInformation.DEFAULT_STREAM_NAME, sourcePath);
where getPropertySet does this:
public static PropertySet getPropertySet(POIFSFileSystem filesystem, String
setName, String filepath) throws IOException {
DocumentInputStream dis = filesystem.createDocumentInputStream(setName);
return PropertySetFactory.create(dis);
This causes the following exception:
org.apache.poi.hpsf.NoPropertySetStreamException
at org.apache.poi.hpsf.PropertySet.init(PropertySet.java:252)
at
org.apache.poi.hpsf.PropertySetFactory.create(PropertySetFactory.java:61)
The file doesn't appear corrupt as it opens in PPT just fine. Also, I dumped
out the directory nodes and I see that summary info is in fact there.
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44695] New: HSSF: Formulas are broken after re-save
https://issues.apache.org/bugzilla/show_bug.cgi?id=44695 Summary: HSSF: Formulas are broken after re-save Product: POI Version: unspecified Platform: PC OS/Version: All Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: [EMAIL PROTECTED] Actually there are two problems: (1) In some cases formulas are broken after save. (2) POI can't read the saved file with the broken formulas. I'm getting the following exception: Exception in thread main org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:204) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:122) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:204) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:256) at org.apache.poi.hssf.usermodel.HSSFWorkbook.init(HSSFWorkbook.java:237) at org.apache.poi.hssf.scratchpad.Scratchpad.main(Scratchpad.java:44) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.intellij.rt.execution.application.AppMain.main(Unknown Source) Caused by: java.lang.reflect.InvocationTargetException 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:494) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:192) ... 10 more Caused by: java.lang.IllegalArgumentException: Illegal length 17478 at org.apache.poi.hssf.record.RecordInputStream.readCompressedUnicode(RecordInputStream.java:270) at org.apache.poi.hssf.record.ExternalNameRecord.fillFields(ExternalNameRecord.java:162) at org.apache.poi.hssf.record.Record.init(Record.java:55) at org.apache.poi.hssf.record.ExternalNameRecord.init(ExternalNameRecord.java:54) ... 15 more This bug has appeared recently. The attached unit test passes with POI 3.0.2 but fails with trunk. I attached a failing unit test and two files: formulas.xlsinitial file with a formula in A1 formulas-saved.xls saved by POI. The formula in A1 is broken It seems to be related to bug #44504. Josh, any ideas? Regards, 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44695] HSSF: Formulas are broken after re-save
https://issues.apache.org/bugzilla/show_bug.cgi?id=44695 --- Comment #1 from Yegor Kozlov [EMAIL PROTECTED] 2008-03-27 11:31:25 PST --- Created an attachment (id=21723) -- (https://issues.apache.org/bugzilla/attachment.cgi?id=21723) initial file -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44695] HSSF: Formulas are broken after re-save
https://issues.apache.org/bugzilla/show_bug.cgi?id=44695 --- Comment #2 from Yegor Kozlov [EMAIL PROTECTED] 2008-03-27 11:32:06 PST --- Created an attachment (id=21724) -- (https://issues.apache.org/bugzilla/attachment.cgi?id=21724) saved by POI -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44695] HSSF: Formulas are broken after re-save
https://issues.apache.org/bugzilla/show_bug.cgi?id=44695 --- Comment #3 from Yegor Kozlov [EMAIL PROTECTED] 2008-03-27 11:33:39 PST --- Created an attachment (id=21725) -- (https://issues.apache.org/bugzilla/attachment.cgi?id=21725) failing test -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Rejection of any ENCUMBERED Microsoft Donation to POI
That would be acceptable so long as it is true. I'd like to NOT read any more RAND/noncomm terms in the press associated with POI. -Andy Nick Burch wrote: On Thu, 27 Mar 2008, Andrew C. Oliver wrote: No. If sourcesense is doing this as work for hire then the work is probably owned by Microsoft. I'm pretty sure the deal was structured so as not to be work for hire, for reasons just like this (amongst others). I'll let Gianugo confirm that though, as I only know that sort of thing second hand! In terms of the various checks that have been done: * Sourcesense have a CCLA on file * All the Sourcesense employees working on poi have a ICLA on file * Sourcesense have stated that they have no secret microsoft information / documentation, and are only working off the publically released specs. * Sourcesense have stated that they own all the rights to their contributions, and so are in a position to be able to cleanly contribute it all to apache * The apache legal team have ok'd the use of the schemas that come with the ooxml specification (I didn't explicitly ask about the specs themselves, but they're under the same license) Patent wise, I don't think the ooxml stuff is any different from the binary stuff - I think we're in the same boat for both. The binary file format docs were recently released under exactly the same terms as the ooxml stuff is. Gianugo - are you happy to make a public statement about the work not being work-for-hire for microsoft, and the fact that you haven't got any documentation other than the public stuff? Hopefully that'll clarify things for everyone. Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Buni Meldware Communication Suite http://buni.org Multi-platform and extensible Email, Calendaring (including freebusy), Rich Webmail, Web-calendaring, ease of installation/administration. smime.p7s Description: S/MIME Cryptographic Signature
Re: Rejection of any ENCUMBERED Microsoft Donation to POI
On Mar 27, 2008, at 10:36 PM, Andrew C. Oliver wrote: That would be acceptable so long as it is true. Please help a non-native English speaker in not taking offense at this. Ciao, -- Gianugo Rabellino Sourcesense - making sense of Open Source: http://www.sourcesense.com Blogging at http://boldlyopen.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 44691] Error accessing formula values
https://issues.apache.org/bugzilla/show_bug.cgi?id=44691 --- Comment #3 from Josh Micich [EMAIL PROTECTED] 2008-03-27 15:21:41 PST --- (In reply to comment #2) fixed in svn r641964 oops - that message was for bug 44695. This bug was just fixed in svn r641996. According to Excel help doc, PMT() takes between 3 and 5 args, POI was only allowing 4-5. I deleted TestBug44691.java (after making sure it works) because the bug turned out to be localized to Pmt.java. A new test TestPmt.java was added to confirm this bug-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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]: Project poi (in module poi) failed
To whom it may engage... This is an automated request, but not an unsolicited one. For more information please visit http://gump.apache.org/nagged.html, and/or contact the folk at [EMAIL PROTECTED] Project poi has an issue affecting its community integration. This issue affects 1 projects. The current state of this project is 'Failed', with reason 'Build Failed'. For reference only, the following projects are affected by this: - poi : POI Full details are available at: http://vmgump.apache.org/gump/public/poi/poi/index.html That said, some information snippets are provided here. The following annotations (debug/informational/warning/error messages) were provided: -DEBUG- Output [poi-contrib-gump-27032008.jar] identifier set to output basename: [poi-contrib-gump] -DEBUG- Output [poi-scratchpad-gump-27032008.jar] identifier set to output basename: [poi-scratchpad-gump] -DEBUG- Output [poi-gump-27032008.jar] identifier set to output basename: [poi-gump] -INFO- Failed with reason build failed -DEBUG- Extracted fallback artifacts from Gump Repository The following work was performed: http://vmgump.apache.org/gump/public/poi/poi/gump_work/build_poi_poi.html Work Name: build_poi_poi (Type: Build) Work ended in a state of : Failed Elapsed: 3 secs Command Line: /usr/lib/jvm/java-1.5.0-sun/bin/java -Djava.awt.headless=true -Xbootclasspath/p:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis.jar:/srv/gump/public/workspace/xml-xerces2/build/xercesImpl.jar:/srv/gump/public/workspace/xml-xalan/build/serializer.jar:/srv/gump/public/workspace/xml-xalan/build/xalan-unbundled.jar org.apache.tools.ant.Main -Dgump.merge=/srv/gump/public/gump/work/merge.xml -Dbuild.sysclasspath=only -Dversion.id=gump -DDSTAMP=27032008 -f build.xml gump [Working Directory: /srv/gump/public/workspace/poi] CLASSPATH: /usr/lib/jvm/java-1.5.0-sun/lib/tools.jar:/srv/gump/public/workspace/poi/build/classes:/srv/gump/public/workspace/poi/build/contrib-classes:/srv/gump/public/workspace/poi/build/scratchpad-classes:/srv/gump/public/workspace/poi/build/test-classes:/srv/gump/public/workspace/poi/build/scratchpad-test-classes:/srv/gump/public/workspace/ant/dist/lib/ant-jmf.jar:/srv/gump/public/workspace/ant/dist/lib/ant-swing.jar:/srv/gump/public/workspace/ant/dist/lib/ant-apache-resolver.jar:/srv/gump/public/workspace/ant/dist/lib/ant-trax.jar:/srv/gump/public/workspace/ant/dist/lib/ant-junit.jar:/srv/gump/public/workspace/ant/dist/lib/ant-launcher.jar:/srv/gump/public/workspace/ant/dist/lib/ant-nodeps.jar:/srv/gump/public/workspace/ant/dist/lib/ant.jar:/srv/gump/public/workspace/logging-log4j-12/dist/lib/log4j-27032008.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-27032008.jar:/srv/gump/public/workspace/apache-commons/logging/target/commons-logging-api- 27032008.jar:/srv/gump/public/workspace/apache-commons/beanutils/dist/commons-beanutils-27032008.jar:/srv/gump/public/workspace/apache-commons/collections/build/commons-collections-27032008.jar:/srv/gump/public/workspace/apache-commons/lang/commons-lang-27032008.jar:/srv/gump/public/workspace/junit/dist/junit-27032008.jar:/srv/gump/public/workspace/xml-commons/java/external/build/xml-apis-ext.jar - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at sun.net.www.protocol.http.HttpURLConnection$6.run(HttpURLConnection.java:1227) at java.security.AccessController.doPrivileged(Native Method) at sun.net.www.protocol.http.HttpURLConnection.getChainedException(HttpURLConnection.java:1221) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:910) at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:367) at org.apache.tools.ant.taskdefs.Get.doGet(Get.java:151) at org.apache.tools.ant.taskdefs.Get.execute(Get.java:78) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:354) at org.apache.tools.ant.Target.performTasks(Target.java:379) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1324) at org.apache.tools.ant.Project.executeTarget(Project.java:1293) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1176) at
