When comparing two .xlsx files, any changes in text that contains spaces only shows the first word that changed in the ChangeInfo Text property, dropping the rest. In addition, the width of the column seems to also make a difference, where text that is outside the viewing width is also truncated from the Text property, but redline output still seems to be valid.
Example:
Source sheet cell A1:
Text in cell A1 with spaces
Source sheet cell A3:
text_in_cell_a3_without_spaces
Target sheet cell A1:
Text in cell A1 that has spaces
Target sheet cell A3:
text_in_cell_a3_that_has_no_spaces |
The results are just being displayed in a simple GridView, shown below.
Id | Type | TypeStr | Action | ActionStr | Text |
---|---|---|---|---|---|
0 | Delete | Delete | None | None | Text |
1 | Insert | Insert | None | None | Text |
2 | Delete | Delete | None | None | text_in_cell_a3_without_spaces |
3 | Insert | Insert | None | None | text_in_cell_a3_that_has_no_spaces |
Incidentally, the redline file seems to be correct, shown below:
|
|