https://bugs.documentfoundation.org/show_bug.cgi?id=163788
Bug ID: 163788
Summary: Table formula not evaluated if referenced cell
contains text
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Blocks: 122755
Created attachment 197452
--> https://bugs.documentfoundation.org/attachment.cgi?id=197452&action=edit
Example file from Writer
Attached example file contains some simple table formula in the second row,
which just refer to the cell above them.
If the referenced cell contains only a number, the formula updates when it is
changed.
If the referenced cell contains another paragraph or some text, the formula is
evaluated as 0.
In contrast, if the same is done in Word, Word parses the number out of the
text+number and updates the cell upon changing the referenced cells value
correctly.
1. Open attached file
2. In the table change numeric values in the first row
-> only the middle ones change is reflected in the second row.
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9e3803ae438ddcf91ec0e15431be379561d28ba6
CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=122755
[Bug 122755] [META] Formulae in Writer tables bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.