Re: [Lazarus] fpspreadsheet excel5 export

2010-06-24 Thread Felipe Monteiro de Carvalho
Well, it seams to be unfeasable for me to implement this at the moment, because my OpenOffice cannot read nor write Excel5 files in a different charset from Latin1. Therefore I cannot test my implementation (I don't have Excel). But anyway, you can also just use Excel 8 or OpenDocument format to

[Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Bogusław Brandys
Hi, I tried to do this : MyWorksheet.WriteUTF8Text(0, 3, 'żźćęńóśćąłŻŹĆĄŚĘŃÓŁ'); but not all Polish chars are stored. is this a limitation of excel5 xls files or a bug in fpspreadsheet ? I opened file in OpenOffice 3.1 because I have no Microsoft Excel. Regards Boguslaw --

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Felipe Monteiro de Carvalho
Excel 5 does not support unicode. My original code would just store all strings as iso-latin-1, so I am surprized that any letters are stored at all. You only used letters outside iso-latin-1, so they should all show up wrong. There is a table comparing the formats here:

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread ik
MS Office as a whole, as far as I know does not store data in UTF-8 but in CP codes, and that information is read depending on the MS Office language itself. I do not know that for sure, but I know about this due to a bug that was in OpenOffice that tried to open a doc file wrong because of it.

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Felipe Monteiro de Carvalho
2010/6/23 ik ido...@gmail.com: MS Office as a whole, as far as I know does not store data in UTF-8 but in CP codes, and that information is read depending on the MS Office language itself. Not true, Excel 8+ supports storing strings as UTF-16 It can also in addition to that store strings in

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread ik
Can you make it possible to store letters not only in iso-latin but with other iso's as well ? Ido On Wed, Jun 23, 2010 at 18:06, Felipe Monteiro de Carvalho felipemonteiro.carva...@gmail.com wrote: Excel 5 does not support unicode. My original code would just store all strings as

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Felipe Monteiro de Carvalho
What kind of encodings do you need? Latin1, Latin2 and Hebrew? -- Felipe Monteiro de Carvalho -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Bogusław Brandys
Felipe Monteiro de Carvalho wrote: What kind of encodings do you need? Latin1, Latin2 and Hebrew? I have tested excel8 writing using xlsbiff8 unit and excel5demo project (replaced xlsbiff5 with xlsbiff8 ) but effect is the same. Is there any method to write UTF8 or at least CP1250 Polish

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Felipe Monteiro de Carvalho
2010/6/23 Bogusław Brandys bran...@o2.pl: I have tested excel8 writing using  xlsbiff8 unit and excel5demo project (replaced xlsbiff5 with xlsbiff8 ) but effect is the same. Did you change the place where you specify the format in which you want to save? MyWorkbook.WriteToFile(MyDir +

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Bogusław Brandys
Felipe Monteiro de Carvalho wrote: 2010/6/23 Bogusław Brandys bran...@o2.pl: I have tested excel8 writing using xlsbiff8 unit and excel5demo project (replaced xlsbiff5 with xlsbiff8 ) but effect is the same. Did you change the place where you specify the format in which you want to save?

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Felipe Monteiro de Carvalho
2010/6/23 Bogusław Brandys bran...@o2.pl: Thanks! It works now. Btw when I'm trying to look at properties of generated Excel 97 file it crashes explorer. Properties as in right-clicking the file in explorer and clicking properties ? If yes, then I blame Windows. I don't see how my library

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread ik
All ISO 8859x encoding, why to limit it ?! BTW Hebrew have to ISO encoding: ISO-88598 and ISO88598-i . The second is extended and contain punctuation points and few other chars. Ido On Wed, Jun 23, 2010 at 19:11, Felipe Monteiro de Carvalho felipemonteiro.carva...@gmail.com wrote: What kind

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Bogusław Brandys
Felipe Monteiro de Carvalho wrote: 2010/6/23 Bogusław Brandys bran...@o2.pl: Thanks! It works now. Btw when I'm trying to look at properties of generated Excel 97 file it crashes explorer. Properties as in right-clicking the file in explorer and clicking properties ? If yes, then I blame

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread Felipe Monteiro de Carvalho
2010/6/23 ik ido...@gmail.com: All ISO 8859x encoding, why to limit it ?! BTW Hebrew have to ISO encoding: ISO-88598 and ISO88598-i . The second is extended and contain punctuation points and few other chars. I did a initial implementation, but it doesn't seam to be possible to have various

Re: [Lazarus] fpspreadsheet excel5 export

2010-06-23 Thread ik
On Wed, Jun 23, 2010 at 20:16, Felipe Monteiro de Carvalho felipemonteiro.carva...@gmail.com wrote: 2010/6/23 ik ido...@gmail.com: All ISO 8859x encoding, why to limit it ?! BTW Hebrew have to ISO encoding: ISO-88598 and ISO88598-i . The second is extended and contain punctuation points