https://bugs.documentfoundation.org/show_bug.cgi?id=115654
Bug ID: 115654
Summary: EDITING: Copied column/row labels reference wrong cell
until file is reloaded, Part 2
Product: LibreOffice
Version: 6.0.1.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Copied column/row labels reference wrong cell until file is reloaded.
Steps to Reproduce:
1. Make a new spreadsheet
2. enable Tools -> Options... -> LibreOffice Calc -> Calculate -> Automatically
find column and row labels
3. Enter these data into the first sheet:
A1: a
A2: 1
A3: 2
A4: 3
B2: ='a'
B2 now correctly shows 1 because it references A2.
4. select B2:B4
5. press Ctrl+D for Fill Cells Down.
alternative steps:
4'. go to B2
5'. drag the fill handle to B3 and B4
alternative steps:
4''. go to B2 and press Ctrl+C
5''. select B2:B4 or B3:B4 and press Enter or Ctrl+V
Actual Results:
B3 and B4 wrongly also show 1 because they also reference A2.
Steps 4'' and 5'' only produce the bug in the first sheet.
Expected Results:
B3 should reference A3 and show 2.
B4 should reference A4 and show 3.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
When you save and reload the file it is correct.
Similar to the fixed bug
https://bugs.documentfoundation.org/show_bug.cgi?id=105245
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:56.0) Gecko/20100101
Firefox/56.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
