Failure to open project XLSX in MSFT Excel on Windows #206
Labels
bug
Something isn't working
Comments
pombredanne
added a commit
that referenced
this issue
Jun 18, 2021
We now check that the content is correctly added before calling XlsxWriter and report and error if the truncated can be truncated. Several other adaptations of a cell content are done: - Create a combined license expression for expressions. - Keep only unique values in lists, preserving ordering. - Collect the main attribute of well known scan fields - Convert mappings to YAML. - Truncate the "description" field to the first five lines. - Convert anything unknown to string. - Normalize line endings - Truncate to a maximum_length any field too long to fit in an XLSX cell and report error. Signed-off-by: Philippe Ombredanne <[email protected]>
|
There is a bug in XlsxWriter tracked here: jmcnamara/XlsxWriter#812 |
tdruez
added a commit
that referenced
this issue
Jun 22, 2021
Signed-off-by: Thomas Druez <[email protected]>
tdruez
added a commit
that referenced
this issue
Jun 22, 2021
Signed-off-by: Thomas Druez <[email protected]>
tdruez
added a commit
that referenced
this issue
Jun 22, 2021
Signed-off-by: Thomas Druez <[email protected]>
tdruez
added a commit
that referenced
this issue
Jun 22, 2021
Signed-off-by: Thomas Druez <[email protected]>
tdruez
added a commit
that referenced
this issue
Jun 22, 2021
* Improve XLSX creation #206 We now check that the content is correctly added before calling XlsxWriter and report and error if the truncated can be truncated. Several other adaptations of a cell content are done: - Create a combined license expression for expressions. - Keep only unique values in lists, preserving ordering. - Collect the main attribute of well known scan fields - Convert mappings to YAML. - Truncate the "description" field to the first five lines. - Convert anything unknown to string. - Normalize line endings - Truncate to a maximum_length any field too long to fit in an XLSX cell and report error. Signed-off-by: Philippe Ombredanne <[email protected]> * Format code Signed-off-by: Philippe Ombredanne <[email protected]> * Set row height to avoid auto-fit and improve the workbook labels #206 Signed-off-by: Thomas Druez <[email protected]> * Minor code improvements to the errors col setup #206 Signed-off-by: Thomas Druez <[email protected]> * Add changelog entry #206 Signed-off-by: Thomas Druez <[email protected]> * Remove print statements #206 Signed-off-by: Thomas Druez <[email protected]> Co-authored-by: Thomas Druez <[email protected]>
|
@pombredanne This one is fixed, right? |
|
Fixed confirmed. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I scan OK https://files.pythonhosted.org/packages/94/40/c396b5b212533716949a4d295f91a4c100d51ba95ea9e2d96b6b0517e5a5/urllib3-1.26.5.tar.gz with the
scan_codebasepipeline.I then fetch the project XLSX and open it in a VM on Windows with MSFT Office and I get a message that the document is corrupted.
It is because the package description exceeds 32767 characters length which is a limit in Excel.
XlsxWriter should truncate these but does not here.
We should also report an error in anycase rather than truncate silently.
The text was updated successfully, but these errors were encountered: