Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

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 freswa (frederik) - Wednesday, 27 May 2020, 16:29 GMT
Task Type Bug Report
Category Packages
Status Assigned
Assigned To Kyle Keen (keenerd)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
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?"


   booleans.xls (6 KiB)
This task depends upon

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...