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.
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
I confirm it with Version: 7.3.0.0.alpha0+ (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?
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.
The bug is still present in this version of LO: Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: df3b95a39472e18ea8acdaae447b7176e37a9256 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: threaded