[openxls-develop] Insert Cell
Brought to you by:
aryaniae,
extentechjohn
From: Nick P. <nb...@gm...> - 2013-12-06 02:21:26
|
I see insertCol and insertRow functionality, but not a single cell insert. I've taken a row, shifted all cells over by one that are affected (shifting from the end of the row towards the insertion point), Im struggling to update the formula references correctly. I only see a way to shift formula refs for the entire column or row. Is there another way to update all formulas that reference a moved cell? workSheetHandle.moveCell( cellHandle, dest ); doesnt seem to update the formula refs - so Im trying to manually trigger an update. Nick |