Bug 144336 - RTF-TABLE: Formula with bookmark changes to zero
Summary: RTF-TABLE: Formula with bookmark changes to zero
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: RTF-Tables
  Show dependency treegraph
Reported: 2021-09-06 16:30 UTC by Dave McKellar
Modified: 2021-09-24 04:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

RTF doc made with Microsoft Word with a bookmark and a formula that uses the bookmark (8.38 KB, application/msword)
2021-09-06 16:30 UTC, Dave McKellar

Note You need to log in before you can comment on or make changes to this bug.
Description Dave McKellar 2021-09-06 16:30:42 UTC
Created attachment 174830 [details]
RTF doc made with Microsoft Word with a bookmark and a formula that uses the bookmark

On LibreOffice Writer I have a simple formula: =subtotal
where subtotal is a bookmarked table cell.
When I click on the cell the formula changes to zero.
Comment 1 Dave McKellar 2021-09-06 16:35:42 UTC
To Reproduce:
- Load the attached RTF doc (made in Microsoft Word)
- Notice document has two table cells with "100"
- First is bookmarked as subtotal
- Second is a simple formula of =subtotal
- Click on the first cell
- The second cell changes to "0"

What should happen:
- The second cell should not change from this action
Comment 2 Dieter 2021-09-22 06:43:29 UTC
I confirm it with

Version: (x64) / LibreOffice Community
Build ID: b733ccad171e6def8fbdb93f31875dfdea47bdc6
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: CL

You can click in any cell to get that result. Same result, if you delete bookmark.

Dave, a rtf file without bookmarks works as exepcted?
Comment 3 Dave McKellar 2021-09-23 13:57:33 UTC
In my experience RTF files load fine into LibreOffice.
I am going to do more tests with formulas.  Of course, lots of formulas reference bookmarks.  Its like referencing another cell in a spreadsheet so if bookmarks don't work basically formulas don't work.