I have commited changes to make absolute references work. so now SUM($A1,$A2) works correctly. Yet to do for area refs, however.
In trying to make the changes, i found it difficult to extend ReferenceUtils in a clean manner. I did not want to be pushing multidimensional int arrays about (after all, this is not C :) So i have written two new classes, CellReference and AreaReference, that try to do what ReferenceUtil did, but in an object oriented manner. CellReference i have integrated, AreaReference i am yet to integrate with the rest of the code. One i have done that, i plan to remove ReferenceUtil. Thoughts? My next priority is bug 8757 .. i dont know why it is happening. Regards - Avik
