https://bugs.freedesktop.org/show_bug.cgi?id=61908
--- Comment #3 from [email protected] --- LO 4.0.1.2 does not fix this issue for me (running on ubuntu 12.04), though there is a slight change compared to LO 3.5.7.2. Let me give you the specifics of my example again: Cell A1: 1 Cell B1: 2 Cell C1: 3 Cell A2: 4 Cell B2: 5 Cell C2: 6 Cells E1:E3 2.8, 3.5 and 4.7 respectively. Save as .ods, and re-open: values in cells E5 and E6 and 23.9 and 56.9 respectively. For either cell E5 or cell E6, the formula bar displays (correctly) {=MMULT(A1:C2,E1:E3)} This was fine in both LO 3.5.7.2 and LO 4.0.1.2. Save as .xlsx, and re-open: 1. Under LO 3.5.7.2, values in both cells E5 and E6 were 23.9. Formula bar gives =MMULT(A1:C2,E1:E3) (note the absence of curly braces) in cell E5, and =E5 in E6. 2. Under LO 4.0.1.2, values in cells E5 and E6 are 23.9 and 56.9 respectively. However, the formula bar gives the same behaviour as under LO 3.5.7.2, indicating that this is no longer an array formula (due to the absence of curly braces). Moreover, suppose I change the entry in cell C2 from 6 to 7. This should have no effect on the value in cell E5, but it should change the value in cell E6 to 61.6. This happens for the .ods file. However, making this change in the .xlsx file, the entry in cell E6 changes to 23.9. In other words, as soon as the spreadsheet recalculates, the entry is incorrect under LO 4.0.1.2. On 03/30/2013 04:36 AM, [email protected] wrote: > > *Comment # 2 <https://bugs.freedesktop.org/show_bug.cgi?id=61908#c2> > on bug 61908 <https://bugs.freedesktop.org/show_bug.cgi?id=61908> from > A <mailto:[email protected]> * > I could not reproduce it with LO 4.0.1.2 (Win7 Home, 64bit). > But is this a misunderstanding from my side, what should be inserted in cell > E6? > > Does this issue still persist for you with LO 4.0.1.2? > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. > -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
