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.

Reply via email to