FS#66797 - [catdoc] Parse boolean formulas

Attached to Project: Community Packages
Opened by Alberto Fanjul (albfan) - Wednesday, 27 May 2020, 06:51 GMT
Last edited by George Rawlinson (rawlinsong) - Saturday, 13 May 2023, 09:53 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To George Rawlinson (rawlinsong)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description: Using catdoc (xls2csv) cells with =TRUE() or =FALSE() are always parsed as 0. I have a patch to fix it

https://github.com/albfan/catdoc/commit/101a9775ca3620f4a307a1159a41777115e8a04d

There is too an improvement on error cells

https://github.com/albfan/catdoc/commit/3613753da4cc47331f0cebd49445da357b8b5f75

and wonder if we can patch the package on arch linux

I tried to contact upstream maintainer for catdoc but I get no response. I'm contacting too packagers and contributors of catdoc arch linux package.


Additional info:
* catdoc last version
* config and/or log files etc.
* there is no access to upstream bug report, so I created one https://github.com/albfan/catdoc/issues/1

Steps to reproduce:

Using the attached booleans.xls

xls2csv booleans.xls

"0"
"0"
"ERROR","1","0"
"ERROR"
"ERROR"

and with the suggested patches:

"0"
"1"
"DIV/0!","1","0"
"NULL!"
"NAME?"


This task depends upon

Closed by  George Rawlinson (rawlinsong)
Saturday, 13 May 2023, 09:53 GMT
Reason for closing:  Fixed
Additional comments about closing:  0.95-5
Comment by Alberto Fanjul (albfan) - Wednesday, 27 May 2020, 20:12 GMT
Let me know if I can help in any way. Is the abs in svn or there's any git repo to send a PR too?

Loading...