[
https://issues.apache.org/jira/browse/TIKA-4159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Allison updated TIKA-4159:
------------------------------
Attachment: testEXCEL_boolean_and_errors.xlsx
> Boolean values and error msgs in xlsx
> -------------------------------------
>
> Key: TIKA-4159
> URL: https://issues.apache.org/jira/browse/TIKA-4159
> Project: Tika
> Issue Type: Task
> Reporter: Tim Allison
> Priority: Minor
> Attachments: testEXCEL_boolean_and_errors.xlsx
>
>
> [~tilman] noted a large change in the handling of boolean values and error
> messages in the latest regression tests in prep for the 2.9.1 release. The
> diffs in values were caused by changes between POI 5.2.3 and 5.2.4.
> This is 5.2.3:
> {noformat}
> <table><tbody><tr> <td>FALSE</td></tr>
> <tr> <td>TRUE</td></tr>
> <tr> <td>ERROR:#DIV/0!</td></tr>
> <tr> <td>ERROR:#VALUE!</td> <td>this is some text</td></tr>
> <tr> <td>ERROR:#DIV/0!</td></tr>
> <tr> <td>0</td></tr>
> <tr> <td>ERROR:#NAME?</td></tr>
> <tr> <td>ERROR:#VALUE!</td></tr>
> <tr> <td>ERROR:#VALUE!</td></tr>
> </tbody></table> {noformat}
> This is 5.2.4
> {noformat}
> <tr> <td>1</td></tr>
> <tr> <td>#DIV/0!</td></tr>
> <tr> <td>#VALUE!</td> <td>this is some text</td></tr>
> <tr> <td>#DIV/0!</td></tr>
> <tr> <td>0</td></tr>
> <tr> <td>#NAME?</td></tr>
> <tr> <td>#VALUE!</td></tr>
> <tr> <td>#VALUE!</td></tr> {noformat}
>
> My feeling is that we should definitely try to fix the booleans. I'm not as
> sure about re-inserting the ERROR: .
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
