Ubuntu
libreoffice package

  1. Bug #775608
  2. Comment #28

Comment 28 for bug 775608

Revision history for this message
In , Moyon-davy (moyon-davy) wrote :

I'm not sure if it should be considered a new bug. But on LO 4.0.03 on osx, product has strange behavior with array:
if you type 2, 3 in A1, A2
and 2 , 2 in B1, B2
if you type =power(A1:A2,B1:B2) in C1 (and press ctrl+shift+enter), you get the good 2x1 array 4,3 in C1:C2
if you do =product(C1:C2) in C3 you get the good result 12
if you do everything in on shot =product(power(A1:A2,B1:B2)) (and press ctrl+shift+enter) you get 3 as a result.