Bug 90132 - Refresh problem of linked cells
Summary: Refresh problem of linked cells
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-20 17:18 UTC by SI Albertville
Modified: 2021-12-03 07:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
tableau avec les 2 feuilles de calcul (9.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-20 17:18 UTC, SI Albertville 		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 SI Albertville 2015-03-20 17:18:32 UTC 
Created attachment 114215 [details]
tableau avec les 2 feuilles de calcul

Bonjour,

Problème rencontré :
certaines formules ne se mette pas à jour si la donnée source provenant d'une autres feuilles de calcul, est effacé (vide). Ce problème n'apparait pas au sein d'une même feuille de calcul.

Cela ne se produit pas toujours : par exemple la cellule A1 ne semble pas avoir ce problème !

Exemple :
dans "Feuille 1", tableau de A1 à A15 contenant les valeurs 1 à 15
dans "Feuille 2", A1=Feuille1.A1. copier la formule de A1 à A15

positionnez vous sous Feuille1.A1, supprimer la valeur avec la touche "suppr"
positionnez vous sous Feuille1.A3, supprimer la valeur avec la touche "suppr"

j'obtiens
Feuille1.A1=""
Feuille1.A2="2"
Feuille1.A3=""
...
et 
Feuille2.A1="0"
Feuille2.A2="2"
Feuille2.A3="3" au lieu de "0" !BUG

si je met 0 dans Feuille1.A3, Feuille3.A2="0"
si je fais un collé d'une cellule vide dans les cellules Feuille1.A12:A13, Feuille2.A12:A13="0"

Si j'enregistre le fichier et que je l'ouvre de nouveau, les cellules sont bien mise à jour.
Comment 1 Roman Kuznetsov 2015-03-20 17:49:30 UTC 
If possible, move it into English
Comment 2 A (Andy) 2015-03-21 08:16:32 UTC 
@Bug Reporter: Please correct if I explained/translated it not correctly.


Reproducible with LO 4.4.1.2, Win 8.1.

Problem:
Some values are not updated if they are linked to another sheet and if the base value there is deleted.  This does not happen if they are linked within the same sheet.  It only happens if they are linked to another sheet.

Steps to Reproduce:
1. Open CALC
2. In Sheet 1 write in the cells A1 to A15 the numbers 1 to 15.
3. Insert a second sheet.  In this Sheet 2 link the cells A1 to A15 to the corresponding cells in Sheet 1 (-> "=Sheet1.A1" to "=Sheet1.A15").
4. Go to Sheet 1 and delete the numbers in cell A1 and A3.
5. Now go to Sheet 2

Result: In Sheet 2 you have 0 in cell A1, but still 3 in cell A3, although the 3 in cell A3 in Sheet 1 was deleted (-> Bug).

6. In Sheet 1 select for instance cell A16 and A17 and copy them (Note: they are empty) to the cells A12:A13 (overwrite the entries).
7. Go to Sheet 2.

Result: The cells A12 and A13 are updated correctly.

8. Save the file and reopen it.

Result: Now everything is fine (updated) in Sheet 2 and cell A3 also shows 0.


Alternatively, you can also open the attached file and delete there in Sheet 1 (Feuille1) the entries in cell A1 and A3.
Comment 3 tommy27 2016-04-16 07:25:54 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2017-05-22 13:27:52 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2019-12-03 14:34:34 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2021-12-03 04:36:18 UTC Comment hidden (obsolete)
Comment 7 SI Albertville 2021-12-03 07:52:54 UTC 
Version: 7.1.7.2 (x64) / LibreOffice Community
Build ID: c6a4e3954236145e2acb0b65f68614365aeee33f
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded

Thank you