Character encoding issue

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
CareAll
Posts: 28
Joined: Mon Jun 24, 2013 9:30 am

Character encoding issue

Post by CareAll »

Hello,

I created az xlsx file with Excel and modified it with XLSReadWriteII 5.20.12.
After that I tried to open the file with Excel, but it shows me an error message.

I managed to find the reason of that, e.g. in the \xl\pivotTables\pivotTable1.xml file in the pivotTableDefinition section the "name" parameter contains special characters: "Kimutatás1" which is changed after saving with your component to "KimutatÇs" (Before the Ç character there is a 0x02 character, too).

The same issue is found in the \xl\pivotCache\pivotCacheDefinition1.xml file in the pivotCacheDefinition section with the "refreshedBy" parameter's value.

Please take a look at this bug and fix it.
Thank you in advance.

Tamas
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Character encoding issue

Post by larsa »

Hello

Please send me an excel file with this problem.
Lars Arvidsson, Axolot Data
CareAll
Posts: 28
Joined: Mon Jun 24, 2013 9:30 am

Re: Character encoding issue

Post by CareAll »

Hello Lars,

I sent a file to xxx@yyyyyy.zzz.

Tamas
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Character encoding issue

Post by larsa »

Hello

This is fixed in update 5.20.13
Lars Arvidsson, Axolot Data
CareAll
Posts: 28
Joined: Mon Jun 24, 2013 9:30 am

Re: Character encoding issue

Post by CareAll »

Hello,

The very same error occurs again in 5.20.25 and 5.20.26 also.
Please fix it.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Character encoding issue

Post by larsa »

Hello

This is fixed in update 5.20.27
Lars Arvidsson, Axolot Data
Post Reply