Cfspreadsheet cell trimming problem in different versions of ColdFusion

Take the following code ...

<cfspreadsheet action="read" src="#z.xlsfile#" query="data" headerrow="1" excludeHeaderRow="true" />
<cfoutput>
    <!--- Lets replace spaces with $ so they are easy to see --->
    <cfloop query="data">
        #data["Doc Type"][data.currentrow]# - #replace(data["Doc Type"][data.currentrow],' ','$','all')#<br>
        #data["Doc No"][data.currentrow]# - #replace(data["Doc No"][data.currentrow],' ','$','all')#<br>
        #data["Doc Rev"][data.currentrow]# - #replace(data["Doc Rev"][data.currentrow],' ','$','all')#<br>
        #data["File Name"][data.currentrow]# - #replace(data["File Name"][data.currentrow],' ','$','all')#<br>
        <hr>
    </cfloop>
</cfoutput>
<cfabort>

The XLS file that is being read has cell data that has leading and trailing spaces. On one ColdFusion server, the output does not display spaces, as if it <cfspreadsheet>automatically cropped all the data. On a different server this is not the case. I think maybe it has poi.jarbeen changed? Has anyone else experienced this? I could not find anyone complaining about this.

This ColdFusion server will automatically crop the data ...

Version: 2016,0,02,299200

Update Level: chf20160002.jar

Is not...

Version: 10,0,19,298511

Update Level: chf10000019.jar

+4
source share

All Articles