https://bugs.documentfoundation.org/show_bug.cgi?id=89238
Bug ID: 89238
Summary: CALC is not updating cell after renaming/copying file
with different Name (filename)
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113240
--> https://bugs.documentfoundation.org/attachment.cgi?id=113240&action=edit
example CALC file, downsized to the main problem in tab "InfoTable"
when using ZELLE("filename") there seems to be a bug for other cells using this
content with another formula. The attached *.ods file is showing the
(potential) bug: in table "InfoTable" I use the file name with
ZELLE("filename") to extract the sole name (w/o path and Extension/table name
itself).
The extracted year out the file name (last 4 characters shall be interpreted as
year in this case) shall be calculated with =RECHTS(B4;4) where B4 already is
re-calculated with the correct name string.
Thes result stays the old one from the previous file.
Only when deleting the formula in B5, and re-typing the formula, the new
sub-string (year) will be calculated correctly.
I use LibreOffice 4.3.5.2 release, calc only, German Version on Windows 7 64
bit.
--
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