My money is that this is a "character set" issue. I don't know that POI currently even exposes the "character set" properties. We currently set the default character set (which is probably ISO-8859-1). This would be a missing feature for the moment.
You've a few options: 1. Fix it 2. Wait for someone else from france to fix it ;-) 3. Wait till Formulas, Graphing and other odds and ends are done and then I'll probably get around to fix it. If you opt for #1 I suggest the following course of action: create a sheet with the � using Excel. Try reading it in and writing it out with HSSF. If it still opens fine with the correct � then that proves my theory. If not, then either we're overriding the existing value (which I would regard as a bug) or I've totally missed the mark. If I'm right, then also create the same sheet from scratch with HSSF. Do a org.apache.poi.hssf.dev.BiffViewer excel.xls > output.foo1 on the excelfile where "excel.xls" equals the filename. and a org.apache.poi.hssf.dev.BiffViewer hssf.xls >output.foo2. Diff them with either the UNIX diff tool or your favorite command-line diff tool (or a gui one that doesn't display the whole file). There will likely be numerous minor differences, but what you're interested is in the "charset" or character set properties and records. Find out where these are and add functions to modify them in org.apache.poi.hssf.model.Sheet or Workbook as well as in org.apache.poi.usermodel.HSSFSheet or HSSFWorkbook. That seems fairly simple. Supply this as a patch against the head and it will make the next development build. So far as I know we're not planning another 1.5.x release unless any serious bugs are found. -Andy On Wed, 2002-07-03 at 03:14, Emmanuel HUGONNET wrote: > Hi, > I'm using POI 1.5.1 on a 'french' computer. All is working allright but when > I open my excel file the � and other accentuated characters are displayed > badly. By this I mean that excel seems to interpret them as ISO-8859-1 chars > and not UTF-8 (because if I save the fiel in html then open it with excel in > UTF-8 mode all is displayed correctly). I tried to add the unicode support > in excel with the police and adding the international support package but > nothing seems to help. Am I missing something when creating my excel file ? > Thanks for any help > > > ---- > Emmanuel Hugonnet > SQLI Lyon > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
