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 tree / graph
 
Reported: 2015-03-02 04:24 UTC by ematchmail
Modified: 2023-06-18 03:14 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
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 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)
Comment 12 QA Administrators 2023-06-18 03:14:36 UTC 
Dear ematchmail,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug