QXlsx icon indicating copy to clipboard operation
QXlsx copied to clipboard

Discarding phonetic data when reading from a cell

Open szumial opened this issue 2 years ago • 2 comments

Hi! Is there a way to ignore the phonetic data (objects) for a given cell using QXlsx? For example, when an Excel file with Japanese language is edited and text is typed directly to a given cell, those phonetic objects are added, although not displayed until Excel users specifically the option to "Show Phonetic Field". When I import data from such cell with QXlsx, the phonetic object is also read. I would like to discard it if possible.

szumial avatar May 08 '23 12:05 szumial

Is your problem solved? I also encountered the same problem:[(https://github.com/QtExcel/QXlsx/issues/296)]. If it has not been solved, I can only use QAxObject. Although it is more troublesome to use, but no such problem.

wslj2016 avatar Jul 18 '23 14:07 wslj2016

Hi! The only workaround for me was plain editing the excel file - it is possible to copy and paste the data to discard phonetic objects.

szumial avatar Jul 20 '23 13:07 szumial