Passolo format Cell in Excel is changed from original source file when generated target file.

Issue#2

All numbers have been changed from ‘Text’ as general format cells, to other value (‘Percentage’, ‘Number’, and etc.).

-----------------------[Reported by the client as this sample]--------------------------

Original Source:

(99.9)

 

Generated target file:

-99.9

Original Source:

100%

 

Generated target file:

1

Original Source:

100.0

 

Generated target file:

100

Original Source:

55.0

 

Generated target file:

55

Format cells has changed to ‘Number’

Format cells has changed to ‘Percentage’

Format cells has changed to ‘Number’

Format cells has changed to ‘Number’


 

When the string were aligned translation from a Excel to Passolo project the string look good the same as Excel sheet. However, the value in Excel sheet has been changed with the format cell as native of each language. It's not good idea to auto format cell as it would make the data incorrect as original formatting.

--------------------------------------------------------------------------------