[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 BogdanB changed: What|Removed |Added Blocks||108252 CC||buzea.bog...@libreoffice.or ||g Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108252 [Bug 108252] [META] Cell-related bugs and enhancements (including formatting) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 --- Comment #9 from Eike Rathke --- 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". -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 Heiko Tietze changed: What|Removed |Added CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Keywords|needsUXEval | --- Comment #8 from Heiko Tietze --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 raymon...@mtaonline.net changed: What|Removed |Added Resolution|WORKSFORME |--- Status|RESOLVED|REOPENED --- Comment #7 from raymon...@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 the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 --- Comment #6 from raymon...@mtaonline.net --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 --- Comment #5 from Heiko Tietze --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 m.a.riosv changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |WORKSFORME --- Comment #4 from m.a.riosv --- 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 raymon...@mtaonline.net changed: What|Removed |Added Ever confirmed|0 |1 Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- --- Comment #3 from raymon...@mtaonline.net --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 --- Comment #2 from m.a.riosv --- 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/0114.html?DbPAR=SHARED#bm_id3154751 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 Heiko Tietze changed: What|Removed |Added CC||er...@redhat.com Resolution|--- |WORKSFORME Status|UNCONFIRMED |RESOLVED --- Comment #1 from Heiko Tietze --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 Buovjaga changed: What|Removed |Added Whiteboard| QA:needsComment| Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 131020] Set Default Year for data entry with options
https://bugs.documentfoundation.org/show_bug.cgi?id=131020 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs