QXlsx
QXlsx copied to clipboard
Discarding phonetic data when reading from a cell
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.
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.
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.