https://bugs.freedesktop.org/show_bug.cgi?id=76650
Priority: medium
Bug ID: 76650
Assignee: [email protected]
Summary: Cells not being recalculated and opening / pasting
forumula
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.3.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 96423
--> https://bugs.freedesktop.org/attachment.cgi?id=96423&action=edit
formula not recalculating on sheet "Prestation"
Hi,
I have a table where a simple calculation is done on each ligne
(=F131*G131*H131+M131)
- When copy/pasting the formula (from N130 to N131 for instance) the old result
(from N130) is kept, the formula does not recaculate based on new data (cells
F131, G131, etc)
- When changing data in cells (ex : F131, G131 etc) result is not recalculated
- When closing / opening the file: the result remains out of date (not
recaclculated)
The result is updated and recalculated only when the formula is modified :
modify a reference and press enter.
Then we get back to the previous state : nothing will get the result updated
copy/past, changing source data, closing opening the file.
I've had this problem for a time now maybe from LO 4.1 or 4.2 ...
ALSO (little extra for you :)
forumla in column R stoped woking at the same time and nothing will do to get
it back on track :
=SI(ESTVIDE(P112);"";SI(RECHERCHEV(P112;TableFacture;5;0)=0;"NON";RECHERCHEV(P112;TableFacture;5;0)))
You can check the file attached on sheet "Prestations"
thanks and good luck
REnaud
--
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
