DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Additional Comments From [EMAIL PROTECTED] 2003-07-24 13:18 --- no response - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-12-25 17:59 --- Is it fixed? can i close this bug? Thomas? -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-12-12 12:12 --- Try this with a recent nightly build. I think its fixed. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-30 07:24 --- thanks you for your patience and insights, I've narrowed it down to one line now, in the 1.5.1 class: UnicodeString in the function: fillFields the line: field_3_string = new String(data, 3, getCharCount()); makes a new String regardless of the ISO character set standard, and since I use ISO-8859-1 it doesn't work. Adding: field_3_string = new String(data, 3, getCharCount(), ISO-8859-1); makes it work though, guess I'll have to make a few tests now, to see if anything else is messed up. Thanks again, Thomas -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-29 07:45 --- Just a quick comment: Thank you very much for your help, I know I've been annoying, but being an end user, I feel it is my duty. I appreciate how Andy carefully and fondly responds to every one of my blundering e-mails in particular. To the point: I've run a few test programs myself and you're right Jason, it does write out the correct values on NT, well, actually it writes out Ö#9604;Í#9472;³÷õ, not ÜÖÄüöä, in my cmdprompt, but I'm not picky. In the ascii table the values are the correct ones. BUT, on my BEA WebLogic Application Server 6.1, the seperate case C chars are read as 65533, which is something I'll look into, and report back to you with if I find out what the ... is going on. Guess I'll begin with char sets. I really do appreciate the help, and the brilliant software. Who knows, maybe I'll contribute with something constructive yet. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-29 10:13 --- By the way, I ALLWAYS set the value useUTF16-thing to true, but I'd like to know where you decide what's READ, because it doesn't matter how you save it, Excel changes the format when you're playing around... I'm looking into it myself right now, the values are wrong when read from the Binary tree, so the next thing I'll try to figure out is if they're wrong when they're put() into it. I'll need a bit more time for that though, since I have to read up on the filesystem. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND
INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322
can't read ÜÖÄüöä ... sometimes.
--- Additional Comments From [EMAIL PROTECTED] 2002-08-29 13:54 ---
What I've narrowed it down to, is that in the SSTDeserializer, when you call
processString, and say:
UnicodeString string = new UnicodeString(UnicodeString.sid,
(short) unicodeStringBuffer.length,
unicodeStringBuffer );
String chars = string.getString();
for( int i = 0; i chars.length(); i++ )
{
System.out.print((int)chars.charAt(i) + );
}chars = null;
then if it is a there are chars between 160-255(keep in mind the bytes actually
have the int value -1 -64), then they all get converted to the value 65533
I don't know exactly where the conversion takes place, and I don't have time to
look any further today, but if you know, please tell me. I'd like to solve this
bug.
Tomorrow I'll have a good look at the UnicodeString class.
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-28 07:10 --- So basically, the error that should be fixed is the following, you have 3 different ascii sets: A) 0-128 B) 129-159 C) 160-255 Cells containing A, should be read as an 8 bit cell. Cells containing A B should be read as 16 bit Cells containing A C should be read as 16 bit Cells containing A B C should be read as 16 bit Cells containing B C should be read as 16 bit But HSSF reads cells containing A C as an 8 bit cell. Which is wrong, because Excel handles these as 16 bit. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-28 13:55 --- cool, can you submit a patch changing this behavior? Start at org.apache.poi.hssf.record.SSTRecord -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-20 11:40 --- Thanks, that's all I wanted to know. The source is very simple: HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); wb.setSheetName( sheetcounter, sheetName ); HSSFRow row = sheet.createRow((short)rowcounter); HSSFCell cell = row.createCell((short)0); cell.setEncoding( HSSFCell.ENCODING_UTF_16 ); cell.setCellType( HSSFCell.CELL_TYPE_STRING ); cell.setCellValue(iETI.getLanguage()); /*multiple cells...*/ byte[] bytes = wb.getBytes(); POIFSFileSystem fs = new POIFSFileSystem(); fs.createDocument(new ByteArrayInputStream(bytes), Workbook); ByteArrayOutputStream byteos = new ByteArrayOutputStream(); fs.writeFilesystem(byteos); byteos.close(); return byteos; The thing is, which I've explained, the error occurs when you write out the file, manually change it, and read the file again with HSSF. Then the above mentioned errors occur. HSSF has propblems recognizing if the cells are saved as 8 or 16 bit, depending on if the characters in the cell are between ascii: 0- 128 or 129-159 or 160-255. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-16 13:13 --- It would be nice if someone who cares would simply write: Yes, my friend, we are working on this bug. or: No we are not working on your bug, so stick it up your **s. Because I'd like to know how YOU feel...!? Thanks in advance, /Tom -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-16 14:11 --- One thing I relize I didn't ask for. . Can you give me the source you used to generate the HSSF version? If you can supply it in the form of a junit test it would be perfect. (I'd apply that in advance of fixing it!) The fact that I haven't closed the bug or marked it as fixed implies that I will look at it when I have time. (If you'd like it fixed faster, I can give you a mailing address and you can contribute to paying my mortgage.) -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-02 06:22 --- By the way, this bug also occurs in your latest releases. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-01 06:47 --- Created an attachment (id=2551) The file made with HSSF and saved in excel -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-01 06:48 --- Created an attachment (id=2552) The file made with HSSF, has not been opened in excel, notice it is smaller. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-01 06:49 --- Created an attachment (id=2553) File made with excel -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-08-01 08:22 --- I think what I've observed is that Excel 2000 treats fields like Über as normal text, but if there's a Trademark in there, excel changes from 8 to the 16 bit flag, so Über would be treated as 16 bit. Whereas HSSF reads both Über(Excel 8 bit) and Über(Excel 16 bit) as 16 bit fields, and so it reads out a REALLY big value for the Ü in Über(Excel 8 bit). Correct? /Tom PS. hope HTML can show ...if not, then it's supposed to be a trademark(ascii 0153). -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-07-31 12:41 --- What is the value of HSSFCell.getEncoding() on the Short.MAX_VALUE returning cells? In the case where you have umlauts it should be 1 and HSSF should read it as 16-bit characters. If not...that is a most nasty bug in 1.5.1. Glen, correct me if I'm wrong. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-07-31 12:58 --- Hello again, I made the good old: System.out.println( encoding: + cell.getEncoding() ); and got the result for every single cell(well all 7 anyway): encoding: 0 -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-07-31 13:10 --- I may have left out an important piece of information: Basically, I: Create my Excel sheets using HSSF on a weblogic Download them Change the sheets Upload them Read them using HSSF. Actually, if I DON'T make any changes, they are read just fine, but as soon as I press the save button in Excel, the format changes a bit, and HSSF is not able to read the cells with the characters with ascii values above 128. I use Microsoft Excel 2000. /Tom PS. this change is what I tried to explain in the initial bug report, except then I didn't know excaclty what happened. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
DO NOT REPLY [Bug 11322] - can't read ÜÖÄüöä ... sometimes.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE. http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11322 can't read ÜÖÄüöä ... sometimes. --- Additional Comments From [EMAIL PROTECTED] 2002-07-31 13:11 --- Correction, the cells are read ok, I meant it's the characters IN the cells that are wrong. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
