Description: LibreOffice 7.6.0 Writer component not preserves relative distance of cells in formula after copying of formula into other cell in next lines ot the writer table. (LibreOffice 7.5.5 Writer component works OK). Steps to Reproduce: 1. Formulas in table (see sample file): <C2>=<A1>+<B1>; <C3>=<A2>+<B3>. 2. It is required to copy formulas in <C2> and <C3> cells to other rows of the table (in C column) so that the "relative distance" of the individual cells in the formula is preserved (works in LibreOffice 7.5.5). 3. Command sequence: Select <C2> to <C3> cells and Copy (CTRL+C), then select <C4> to <C10> and Paste (CTRL+V). Actual Results: In LibreOffice 7.5.5 result is OK In LibreOffice 7.6.0 result is wrong - formulas copied to next rows are not adjusted in relation to new "position" of the formula in the writer table. Expected Results: Behavior as in LibreOffice 7.5.5 - "relative distance" of the individual cells in the formula is preserved Reproducible: Always User Profile Reset: No Additional Info: Please see the demo file
Created attachment 189410 [details] Demo file for LOO 7.6.0 writer component error (tables)
Regression introduced by: author Bjoern Michaelsen <bjoern.michaelsen@libreoffice.org> 2023-03-04 02:18:58 +0100 committer Michael Stahl <michael.stahl@allotropia.de> 2023-03-14 10:25:01 +0000 commit 8a3dc12a13a3b9e99dbd5000ca6a1d541cf472f7 (patch) tree 54604d51a119eef82d8b9e059e1da7dac60f12e1 parent a224948ef44eadfb32aee002d5f0e9f10c9e47de (diff) remove support for TBL_BOXNAME TBL_RELBOXNAME in ChangeState Bisected with: bibisect-linux64-7.6 Adding Cc: to Bjoern Michaelsen
*** Bug 156905 has been marked as a duplicate of this bug. ***
*** Bug 157509 has been marked as a duplicate of this bug. ***
I think I know how to fix it
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0c008ab081aa5bbf53f8562e95e547deae5afc2e tdf#157132: restore behaviour for TBL_RELBOXNAME It will be available in 24.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-7-6": https://git.libreoffice.org/core/commit/0bd6d55a35688d92c411d3ba647c3fcf8de263b5 tdf#157132: restore behaviour for TBL_RELBOXNAME It will be available in 7.6.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Should a unit test be added? Thank you
(In reply to Óvári from comment #8) > Should a unit test be added? Thank you Please ignore comment as it looks like a unit test was added. Sorry for the noise.
*** Bug 158104 has been marked as a duplicate of this bug. ***
The same problem with columns. Say in <A3>: =<A1>+<A2> Copy <A3> in <B3>, and the cell references are not updated.
Created attachment 190993 [details] WriterTableDemoFile_original.odt
Created attachment 190994 [details] WriterTableDemoFile_test1.odt WriterTableDemoFile_test1.odt
I tested the behavior of the modified functionality with the following result: after opening the test document "WriterTableDemoFile_original.odt" and copying the formulas in the first table (DemoTable) in cells C2 and C3 (CTRL+C) to cells C4 to C10 (CTRL+V), the formulas in the second and third tables (DemoTable _LOO755 and DemoTable _LOO760) are also modified without "clicking" into these tables with the result "**Expression is Faulty**". The result is in the file "WriterTableDemoFile_test1.odt"
Tested with LibreOffice 7.6.3.2 (X86_64) build: https://git.libreoffice.org/core/+log/29d686fea9f6705b262d369fede658f824154cc0
(In reply to Rastislav Machel from comment #14) > I tested the behavior of the modified functionality with the following > result: > after opening the test document "WriterTableDemoFile_original.odt" and > copying the formulas in the first table (DemoTable) in cells C2 and C3 > (CTRL+C) to cells C4 to C10 (CTRL+V), the formulas in the second and third > tables (DemoTable _LOO755 and DemoTable _LOO760) are also modified without > "clicking" into these tables with the result "**Expression is Faulty**". > The result is in the file "WriterTableDemoFile_test1.odt" Hi Rastislav, Thanks for testing it. It seems that's a different issue caused by my commit 0c008ab081aa5bbf53f8562e95e547deae5afc2e. I'll create a follow-up ticket for that while keep this one closed
*** Bug 158716 has been marked as a duplicate of this bug. ***
*** Bug 158709 has been marked as a duplicate of this bug. ***
*** Bug 158674 has been marked as a duplicate of this bug. ***