Bug 140703 - Calc: UI: fill: funny little fail with 'downfill', cells formatted as text filled in wrong direction - regression
Summary: Calc: UI: fill: funny little fail with 'downfill', cells formatted as text fi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: AutoFill
  Show dependency treegraph
 
Reported: 2021-02-27 17:55 UTC by b.
Modified: 2023-09-27 11:03 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description b. 2021-02-27 17:55:14 UTC
Description:
cells formatted as text are handeled wrong? 
or the yellow 'hint' how far you are is wrong? 

correct: 
take a cell formatted as 'number - standard' 
key in '-307', 
click the small black square bottom right corner of the cell and pull down some rows, 
observe a small yellow hint telling you which value will be filled in the last cell, 
release the mouse button and observe appropriate fill, 

fail: 
take a cell and format it to '@' - 'text', 
(do not! only change the format of the previously used cell, it will fail - to fail - unless you at least do a 'non changing edit' or similar as 'formatting doesn't adapt value' (a big pitfall imho)), 
key in '-307', 
click the small black square bottom right corner of the cell and pull down some rows, 
observe a small yellow hint telling you which value will be filled in the last cell, 
release the mouse button and observe opposite! of appropriate fill, (filling downwards, despite the yellow hint told 'upwards'), 


Steps to Reproduce:
see above description

Actual Results:
filled 'downwards' despite hint showed 'upwards', 

Expected Results:
filling upwards or correct hint


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 62dff2844b0bf1d1bcb8eb4d6db529ef4a31bee4
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: 

didn't test linux, assume 'all', 

didn't reset user profile as showing up in different installs,
Comment 1 Harshita Nag 2021-03-25 09:56:03 UTC Comment hidden (obsolete)
Comment 2 Xisco Faulí 2021-03-31 08:54:24 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 3 b. 2021-04-03 15:45:29 UTC
@xisco: sorry, sample sheet won't help, to see the yellow hint one needs to follow the description, imho it's simple, easy and clear, don't hesitate to ask if you run in any difficulties ... 

best regards, 



b.
Comment 4 raal 2022-01-19 13:09:01 UTC
Confirm Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 2761545769ef564b14fc8cd854a35c42bc269f02
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo
Comment 5 raal 2022-01-19 13:23:33 UTC
This seems to have begun at the below commit.
Adding Cc: to Eike Rathke ; Could you possibly take a look at this one?
Thanks
 2521c529b0124a0c4c500cf4a63e1e5ca4d5699c is the first bad commit
commit 2521c529b0124a0c4c500cf4a63e1e5ca4d5699c
Author: Jenkins Build User <tdf@pollux.tdf>
Date:   Mon Dec 4 12:00:10 2017 +0100

    source 87efbdb1ae5a73d081667e10f1571f1e523c1b9c

https://gerrit.libreoffice.org/c/core/+/45742
    tdf#105268 - Auto Fill: Fix The Next Value for 001-001-001
Comment 6 ady 2023-08-20 02:38:52 UTC
Still repro as of a recent LO Dev 24.2.