Vista + Excel 2007 + Russian Charset

[Denismol]

I trying your Demo projects in Delphi 2007 and Delphi 2009. When I try with Excel 97-2003 all work good with Russian charset (Delphi 2007 and 2009). When I trying with Excel 2007 Russian symbols don't read. In Delphi 2007 I have empty string instead of Cell with Russian symbols. In Delphi 2009 I have string with '?' instead of Cell with Russian symbols. When I save file with XLSReadWrite, Excel 2007 cann't open it.

What the problem? May be in Vista or may be you cann't work correct with utf-8 in xlsx format?

[larsa]

Hello

There seems to be a problem with the UTF-8 decoding in Excel 2007 files. I will fix this asap.

[kexo]

hi, i'm encountering the same problem reading xls2007 with Slovak charset...

[larsa]

Hello

This is fixed in update 4.00.26

[kexo]

Hi, i've tested the .26 version, but i'm still getting same results - empty strings read from cells containing special slovak characters.
I'm using XLS.Sheets[0].AsFmtString[7,0] syntax to access the cells.

[larsa]

Hello

Can you please send me a sample of this file?

[Denismol]

I testing versin .30. Now Russian Charset work correct. BUT I have other problem. After work with xlsx file, I save it and try open with MS Office 2007. MS Office 2007 say that :
"There is not readble data. Try to restore data?" (translate from Russian). Then MS say: "Delete component: path /xl/styles.xml with error XML (styles) impossible char xml. row 1, columns 5152.
Restore records: Information about cells from path /xl/worksheets/sheet1.xml".

Then MS Office open file, but there aren't borders and background colors.

[larsa]

Hello

Please send me the file.

[Denismol]

I send to components@axolot.com

[vga]

procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
end;

'c:\aa.xlsx'; could not open by Excel 2007 , why?