[Libreoffice-ux-advise] [Bug 131020] Set Default Year for data entry with options

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue May 12 03:50:49 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=131020

raymondm2 at mtaonline.net changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WORKSFORME                  |---
             Status|RESOLVED                    |REOPENED

--- Comment #7 from raymondm2 at mtaonline.net ---
(In reply to Heiko Tietze from comment #5)
> (In reply to raymondm2 from comment #3)
> > How do you type just a month/day and not enter a year?
> 
> Format the row as dd.mm., enter your dates, and if needed calculate in
> another column the current date with "=a1-365". Or use autofill. Or use one
> column for the day and another for the month.

Solution to not entering the year is three columns to combine, or displacing
columns in the spreadsheet to run a math, to copy and paste as data in same
column take me longer than typing the date. Your skills may be far superior to
mine. If the page is long enough say 4 pages plus, maybe for me, still for me
pretty cumbersome.  Is this something you could teach easily to a middle age
secretary?  Just think about the facial expressions after you leave..

What if the spreadsheet could remember the last year typed, last month, maybe
even last day, I have many days with many transactions.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list