Bug 89238 - CALC is not updating cell after renaming/copying file with different Name (filename)
Summary: CALC is not updating cell after renaming/copying file with different Name (fi...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-08 22:09 UTC by Frank
Modified: 2015-02-11 05:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
example CALC file, downsized to the main problem in tab "InfoTable" (44.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-08 22:09 UTC, Frank 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Frank 2015-02-08 22:09:03 UTC 
Created attachment 113240 [details]
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.
Comment 1 m_a_riosv 2015-02-09 01:43:16 UTC 
Hi Frank, thanks for reporting.

I can't reproduce with:
Win7x64
Versión: 4.3.6.2 Id. de compilación: d50a87b2e514536ed401c18000dad4660b6a169e
         http://dev-builds.libreoffice.org/pre-releases/win/x86/
Version: 4.4.0.3 Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Comment 2 Frank 2015-02-09 07:29:02 UTC 
Hi m.a.,

thanks for you fast response.
You are refering to LibreOffice 4.3.6.2 and 4.4.0.3 
Is it possible to check with release version 4.3.5.2?
==> I cannot find update/version 4.3.6.2 to try out if that verison fixed the (potential) bug.
Also, I do not want to install 4.4. since the version information still is recommending to use 4.3. version due to stability.
If you cannit confirm the problem after copying the file to another file like "Report_2018" on 4.3.6.2, you may tell me wheer I can get that version?

thanks for your help,
    regards,
           Frank
Comment 3 raal 2015-02-10 08:39:43 UTC 
(In reply to Frank from comment #2)

> If you cannit confirm the problem after copying the file to another file
> like "Report_2018" on 4.3.6.2, you may tell me wheer I can get that version?
> 
> thanks for your help,
>     regards,
>            Frank

Hello,
you can download from here:
http://dev-builds.libreoffice.org/pre-releases/win/x86/
It's pre release version.
Comment 4 Frank 2015-02-10 15:29:18 UTC 
Hello raal, m.a., all,

thanks for your support.
I updated all the related PC's now to 4.4.0.3.
The problem disappeared with the new version.
On 1 PC I kept 4.3.5.2 and can still reproduce the problem.
Then, I updated that 1 PC to 4.3.6.2 and the problem disappeared.

I will now update that system as well to 4.4.0.3, since that newer version is fixing a part of other problems I have.

QUESTION:
   (sincie i am new to bugzilla...) How can I close the bug report now?


thank you for your help,
       Frank