Radoslaw Garbacz wrote: > Hello, > > This is my first post to this newsgroup, so at first I would like to > thank for the great work done with gnumeric - I find it a very usefull > tool with a very nice user interface. > > 1) I would like to ask about the possibility to address cells using > keywords such as:"last" (e.g. the last not empty), "first", "current", > etc., e.g. $A$1:$A:$last - is there a way to do it with gnumeric, or > maybe my problem is the academic one and such addressing is not needed.
try =sum(A:A) otherwise its a case of something like =sum(A2:A65536) as far as I know. > 2) When converting the format of a cell with value e.g. 5 from "general" > to "time" the value is always treated as the number of days - is there a > way to change it? I don't think so. Gnumeric stores time and dates as the number of days since jan 1 1900 With fractions being the time If you type 2.25 into a cell and format as d/m/yy h:mm you get 6am on jan 2, 1900 entering 6:00 into a cell, converts it to 0.25 and formats as time try it and change the format to number and you'll see the 0.25 > 3) Is there a way to reference the regular expression submatches (e.g. > with "sed" like syntax) to modify cells' values, e.g. to replace > "\([0-9]*\)" with "\1:00"? > I have found the way to use reqular expressions for search/replace, but > have not found the way to reference the submatches. Sorry, don't know that one either. Kind regards, Hal _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
