search

yulqen / bcompiler-engine

MOVED: A Python library to alleviate the pain of using Excel spreadsheets to collect data from your stakeholders.
https://git.sr.ht/~yulqen/bcompiler-engine
MIT License
4 stars 1 forks source link

Some conditional formatting in files created by LibreOffice causes exception on load #3

Closed yulqen closed 3 years ago

yulqen commented 5 years ago

This issue at openpyxl appears to be responsible.

Exception is TypeError: expected <class 'openpyxl.worksheet.cell_range.MultiCellRange'> upon calling openpyxl.load_workbook().

Removing all conditional formatting in offending file allows it to proceed.

yulqen commented 5 years ago

The problem occurs when conditional formatting in LibreOffice appears as per the screenshot below:

2019-07-27-212126_529x463_scrot

The user is unable to create a situation where the rule has an empty range via the UI, but according to the upstream bug report this is the result of a bug in LibreOffice, which is not adhering to standard. If the user removes these ranges, according to current tests the file can load and proceed as normal.

A test has not been retained in the repository for this because the original file that demonstrated the bug could not have its sensitive data removed and resaved without the problem going away. Needs to be tested manually.