search

Leftbower / cfspreadsheet-lucee-5

A cfspreadsheet extension for Lucee 5
23 stars 10 forks source link

SpreadsheetCreateSheet/SpreadsheetSetActiveSheet different behavior than Lucee- 4 version #12

Closed srconklin closed 6 years ago

srconklin commented 6 years ago

Not sure if this the correct place to report this issue, but it appears the exact same CFML code that produces a downloadable spreadsheet running on version 4 works correctly but fails on version 5.

the app performs the following simple steps

1 ) a simple FOR loop iterating over 0 to 7 (for the days of the week) is executed 2) a new tab is created for each day and then it is made active <cfset SpreadsheetCreateSheet(theSheet, today) />
<cfset SpreadsheetSetActiveSheet (theSheet, today) />

3) the data is then added to the sheet using SpreadsheetAddRows

In 4.0, I see the data being inserted correctly under each the 7 tabs of the day of the week...works great. in 5.0, I see the 7 tabs properly created but all are empty except the first one. In other words, all the rows are being added under the first tab instead of being distributed to the others as they should. It is as if, SpreadsheetSetActiveSheet is not working..

Can you offer any guidance?

index.zip

srconklin commented 6 years ago

disregard.. turns out to be a versioning issue on our end