Re: View formulas in R1C1 format?



I think that the full cols/rows is just C1 for all of the first column and R3 for all of the third row. I do not have a copy of excell to check with at the moment. Can not remember about the range.

Jody Goldberg wrote:
On Sun, May 23, 2004 at 11:10:53AM -0700, J. Marhaus wrote:

Hi all -
I'm new to Gnumeric and was wondering how to display formulas in R1C1
style. Under Excel this is done by setting the "Options->General->R1C1
reference style" button. Is there an equivalent switch in Gnumeric?


It would be fairly simple functionality to add, but it is not there
currently.  The only somewhat tricky part would be parsing R1C1
style references.  I left of implementing that because I had not
looked at how to represent ranges or full cols/rows

    - A1:B2    =>  R1C1:R2C2 ?
    - A:A      =>  C1:C1 ?

Everything else
    - adding the ui toggle
    - persisting the toggle state
    - a hook to change the expression rendering

all exist and could easily be extended
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]