kelredd/osheet — Issue #14: resolve cell references in formulas
Author: kelredd
Created: 2011-11-17 15:40:01+00:00
State: open

(from user naleksi)
Hello!

Thanks for including the patch. I needed formulas so I thought maybe others need it too.

While changing the Wiki to correspond with the new cell attribute, it occurred to me should there be means to refer to cells in formulas in osheet that get resolved when being serialized.

ie. how about having

cell { meta :ref => "#the_other_cell" ; data 122 }
cell { meta :ref => "#plus_one" ; data 1 }
cell { formula "=#the_other_cell + #plus_one" }

yielding cell.formula => "=RC[-2]+RC[-1]" in xmlss write.

I guess there might be already means to do this in "excel side", ie. name cells and refer to them in formulas. I'm not sure if that works well if you need to generate formulas for cells in columns, or rows, or areas.

Well, just a thought to think about.

Thanks again for a great little library!