cfspreadsheet merge

[Joost van der Drift]

Hi

I have a question about spreadsheet functionality: when I use `SpreadsheetMergeCells` and then `SpreadsheetSetCellValue`, it seems like the SetCell function does not take into account the fact that cells are merged. Eg, when I merge cells 1-3 and then set a value in cell 2, I expect it to be in column D (a-c being merged, thus counting as 1), but the value is added to column B. How can this be dealt with? (Lucee 4.5.5.006 final)

Regards

Joost

[Charlie Arehart]

Joost, I don't work with Lucee actively, and haven't even used those functions in cf. 

Have you tried first to confirm if it works in cf? If it did not, then it would seem to suggest kit may be more a misunderstanding about how the functions should work. Some work ON a given object, others return a NEW object based on the operation requested. 

Then finally if you feel it's a bug, wouldn't you want to report it to the Lucee folks? Or ask this of them or via their support forums? 

/Charlie

--
You received this message because you are subscribed to the Google Groups "Team CF Advance" group.
To unsubscribe from this group and stop receiving emails from it, send an email to team-cf-advance+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/team-cf-advance/0154f44f-a16d-41c7-8557-1173981218ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Denard Springle]

I haven't manipulated spreadsheets in this way in a good long while, but I believe merged cells still retain their column designations, so setting a value of 2 for the column in SpreadsheetSetCellValue() would be column B even in a merged cell. You'd want to specify column 4 in this case to get column D.

HTH

-- Denny