Don't copy the whole column, copy a block of cells. I don't know gnumeric, so I can't give you the exact commands, but move to one end of your range, hold the shift key and move the other end of your range. home and end keys might help. This is all guessing. Take with grain of salt.
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 > _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
