Re: Getting "class file has wrong version" error on poi-scratchpad-3.0-rc2 jar

Karr, David wrote: I assume you're only half serious. Dropping 1.4.2 at this point would be a big mistake. Would it though? It's a whole two major versions behind the current release. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh:

Re: Numeric Cell Type not consistent

JUnit, assertEquals for floats and doubles has an error parameter. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipien

Re: Numeric Cell Type not consistent

rs will do this from time to time. The workaround is that if you know you want three decimal places, you can format it to three decimal places instead of using String.valueOf/Double.toString. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2

Re: SVN compilation issues

Daniel Noll wrote: Hi... Looks like the entire org.apache.poi.hslf.model.textproperties package is missing from SVN, causing compilation errors. Could someone fess up and then check in the missing files? Thanks. :-) Okay now it's appeared. So either someone fixed it or there

SVN compilation issues

Hi... Looks like the entire org.apache.poi.hslf.model.textproperties package is missing from SVN, causing compilation errors. Could someone fess up and then check in the missing files? Thanks. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh

Re: Excel text extraction?

eople have wildly differing ideas on what constitutes "text" in an Excel document. For example, my own opinion is that: - String values are text - Numeric and date values are not text - Cell comments are text Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW

Re: POI failed to parse some Microsoft format files

be the same deal, or might not. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the inten

Re: How to use POI (Newbie)

send back a reference to it to the user in response html. What I used to do was I had a magic OutputStream class which wrote the response to the user if the real OutputStream was open, and wrote the response to nowhere if it was closed. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89

Re: Autosizing question:

. I'm sure it *can* be translated to XSL-FO, but I'm not certain that it's the most suited format. (SVG with one page per file may even be better.) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web:

Re: Autosizing question:

files and calculates them. Well, the FOP project has a TTFReader already... maybe it's time for them to push all that into a font-commons package so that POI can depend on it. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699

Re: Writing Word Documents

-- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing

Re: Can POI recognize Chinese or Japanese Characters?

Suresh wrote: Hello, I have a file(.xls) which contains some chinese characters. Can you tell me whether POI can do the transformation on those chinese strings. I can confirm that this works as expected as we have a test case for it in our own unit tests. Daniel -- Daniel Noll Nuix Pty

Re: HSSFCell returns numeric value instead of Strings (for numeric strings)

tring in Excel, you would prefix it with a single quote (') character. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for

Re: Cell comments

Sanjiv Jivan wrote: I'm interested in this as well. Can anyone confirm that this feature does not exist in POI? You can confirm it yourself: http://issues.apache.org/bugzilla/show_bug.cgi?id=10215 Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia

Console chatter

Hi all. Does anyone else find it weird that POI writes so much stuff to System.err and System.out even though there is a POILogger class specifically for logging that kind of stuff? :-/ Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280

RecordFormatException: Records should handle ContinueRecord internally.

extract comment text from the workbook so it needs to work. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipien

Re: Text box in excel spreadsheet... Extracting text possible?

vailable in the TextObjectRecord class. It may or may not have a method which returns the value "TB1" which you are looking for. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/

Re: Text box in excel spreadsheet... Extracting text possible?

ObjectRecord) record; // Do stuff } }, TextObjectRecord.sid); HSSFEventFactory eventFactory = new HSSFEventFactory(); eventFactory.processWorkbookEvents(hssfRequest, fileSystem); But we only extract the text, so I don't actually know if TextObjectRecord contains information on what shee

Re: AW: Reading numeric values as strings from a cell

aniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified

Re: Difference between an "area ref" and a "mem area ref"

n result holder, for whatever reason. Turns out I can completely ignore it and return "" as the formula string and the resulting formula string comes out as expected. Maybe a holdover from when computers were too slow to recompute on load. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79

Re: numeric cell type

nter it as a string. Type '2 instead of 2 into the cell and you'll see what I mean. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is i

Difference between an "area ref" and a "mem area ref"

create a formula which has an intersection of two areas, that uses Ptg 0x26 instead. (However, POI doesn't currently implement 0x26, so it makes the entire document break.) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 92

Unknown grbit '16'

at org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens(Ptg.java:109) at org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:739) at org.apache.poi.hssf.record.Record.(Record.java:55) at org.apache.poi.hssf.record.NameRecord.(NameRecord.java:142) Daniel -- D

Re: Turn off warning in POI

uring out how "big" the Ptg is (PercentPtg was 1, Ref3DPtg is 7, etc), for which you would need to refer to whatever format documentation you can dig up. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: ht

Re: Turn off warning in POI

t see a mention of this in the javadocs for the Ptg class so maybe that was made up. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended only f

Re: Harsh: Turn off warning in POI

cell reference. The third dimension is the multiple sheets. For example, "Sheet1!A5" is a 3D cell reference. So all it means is that a formula on one of your sheets has a reference to another sheet. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Au

Re: Google Spreadsheets

Sean Sullivan wrote: Does anybody know if Google is using the Jakarta POI library to read/write XLS files? Looks like it uses the Java Excel API instead. ( http://jexcelapi.sourceforge.net/ ) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2

Re: protected word doc

= new SummaryInformation(ps); if ((summary.getSecurity() & PASSWORD_PROTECTED_MASK) != 0) { // Is encrypted } } This is trusting the summary properties, and the summary properties might be lying, but it works for us. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones S

Re: protected word doc

e the OutOfMemoryError. The workaround is simple enough: if the document is encrypted, don't try to read in its text. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212

HSLF, weird exception stack trace

ve any idea where this is actually coming from? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not t

Re: any way to get the string representing the visual cell?

o a Java date format (that's the easiest approach, anyway.) Someone asked this exact same question a while back. Odds are they eventually figured out what to do; perhaps they have code? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61

Re: How to insert image in a Excel Sheet

Bina wrote: hi, I cannot insert an image in a excel sheet. Any one there who can help me. Please help me. I assume you've tried HSSFWorkbook#addPicture and there is an error of some sort. Care to elaborate? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW

ArrayIndexOutOfBoundsException when reading a Word document

ption? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified

Re: Problem With Cell Formula

shared formula table, hence these will always break. Retyping the formula over results in a completely new formula, which is why it will work after doing this. The only solution would be adding shared formula support. I'm not even sure where to start on that one... Daniel -- Daniel No

UnsupportedOperationException thrown from formula code (due to percentage in formula)

to change it back, but is there a risk if I revert that code back to the original? I suppose the other alternative is implementing a Ptg class for ID 0x14. This appears to be the formula element used when you have a percentage in a cell formula (e.g. =D4 * 9%). Daniel -- Daniel Noll

Re: getStorageClsid()

a setRoot() method perhaps. Anyway, I've put this in Bugzilla, Bug 39056, with a nice workaround patch. Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/Fax: +61 2 9212 6902

Re: getStorageClsid()

Daniel Noll wrote: I'm fairly certain this is a bug because I've traced the creation of the properties in a debugger, and the root property does have the correct ClassID. At some point in the POIFSFileSystem constructor, it is then throwing away the class ID, but I can't se

getStorageClsid()

me point in the POIFSFileSystem constructor, it is then throwing away the class ID, but I can't see exactly where it's being thrown to. Any ideas? Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, AustraliaPh: +61 2 9280 0699 Web: http://www.nuix.com.au/

Re: hwpf library

d.jar . Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributi

Re: Excel comments

Daniel Noll wrote: Hi all. Is there any way I can use HSSF to get the text of comments which have been attached to a cell? Since nobody answered this one and I investigated it myself, I'll let you all know the answer. The comments end up stored in TextObjectRecord records, which is

Re: HSSF: IndexOutOfBoundsException getting cell formula

able, it wouldn't be particularly useful because the file it links to is gone. Luckily, the values are still present anyway. Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended

HSSF: IndexOutOfBoundsException getting cell formula

at org.apache.poi.hssf.model.FormulaParser.toFormulaString(FormulaParser.java:826) at org.apache.poi.hssf.usermodel.HSSFCell.getCellFormula(HSSFCell.java:621) I can obviously just catch Exception around my call to getCellFormula(), but does anybody else have a better idea of what causes this error? Daniel -- Daniel

HSLF: "Paragraph style ran out before character style did"

So at the moment I think I'm going to leave this commented out, but I'm not sure if that would be the right thing to do in the POI codebase itself. :-) Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 69

Re: PowerPoint comments

odds look pretty good at present.) Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosi

Re: PowerPoint comments

* just normal textboxes. I just tested this case using the HSLF's existing PowerPoint text extractor, and indeed the text of all the comments is already extracted. (Good news for me... one less thing I have to go and write.) Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jon

Re: PowerPoint comments

Daniel Noll wrote: 0a 00 00 00 ? 0a 00 00 00 ? The last two integers seem to be identical on all the comments I tested today (actually, every comment has different values, but the two values were equal to each other) but I've seen them being different on my original test com

Re: PowerPoint comments

Daniel Noll wrote: 00 00 e1 2e 1c 00 00 00Record, type = 12001, length = 28 Next 28 bytes are god-knows what, but I'm thinking the comment date has to be in here somewhere as PowerPoint knows what time the comment was added. 01 00 00 00 d6 07 01 00 02 00 18 00 10 00 0e 00

Re: Reading cells as they are formated by the user in the sheet

work though. I got this far myself and then decided that formatting the values was ultimately more trouble than it was worth, and opted to display everything in a standard format. Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9

Re: PowerPoint comments

far as I can see. Mystery 2: This final block which is at the end of the other comment records: 00 00 eb 2e 08 00 00 00 type = 12011, length = 8 a5 20 c6 01 90 f0 f3 11 Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax

Re: PowerPoint comments

slide at index 3 contains the text of the comments I added, and the record in question has type 5000. Now to figure out how this is laid out... Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This

Excel comments

Hi all. Is there any way I can use HSSF to get the text of comments which have been attached to a cell? Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for the named

Re: PowerPoint comments

belongs to (although I can't instantly see how to figure out which bits are text.) The bad news is when I added a second comment and saved that to create a third document, I couldn't see the text of that second comment anywhere in the diff from the output for a single comment. Danie

Re: PowerPoint comments

Daniel Noll wrote: Hi all. I created a simple PowerPoint document with some comments in it so that I could poke around the API and try to figure out where the comments were stored. I started to think that the class called Notes in the API stored the PowerPoint comments. Okay, I understand

PowerPoint comments

source, it does look like reading the notes has been implemented, so perhaps comments are actually something else. Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for

Re: HSSF POI READING FORMULAS IN AN EXCEL ARCHIVE

ave made life a whole lot easier is a method to get the value of the cell as an Object. And who knows what "General" means... if it's a number format, it certainly isn't clear how it differs from the other number formats. Daniel -- Daniel Noll Nuix Australia Pty Ltd

Re: OutOfMemoryError opening a password-protected Word document

y issues in the past couple of days.) The test .doc file on the bug tracker gives NegativeArraySizeException, which may even be the same issue: creating an array with -5 elements versus creating an array with a billion elements... both fairly likely to happen with scrambled data. Daniel -- Da

OutOfMemoryError opening a password-protected Word document

ng to fail like this. Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, di

Re: Image extraction

try Word today just to get a break from Excel. Is nobody with experience in extracting images from Word and Excel watching the list? :-) Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is inte

Re: Image extraction

Nick Burch wrote: On Fri, 13 Jan 2006, Daniel Noll wrote: Actually, how long do you think it would take? We only really need to get at the binary data for the embedded image files (e.g. source PNGs), being able to render the vector drawings would be a bonus, but not necessarily a requirement

Re: Image extraction

Nick Burch wrote: On Thu, 12 Jan 2006, Daniel Noll wrote: But, is it possible to use the API to extract embedded images from these documents as well? It's not currently possible to extract images from PowerPoint files. It's on the todo list, but I probably won't get around to

Image extraction

e API to extract embedded images from these documents as well? Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 9212 6902 This message is intended only for the named recipient. If you are not the intended recipien

Re: green icon in the cell

ot reliable for that. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking

Re: Change of mailing address

Gaurav, Abhinav wrote: Hi! I want to change my mailing address. Can anybody suggest me the process? Unsubscribe and resubscribe? Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the

Re: Reading only the bit of the file which we need

wonder whether it would have worked on JDK 1.22 anyway. RawDataBlock even has a nice framework which would allow the blocks to be cached. :-) Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for t

Reading only the bit of the file which we need

it would make sense to create a MappedByteBuffer over the whole file and then create windows over that buffer and then glue them back together in the right order... only reading the data when it's finally asked for. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 20

Re: Obtaining the ClassID from a document programmatically

method. I've never seen it return anything else, ever. That's why I thought it was a bug... because it's impossible for me to generate a test case where it doesn't return zero. Either way, it really does look like we'll be keeping the native IStorage code for doing the jo

Re: Obtaining the ClassID from a document programmatically

7;ll check out the new CVS and see what I can find out. Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclo

Re: Obtaining the ClassID from a document programmatically

get it, it's just not giving it to me. That is, unless there is some kind of initialisation I need to do to get it to populate? Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the named rec

Obtaining the ClassID from a document programmatically

mple way to read the storage class ID. I've also looked into DirectoryNode.getStorageClsid(), but that always returns the same, uninitialised ClassID. Any ideas? I'm probably missing something really obvious... Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Ph

Re: Patch: Dictionary should be read in the codepage of the section it's in.

Rainer Klute wrote: Am Donnerstag, den 31.03.2005, 10:37 +1000 schrieb Daniel Noll: Danny Mui wrote: Can you attach it to a bug with a prefix of [PATCH]? Easier to track down changes down the road. http://issues.apache.org/bugzilla/enter_bug.cgi?product=POI Done: http

Re: Patch: Dictionary should be read in the codepage of the section it's in.

Danny Mui wrote: Can you attach it to a bug with a prefix of [PATCH]? Easier to track down changes down the road. http://issues.apache.org/bugzilla/enter_bug.cgi?product=POI Done: http://issues.apache.org/bugzilla/show_bug.cgi?id=34247 Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street

Patch: Dictionary should be read in the codepage of the section it's in.

Daniel Noll wrote: I'll submit a patch in a few minutes if I can clean up my codesufficiently, but it won't be a clean patch so you'll probably have to rearrange it a little. :-/ Patch attached as promised / threatened. ;-) To compare before and after, you might want to c

Re: Most recent release? (Codepage support in HPSF)

in a few minutes if I can clean up my codesufficiently, but it won't be a clean patch so you'll probably have to rearrange it a little. :-/ Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only f

Most recent release? (Codepage support in HPSF)

ay 2003 instead of 2004? Either way I need this codepage support (at least for UTF-8), so how stable would people say the current CVS is? Daniel -- Daniel Noll NUIX Pty Ltd Level 8, 143 York Street, Sydney 2000 Phone: (02) 9283 9010 Fax: (02) 9283 9020 This message is intended only for the name