On 02/22/2020 08:04 AM, Russell Senior wrote:
Don't copy the whole column, copy a block of cells.
I got that far.
I don't know gnumeric, so I can't give you the exact commands,
Any spreadsheet that is in Debian repository is fine.
but move to one end of your range, hold the shift key and move
the other end of your range.
Searching for end of data manually is at best AWKWARD.
I may have a few hundred more rows of data eventually.
I want the spreadsheet to do the repetitive stuff.
home and end keys might help.
That suggests your preferred program can do what I want.
What program do you use? I'll try it.
This is all guessing. Take with grain of salt.
Thanks
On Sat, Feb 22, 2020 at 4:40 AM Richard Owlett <[email protected]> wrote:
I've not used a spreadsheet in THIS *CENTURY*.
I have forgotten much.
I'm using Gnumeric on Debian and have successfully imported ~280 lines
of data.
The first column is a date.
https://help.gnome.org/users/gnumeric/stable/gnumeric.html says:
Gnumeric stores the value as the number of days since the first day
of January in 1900.
I want the second column to display days since 1/1/2008.
Should be simple :<
Just enter the formula "A1 - 35921" in cell B1,
then copy column B.
*BUT* Gnumeric then asks if I really want to copy it >65000 times.
Of course not.
I only have ~280 lines in *MY* view.
Is there a simple way?
TIA
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
