On 12/19/2008 11:03 AM, Johnny Rosenberg wrote: > 2008/12/19 Jean-Baptiste Faure <[email protected]> > >> Le 17.12.2008 17:53, Johnny Rosenberg a écrit : >> >>> *What happens?* >>> >>> This worked in 2.4.1: >>> >>> Write this in a cell, for example in B1: >>> >>> =SUM($A$1:A1) >>> >>> Hit ↵ (Enter) >>> >>> Go back to the cell and look at its formula. OpenOffice.org has changed >>> the >>> formula, without asking me, to: >>> >>> =SUM($A$1:$A$1) >>> >>> This is ridiculous! >>> >>> >> I confirm the problem for OOo 3.0 under Ubuntu. >> But it works well in OOO300_m13 so it seems the issue will be fixed in OOo >> 3.0.1. >> >> Regards >> >> -- >> Jean-Baptiste Faure > > Thanks for the info! I will not report it then. > Regards > J.R.
Works in m12 and OpenOffice.org 3.0.1 Release Candidate 1 (build OOO300_m14) as well. (RC1 should be available on the extended mirrors by tomorrow). One thing that I find is, if I enter: =SUM($A$1:A1) in the B1 cell it works just fine (I just copied & pasted from your post). However, if I enter the same in the input bar, the data in the cell becomes text: =SUM($A$1:A1). But if I first click the = icon (function icon) on the input bar and then past: SUM($A$1:A1) if works properly. Can you no longer just enter '=' followed by a function in the input bar? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
