spreedsheetsetcellvalue doesn't support the datatype argument

[cfjedimaster]

See: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-s/spreadsheetsetcellvalue.html

This is hitting me as I've got a cell that needs a numeric datatype, but it's being written as a string.

[Leftbower]

Correct, the Lucee extension was written pre-CF11 (when dataType was added). It looks to an easy fix but haven't had the time to do so myself. If you look at the previous issue (#3) you can see a workaround.

…

On Sat, Jan 21, 2017 at 9:13 AM, Raymond Camden ***@***.***> wrote: See: https://helpx.adobe.com/coldfusion/cfml-reference/ coldfusion-functions/functions-s/spreadsheetsetcellvalue.html This is hitting me as I've got a cell that needs a numeric datatype, but it's being written as a string. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#6>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AA7tBE8ODK6cTlwjQnw4uzwdhDNiTABrks5rUjzCgaJpZM4LqH-J> .

[cfjedimaster]

I'm confused - #3 seems to be out builds - not a workaround related to anything.

[Leftbower]

So sorry Ray. It was issue #3 in the Lucee 4.x version of the extension where that section of the code was talked about that I had meant to point you to: Leftbower/cfspreadsheet-lucee#3 That file is the nearly the same in both extensions... We'd just need to throw an extra arg and a little logic into that section to get it going (CFML is not my main gig so I haven't had a great deal of time to do too many mods... sorry about that!)

…

On Mon, Jan 23, 2017 at 4:33 AM, Raymond Camden ***@***.***> wrote: I'm confused - #3 <#3> seems to be out builds - not a workaround related to anything. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#6 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AA7tBKqKXk5AawqRasYlW_9YIG489JgQks5rVJ4FgaJpZM4LqH-J> .