[
https://issues.apache.org/jira/browse/TIKA-4159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Allison updated TIKA-4159:
------------------------------
Description:
[~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: .
was:
[~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: .
> 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)
