https://bugs.documentfoundation.org/show_bug.cgi?id=94680
Bug ID: 94680
Summary: Refresh Calculations Not working
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: x86-64 (AMD64)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 119176
--> https://bugs.documentfoundation.org/attachment.cgi?id=119176&action=edit
Spreadsheet exhibiting problems on Mac OS X 10.11
This is for LibreOffice Calc 5.0.2 running Mac OS X 10.11.0.
I created a column with non contiguous data to represent software upgrade
prices at variable lengths of months. I created several other columns that
would either sum or average the non contiguous data column. After creation,
every thing auto calculated as I would expect. I then grabbed and moved a
number in the non contiguous column down one column. The calculation columns
did not automatically refresh their results. I hit F9, still no refresh. I
choose the menu item Tools:Cell Contents:Recalculate, still no refresh. I
deleted the data and it did not refresh either automatically or with F9.
Re-entering data seemed to be the only way to refresh the formulae.
I copied the entire range after the refusing to refresh calculations problem
began, and the pasted range further down the sheet. It did not refresh the
formulae. Hit F9, still no refresh. Delete and reenter refreshed one column
(running total achieved with a SUM(B$11:B19) formula. Initial formula was
SUM(b$11:b11) and then filled down to end of range. The running average column
did not automatically refresh, refresh or update with F9, or refresh upon a
save, close and reopen.
Not trusting that a spreadsheet program will refresh results makes it
worthless. I am attaching the spreadsheet. The first range contains some
updated results from the re-entry of data. The second range was a result of
the copy and paste and move the data fiasco.
I will test the spreadsheet on my Windows 10 and Linux installs when I return
home.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
