In LibreOffice releases up to and including 7.1, when I begin to enter a value on a row on a spreadsheet, if any previous row has a similar value, Calc fills in default suggested values until I type something that doesn't match. This is as expected. In LO 7.2.0.1, this does not happen. I verified this with a spreadsheet I use every day to log certain activities and noticed the flaw as soon as I installed 7.2. I just checked with my laptop, which is still running 7.0, and re-installed 7.1 on my desktop (where I ususally use it), and the prior behavior consistently occurs. To reproduce: Open a spreadsheet in Calc. Enter some data on a row. <cr> to the next row and begin to enter similar data that starts off the same. In 7.1 and earlier, Calc will fill in (selected) by default the previous entry until you type something that does not match. In 7.2, this does not occur - the row is blank and gets no prompted input. I believe this is also the default behavior in Excel (the 7.1 and earlier behavior).
No repro in Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ac80ec817eb07c77a51bc0729985a473c734182e CPU threads: 16; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL
I don't mean to be difficult, but how, exactly, is that going to help in 7.2? 7.3 is not due out until when? Can this be addressed for 7.2.1? Just asking, not challenging - I know you folks are busy and I would offer to help if I could. Thank you for your attention.
No repro with Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 36efb384a66b6dd645e0ae80fd7df68370a9dc8b CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: x11 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Seems to be fixed with dev version. Please could you test it with dev version? You can download it here: http://dev-builds.libreoffice.org/daily/master/ Thank you
For the most part this appears to be fixed in 7.3 dev. There was one column in which it did not appear to work still - I tried several of the preceding values and none of them filled in. I hesitate to supply the guilty spreadsheet as it contains extremely personal health information I would rather not give out. Since I am using 7.1 now I don't see the issue at all.
[Automated Action] NeedInfo-To-Unconfirmed
I am not sure if this additional information will assist, but in the event it does: on 7.2RC2, the matching works only once I enter enough characters that there is a SINGLE match to a previous cell. Previously the matching started as soon as I started typing, which was usually more helpful.
I can confirm this behaviour in LibreOffice 7.2.0.4 on Windows 7, Windows 10 and Manjaro Linux. The autofill function doesn't work, and also the picklist function. Doing the same action in an earlier version of LibreOffice (in this case verdion 7.0.6.4), these functions behave like it should.
(In reply to MR Zenwiz from comment #4) > For the most part this appears to be fixed in 7.3 dev. There was one column > in which it did not appear to work still - I tried several of the preceding > values and none of them filled in. I hesitate to supply the guilty > spreadsheet as it contains extremely personal health information I would > rather not give out. > > Since I am using 7.1 now I don't see the issue at all. You could sanitize the document: https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
I can no longer reproduce the problem with 7.3.3. Thank you for your attention.
Great, let's close as WFM, thanks for the update.
This atill fails in LO 7.4 - previously entered cell contents from the same column are still not recognized when entry is started. To reproduce: Enter some values into a spreadsheet. Add a few rows (or ven just one). Begin typing the same entry in an added row below the original - the pattern should be prompted as a repeat (highlighted). - This is what is not happening for me. LO 7.4.0, Xubuntu 22.04.1.
(In reply to MR Zenwiz from comment #11) > This atill fails in LO 7.4 - previously entered cell contents from the same > column are still not recognized when entry is started. > > To reproduce: > > Enter some values into a spreadsheet. > Add a few rows (or ven just one). > Begin typing the same entry in an added row below the original - the pattern > should be prompted as a repeat (highlighted). - This is what is not > happening for me. > > LO 7.4.0, Xubuntu 22.04.1. Is Tools - AutoInput checked? Note also that in 7.3 there was a change in how the suggestions appear: https://wiki.documentfoundation.org/ReleaseNotes/7.3#General_improvements_2 "Bash like autocompletion for Calc autoinput was implemented"
(In reply to Buovjaga from comment #12) : > > Is Tools - AutoInput checked? > Yes. > Note also that in 7.3 there was a change in how the suggestions appear: > https://wiki.documentfoundation.org/ReleaseNotes/7.3#General_improvements_2 > "Bash like autocompletion for Calc autoinput was implemented" I appreciate that. I was not aware of it and will explore this. However, that does not really apply here - when I type in the first character of a prior entry, nothing is prompted at all, and adding more promptable characters also has no effect. Thank you.
Please share a sample spreadsheet, and specific reproduction steps.
(In reply to Aron Budea from comment #14) > Please share a sample spreadsheet, and specific reproduction steps. I created a sample spreadsheet and this worked very nicely. I tried it out of my SS that was not working, and it works. I withdraw the bug and will resolve it as fixed. Thank you very much!
Glad to hear that. Let's use status WORKSFORME, since no known code fix is involved. Btw, it's not active for numerical data, perhaps that might've been the case for you, but it's just a guess.