Created attachment 102497 [details]
Example of the input fields and failing calculation
Problem description: I have a template that I used in LO3 (and before that LO2 if I recall correctly) that uses input fields in a table. A line total is calculated by referencing the Column and Row like this: =<B5>*<C5>. Recently I have noticed that the calculations always returns 0 regardless of the value in B5 or C5.
I have an older machine with LO3.5 installed and there the exact same template and tests work 100%.
Steps to reproduce:
1. Create a table with at least 3 columns and 2 rows.
2. Create two input fields (Insert | Fields | Other | Functions | Input Field and type a reference) in A1 and B1 respectively
3. In C1 insert a formula (press F2) =<A1>*<B1>
4. Use <shift><ctrl><F9> to add values to A1 and B1.
5. Use <F9> to recalculate the formula in <C1>. The value stays 0.
Expected behavior: The answer, the value of A1 multiplied by B1 is expected in C1.
This still works in LO3.5 as mentioned before.
Operating System: Ubuntu
Version: 188.8.131.52 release
I see the same bug with version 4.4 on Windows 7. Analogous issue for Apache OpenOffice is https://issues.apache.org/ooo/show_bug.cgi?id=125228
Already fixed through the below commit. It's in 4.4 and 4.5 master, and given the imminent release of 4.4, a 4.3 backport probably isn't on the cards
Author: Oliver-Rainer Wittmann <firstname.lastname@example.org>
AuthorDate: Mon Jul 14 13:36:56 2014 +0000
Commit: Caolán McNamara <email@example.com>
CommitDate: Mon Jul 14 15:57:18 2014 +0100
Resolves: #i125228# correct consideration of InputFields...
in table cells are part of table formulas
(cherry picked from commit b384441c10475c9784eae3ea501afb22e0317468)