https://bugs.documentfoundation.org/show_bug.cgi?id=137843
Bug ID: 137843
Summary: Calc cell update disfunction
Product: LibreOffice
Version: 7.0.0.2 rc
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: zef...@gmail.com
Description:
Relative cells don't auto update properly when the source cell is changed.
To replicate the problem do the following:
1. Enter 1 into cell A1
2. Pull down the lower right corner of cell A1 to do a series fill to fill 10
cells.
3. Enter 120 in cell B1. Enter =b1 in cell B3.
4. Copy cell B3 & paste it into cells B4 through B10
5. Enter =b1/a1 in cell C1
6. Copy cell C1 & paste it into cells C2 through C10
7. Change the value in B1 to 125 & press enter key
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will
not get auto updated as they should. Also notice, that the caluation results
of cells C4 through C10 are also not updated because cells B4 through B10 were
not updated.
Why is that auto update capability not working in the spreadsheet? It makes me
seriously consider whether or not more complex spreadsheets are not providing
me with accurate results when I make changes to input cells.
Can you fix this?
Thanks, D
Steps to Reproduce:
1. Enter 1 into cell A1
2. Pull down the lower right corner of cell A1 to do a series fill to fill 10
cells.
3. Enter 120 in cell B1. Enter =b1 in cell B3.
4. Copy cell B3 & paste it into cells B4 through B10
5. Enter =b1/a1 in cell C1
6. Copy cell C1 & paste it into cells C2 through C10
7. Change the value in B1 to 125 & press enter key
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will
not get auto updated as they should. Also notice, that the caluation results
of cells C4 through C10 are also not updated because cells B4 through B10 were
not updated.
Actual Results:
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will
not get auto updated as they should. Also notice, that the caluation results
of cells C4 through C10 are also not updated because cells B4 through B10 were
not updated.
Expected Results:
Notice cells B2 & B3 will only be updated to 125. Cells B4 through B10 will
not get auto updated as they should. Also notice, that the caluation results
of cells C4 through C10 are also not updated because cells B4 through B10 were
not updated.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.0.0.2.2 (x64)
Build: 8349ace3c3162073abd90d81fd06dcfb6b36b994
--
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
