Summary: | Set Default Year for data entry with options | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | raymondm2 |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | REOPENED --- | ||
Severity: | enhancement | CC: | buzea.bogdan, erack, heiko.tietze, himajin100000, miguelangelrv, xiscofauli |
Priority: | medium | ||
Version: | 3.3.0 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108252 |
Description
raymondm2
2020-02-29 00:23:59 UTC
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". |