search

turicas / rows

A common, beautiful interface to tabular data, no matter the format
GNU Lesser General Public License v3.0
869 stars 134 forks source link

XSLX and ODS plug-ins have issues with cells using `%` format #290

Closed jsbueno closed 6 years ago

jsbueno commented 6 years ago

If cells are marked with "percent" number format in a XLSX sheet, rows will present a couple of issues.

  1. If in any such cell there is text content, rows breaks with an exception in the Decimal conversion (traceback to come later) (this was my real life issue - and exploring it revealed the next flaw)
  2. If a cell contains the '100%' value, it is improperly considered as '1':

broken_sheet

+-------+
|  bla  |
+-------+
|    1% |
| 23.2% |
|    1% |
|   10% |
|    1% |
+-------+

This issue is also present on the ODS plug-in.