Tim Allison created TIKA-4159:
---------------------------------
Summary: 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
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)
