*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! This works like expected, however: =SUM($A$1:B1) OpenOffice.org does not change this formula. *What I want to do?* I want one column that contains the "average fuel consumption so far" of the values in other columns. "SUM($A$1:A1)" is only a part of the formula. The real formula looks something like this: =IF(OR(F1="";G1="");"";100*SUM($F$1:F1)/SUM($G$1:G1)) Column G contains by how much fuel I filled the car with in dm³ and the F column contains how many km I drove since last time I filled it up (resetting the trip meter every time). When I copy that formula to the next row, it will look like this: =IF(OR(F2="";G2="");"";100*SUM($F$1:F2)/SUM($G$1:G2)) which makes sense, doesn't it? The first formula will, after I entered it, immediately be converted to: =IF(OR(F1="";G1="");"";100*SUM($F$1:$F$1)/SUM($G$1:$G$1)) which is pretty useless. *Is there a workaround?* Yes, of course. Just enter the second row, then copy it to the first row. Strang enough, now the first row isn't changed! It is now possible to copy to any row, at least if the second row is the source. *Why do I write this?* I just thought I should see if someone happens to know if this is a bug or a feature. What good could possibly come out of this behaviour? If no one can tell me, I guess I'll send a bug report, if there isn't one already. Johnny Rosenberg
