Re: cells' references (last, first, etc.)? ; cells' modifications ; cells' time format from a number to hours not days?

[Hal Ashburner <hala cse unsw edu au>]

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