Bug 89773 - Text Boxes based on cells with formulas do not update after pasting new data in cells the formula uses (hard recalc needed)
Summary: Text Boxes based on cells with formulas do not update after pasting new data ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Textbox
  Show dependency treegraph
 
Reported: 2015-03-02 04:24 UTC by ematchmail
Modified: 2021-06-17 15:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Follow the instructions in this simple Calc file to see the Text Box update problem. (13.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-03-02 04:24 UTC, ematchmail
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ematchmail 2015-03-02 04:24:09 UTC
Created attachment 113807 [details]
Follow the instructions in this simple Calc file to see the Text Box update problem.

The problem occurs in LibreOffice Calc 4.4.1.2 (English) in Ubuntu 14.04 and was verified in Windows 7/64 & Version: 4.4.1.1 by someone on http://ask.libreoffice.org/en/question/46981/text-box-is-not-updating-after-a-paste-in-libreoffice-calc-version-44/?comment=47008#comment-47008 after I first reported it.

Text Boxes do not update text information based on formulas (such as CONCATENATE or the NUMBERTEXT Add-in) after pasting new data into the cells upon which the formula is based.

Here is an example to make the problem more clear:

1. Make sure AutoCalculate is checked under Tools > Cell Contents
2. In cell C1, enter a formula such as “=CONCATENATE(A1,B1)” or “=A1+B1”
3. Open the Form Controls toolbar (under View on the menu) and use it to put a Text Box on the spreadsheet 
4. Right click the Text Box and click on “Control...” to open the Control Properties dialogue 
5. Click on the Data tab 
6. Type “C1” in the box to the right of “Linked Cell” 
7. Click the Design Mode On/Off button on the Form Controls toolbar 
8. Type something in cells A1 and B1. C1 updates and so does the Text Box 
9. Type something different in cells A2 and B2 
10. Copy cells A2 and B2 
11. Paste into A1 (and B1) Cell C3 updates, but the Text Box does not (unless you paste a second time or type “Ctrl + Shift + F9”).

It worked in the last version of LibreOffice I used.

It seems as though the Text Box is updated before cell C3 is updated, because if I:

1. paste a second time or
2. type “Ctrl + Shift + F9”

the Text Box updates.  Those are the only ways I have found to make the update happen.

I attached an example file to demonstrate the problem.
Comment 1 raal 2015-03-02 09:19:49 UTC
(In reply to ematchmail from comment #0)
> Created attachment 113807 [details]

> 
> It worked in the last version of LibreOffice I used.
> 
Please specify last known good version.

I can confirm with LO 4.4.0.3, win7
Comment 2 ematchmail 2015-03-02 15:44:09 UTC
I believe the last version I used that worked was 4.2.4.
Comment 3 ematchmail 2015-03-02 15:46:12 UTC
Clarification: I believe the last version of LibreOffice I used in which the Text Box update worked correctly was 4.2.4.
Comment 4 tommy27 2016-04-16 07:25:39 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2017-05-22 13:27:23 UTC Comment hidden (obsolete)
Comment 6 Thomas Lendo 2018-03-17 22:27:51 UTC
I cannot confirm with

Version: 6.1.0.0.alpha0+
Build ID: df4253787e9f6ba4951ee2f416ec65937b2c8ddf
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-03-16_23:54:15
Locale: de-DE (de_DE.UTF-8); Calc: group
Comment 7 Vivek Ydv 2018-08-13 06:30:59 UTC Comment hidden (spam)
Comment 8 QA Administrators 2019-08-19 06:57:06 UTC Comment hidden (obsolete)
Comment 9 Dona 2019-08-29 05:44:39 UTC Comment hidden (spam)
Comment 11 spam 2021-06-17 14:36:15 UTC Comment hidden (spam)