search

PydPiper / pylightxl

A light weight, zero dependency, minimal functionality excel read/writer python library
https://pylightxl.readthedocs.io
MIT License
290 stars 47 forks source link

Inconsistent handling of non-ASCII chars #99

Open HENDRIX-ZT2 opened 10 months ago

HENDRIX-ZT2 commented 10 months ago

Pylightxl Version: 1.61 Python Version: 3.11

Summary of Bug/Feature: under some currently unknown conditions, writing a freshly created db to xlsx files produces xlsx that fail to open correctly in LibreOffice. They terminate when a cell is reached that contains a non-ASCII character (German chars ä, ö, ü, ß, in this case). However, some dbs that do contain those chars save just fine and are read just fine.

Looking at the exported data, the sharedStrings.xml, both working and broken results have the expected header

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

However, the broken one additionally escapes the chars, while the working one does not. sharedStrings.zip

Traceback: n/a

Suggestion for fix: not sure yet

HENDRIX-ZT2 commented 10 months ago

Ha, this is actually a duplicate of https://github.com/PydPiper/pylightxl/issues/81