Free Support Forum - groupdocs.com

Xlsx comparison not showing text changes beyond frist space


#1

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:

Text in cell A1 with spaces
Text in cell A1 that has spaces
text_in_cell_a3_without_spaces
text_in_cell_a3_that_has_no_spaces


#2
Hello,

Sorry to see you are facing this problem. We’ve reproduced it, seems like a bug. Our developers are informed about it. When the fix will be published you’ll get notified about it.


#3

Hello,


Any update on when this will be fixed?

Thanks.

#4
Hello,

Thanks for your patience. We understand that this issue is important to you and it is unfortunate that the issue has not yet been fixed. We're not quite sure at the moment when this will be fixed completely. We're expecting to include this fix in our next release. however, this estimate is not final at the moment. We'll let you know as soon as we make some progress or resolve the issue completely.

We're sorry for the inconvenience.