[
https://issues.apache.org/jira/browse/TIKA-4159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17775812#comment-17775812
]
Tim Allison commented on TIKA-4159:
-----------------------------------
This is what we get for xls in both 5.2.3 and 5.2.4:
{noformat}
<table><tbody><tr> <td>0</td></tr>
<tr> <td>0</td></tr>
<tr> <td>0</td></tr>
<tr> <td>0</td> <td>this is some text</td></tr>
<tr> <td>0</td></tr>
<tr> <td>0</td></tr>
<tr> <td>0</td></tr>
<tr> <td>0</td></tr>
<tr> <td>0</td></tr>
{noformat}
> 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. I should
> not have dismissed Tilman's finding on the list as "already known." This is a
> problem. Thank you!
> 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}
> <table><tbody><tr> <td>0</td></tr>
> <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)
