Description: Date Data entry excess work. Exceed Excel here easily. One can only enter month/day and autofill this year. Add option in worksheet a default year, even a default month. An alternate better but slightly more calculated option, would be to assume last year used, last month used in the same column. This might come under an Autofill feature group. Thereby, by only typing the day of month, in a Date formatted column would yield a completed Month/Day/Year entry. Steps to Reproduce: Type Month and Day and Calc assumes this year, not the last year entered, even if entered 100 times. It makes you type every year that is not this year. You can change the computer date, only if you want to break internet pages and other things like date saved etc. Actual Results: You must type full date every field if not this year. Expected Results: Would be great if data entry remembered last year entered, last month entered in column. That way if you had different date groups in different columns you could have auto fill in each column. Reproducible: Always User Profile Reset: No Additional Info: Would be so cool if enter at the end of a row, could move down one row to the beginning of the left column to enter next row of data, without coding a form.
You add 13/1/19, 14/2/19 etc. but want to do just 13/1 and 14/2 expecting some intelligence of the conversion function that always takes the current year. Adding "intelligence" to this functions is doomed from the beginning. It's not totally unlikely that you enter two dates from the last year followed by today's year. Plus, what if you have 2019 left of the current cell and 2020 above, which is a very common scenario. And there are also plenty of option to deal with the issue: AutoFill, formulas, clipboard, use text format.. so resolving as WFM.
And if setting up properly Menu/Tools/Options/Language Settings/Languages - Date acceptance patron, I think works as expected. https://help.libreoffice.org/6.4/en-US/text/shared/optionen/01140000.html?DbPAR=SHARED#bm_id3154751
This is a feature request, not it works how I think it should. Let's say you couldn't escape from entering a date hundreds of times for last year. General tax work and accounting. You can't automate it as your reading it from a receipt. Or every January, when you enter all of the dates of receipts for your company for last December? How do you type just a month/day and not enter a year? How can you set up the date format to default to last month? How can you set up the date format to default to last month and last year? I'm going to hope that you didn't understand the repetitive answers to the very long form designed for a bug, but is also used for a feature request, but treated as a bug.
How do you set up Menu/Tools/Options/Language Settings/Languages - Date acceptance patron? For me with D/M/Y;D/M;D/ as Date acceptance patterns: 1/5 -> 01/05/20 1/ -> 01/05/20
(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.
(In reply to m.a.riosv from comment #4) > How do you set up Menu/Tools/Options/Language Settings/Languages - Date > acceptance patron? > > For me with D/M/Y;D/M;D/ as Date acceptance patterns: > 1/5 -> 01/05/20 > 1/ -> 01/05/20 From example cited below, so it Jan 2020, and I need to enter transaction dates for Dec 2019. This is a fairly annual occurrence. Entering 12/1 = 12/01/20 not 12/01/19 So it's tax time, bunch of transactions from last year, I need to document. It's 2020 and I must type ##/##/19 for every transaction date. I have changed the computer date in the past, but I need information from the web at the same time, so that starts breaking webpages cause the token dates don't match. Became too troublesome. Spent 2 hours trying to figure out how, finally just started typing...........Hard to believe with everyone using these spreadsheets as data holders it's not easier to fill in the blank. LibreOffice already fetches the date from the computer? no work around? If I could format a default, that would be great such as MM/DD/2019 Although I think more universally, remembering the last month typed/ last day typed /Last year typed kept as a default or the DD/MM/YY for the rest of the world.
(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 can use dd.mm.19 to fake the date. But 1.1. will still be converted to 1.1.2020 and just shown as 1.1.19.
If you don't need to calculate with a date then preceding an incomplete input with an ' apostrophe would force the input to text content, like '13/5 (or en-US) '5/13 Assigning a number format of @"/19" then would display that as 13/5/19 or 5/13/19 If you pre-format the cells with such text format @"/19" before input then you don't even need to (and must not) input the leading ' apostrophe. As said, this works only if you don't need to calculate with such "date".