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

Radoslaw Garbacz wrote:

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.

otherwise its a case of something like
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,

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