D 2023-02-02T12:42:14.904
J foundin 2.0.0-RC2
J icomment If\sI\sgenerate\sa\sworkbook\swith\sopenpyxl\swith\sthe\sfollowing\sscript,\sI\scan\snot\sread\sit\swith\sFreeXL\s:\sthe\sstrings\sare\snot\srecognized,\ssometime\sthe\ssize\sof\sthe\ssheet\sis\swrong.\r\n\r\nIf\sI\sopen\sthe\sfile\swith\sooffice\sand\sthen\sresave\sit,\sit\sworks.\r\n\r\nIn\sthe\szipped\sfile\sof\sthe\ssheet,\sI\scan\ssee\sthat\sopenpyxl\sstore\sthe\sstrings\swith\stype\s"inlineStr",\sbut\sooffice\sstore\sthem\swith\stype\s"s".\r\n\r\nI\sthink\sthat\sFreeXL\signore\sthe\stype\s"inlineStr"\sreading\sthe\scell\sas\sNULL.\r\n\r\nimport\sopenpyxl\r\nwb\s=\sopenpyxl.Workbook()\r\nws\s=\swb.active\r\nws.title\s=\s"foo"\r\nws['A1']\s=\s"bar"\r\nws['B1']\s=\s"baz"\r\nws['A2']\s=\s42\r\nws['B2']\s=\s3.14159\r\nwb.save('bug.xlsx')
J login anonymous
J mimetype text/plain
J private_contact 977cd8e1d3ac364f623d42d6d20a61ff2dc4272a
J severity Severe
J status Open
J title Impossible\sto\sread\sfiles\screated\sby\sopenpyxl
J type Code_Defect
K 467bd4e12fc211e76fd95b1cf1f6b756c7ec2e55
U anonymous
Z 40b66345416b106a884460751366c40a