Recalculating table in Writer

users
#1

In Writer I have a table with 2 rows and 2 columns.
In row 2 column 2 I have a formula adding the value in row 1 column 2 to the value in row 2 column 1 together showing the result in row 2 column 2.
When changing one of the input values row 2 col 2 is not updated unless I rewrite the formula in the cell. The cells are unprotected.
What am I to do getting Writer recalculating formulas in table cells in Writer if possible?

LibreOffice 5.4.1.2 (64 bits) on Windows 10.
Kolbjørn

#2

Hi. Is this a table inserted from calc or a native writer table.

#3

Den 23.10.2017 05:27, skreiv Steve Edmonds:

In Writer I have a table with 2 rows and 2 columns.
In row 2 column 2 I have a formula adding the value in row 1 column 2 to the value in row 2 column 1 together showing the result in row 2 column 2.
When changing one of the input values row 2 col 2 is not updated unless I rewrite the formula in the cell. The cells are unprotected.
What am I to do getting Writer recalculating formulas in table cells in Writer if possible?

LibreOffice 5.4.1.2 (64 bits) on Windows 10.
Kolbjørn

Hi. Is this a table inserted from calc or a native writer tableIt

It is a native Writer table made from menu Table -> Insert Table in Writer..
Kolbjørn

#4

[ALT][F12] [ibreOffice Writer][Common][Fields]
<http://nabble.documentfoundation.org/file/t493835/Geen_titel_5.jpg>

#5

Hi Kolbjørn,

In Writer I have a table with 2 rows and 2 columns.
In row 2 column 2 I have a formula adding the value in row 1 column 2 to
the value in row 2 column 1 together showing the result in row 2 column 2.
When changing one of the input values row 2 col 2 is not updated unless
I rewrite the formula in the cell. The cells are unprotected.
What am I to do getting Writer recalculating formulas in table cells in
Writer if possible?

Have tested this with LO 5.4.2.2 on OpenSUSE 42.2 64bit rpm Linux. Works
here as expected: automatic recalculation.

LibreOffice 5.4.1.2 (64 bits) on Windows 10.

First: Try to update to LO 5.4.2.2
Second: Try to start LO with a new user-profile (rename
%appdata%\libreoffice\4\user to start new creating of the profile)

If both doesn't work it will be a special bug aof the Windows-version of LO.

Regards

Robert

#6

Den 23.10.2017 12:48, skreiv Robert Großkopf:

Hi Kolbjørn,

In Writer I have a table with 2 rows and 2 columns.
In row 2 column 2 I have a formula adding the value in row 1 column 2 to
the value in row 2 column 1 together showing the result in row 2 column 2.
When changing one of the input values row 2 col 2 is not updated unless
I rewrite the formula in the cell. The cells are unprotected.
What am I to do getting Writer recalculating formulas in table cells in
Writer if possible?

Have tested this with LO 5.4.2.2 on OpenSUSE 42.2 64bit rpm Linux. Works
here as expected: automatic recalculation.

LibreOffice 5.4.1.2 (64 bits) on Windows 10.

First: Try to update to LO 5.4.2.2
Second: Try to start LO with a new user-profile (rename
%appdata%\libreoffice\4\user to start new creating of the profile)

If both doesn't work it will be a special bug aof the Windows-version of LO.

Regards

Robert

Yes, I had renamed my user-profile and was running the same settings as Jan suggested.
But today all works as normal. I do not know why or what I have done. The world of computers is strange :slight_smile: . So I do not file a bug rapport. I am not able to reconstruct the error.
Thank you for trying to help me.
Kolbjørn