[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  |