Symptoms
When converting between Excel and RTX, cell value containing trailing space are not always consistently trimmed also when changing between POI and FastExcel usage, causing unexpected result and complicate switching between POI and FastExcel.
Note: Redwood Recommend strongly using FastExcel whenever possible
Redwood_Convert_Excel_toRTX:
- POI: .xsls input with Trailing space => RTX result is trimmed
- FastExcel: .xsls input with Trailing space => RTX result include trailing space
Redwood_Convert_RTX_toExcel:
- POI: RTX input with Trailing space => .xsls result include trailing space
- FastExcel: RTX input with Trailing space => .xsls result is trimmed
Steps to reproduce:
- Create an excel file with trailing space in cell and column
- submit Redwood_Convert_Excel_toRTX
- POI see the RTX result is Trim
- FastExcel see the RTX result kept the space
- Submit Redwood_Convert_RTX_toExcel using the RTX which as trailing space
- POI see that excel result kept the space
- FastExcel see that excel result removed the space
- POI see the RTX result is Trim
Affected version
RunMyFinance
Resolution
This issue will be fixed to consistently have trim result in a future version
Reference
ROSO-16183
Comments
0 comments
Please sign in to leave a comment.