In LibreOffice Calc 4.4.1.2 (English) in Ubuntu 14.04, 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:
- In cell C1, enter “=CONCATENATE(A1,B1)”
- Open the Form Controls toolbar (under View on the menu) and use it to put a Text Box on the spreadsheet
- Right click the Text Box and click on “Control…” to open the Control Properties dialogue
- Click on the Data tab
- Type “C1” in the box to the right of “Linked Cell”
- Click the Design Mode On/Off button on the Form Controls toolbar
- Type something in cells A1 and B1. C1 updates and so does the Text Box
- Type something different in cells A2 and B2
- Copy cells A2 and B2
- Paste into A1 (and B1)
Cell C3 updates, but the Text Box does not (unless you paste a second time).
It worked in the last version of LibreOffice I used. Text boxes based on numerical operations/functions seem to work still (i.e., the Text Box updates after pasting new information that the function uses).
It seems as though the Text Box is updated before cell C3 is updated (unless there is a numerical calculation or formula in it).
Is there a new setting I need to change in version 4.4?
Edit:
rost152
Thank you for the compliment and suggesting an answer to the problem. Unfortunately, your solution did not work for me.
AutoreCalculate was checked. Also pressing F9 or clicking Tools > Cell Contents > Recalculate does not change the contents of the Text Box.
Actually, I just retested with making a Text Box that is tied to a cell (C1) that contains “=A1+B1” in the same way as I described above in the CONCATENATE example. The same thing occurred.
The result cells (C1, in both cases) do recalculate on their own. Also the Text Boxes update to show the value in cell C1 when the value in cell A1 or B1 are changed by typing.
The Problem
If I paste new values in cell A1 and/or B1,
- Only the value in cell C1 changes (because it is automatically recalculated).
- The value displayed in the Text Box is not updated.
The Text Box is updated if I paste the new values in a second time.
The previous version of Calc (that came with Ubuntu 14.04 originally) did not have this problem.
I tried to attach an example file, but apparently, I need to have more than three “points” to be allowed to upload files. Sorry.
Also I tried replying in a comment, but there were too many characters.