On 10/23/2009 02:20 PM, Cor Nouws wrote: > Hi Brian, *, > > Brian McKee wrote (23-10-2009 23:11) >>> Brian McKee schrieb: >>>> If I email a pretty simple spreadsheet from a Windows XP machine >>>> running OO3.1.1 to a Mac running OO3.0.0, the formulas end up mangled. >>>> e.g. a simple >>>> =SUM(F4:F6) >>>> formula ends up looking like >>>> of:=SUM([.F4:.F6]) >> On Fri, Oct 23, 2009 at 4:45 PM, Franz Wein <[email protected]> wrote: >>> I believe, you don't have a mailing problem - it's a problem form oo3.1 to >>> oo3.o >>> The developes changed the format in calc and you have to store the calc in >>> an older version from calc (or as xls). then you are abel to open in 3.o >>> (with all formulas) >> >> Thanks for your comments Franz. I tried opening the same spreadsheet in OO >> 2.4 >> on a linux box and it works fine, so I don't think that is it in this case. > > Indeed. The changes in Calc formulas are not that big, that basic > formulas as SUM(F4:F6) behave different. > > Is there someone else out with OO3.0.0 on a Mac, so that we can try to > reproduce? > > Cor >
Cor, the result looks like the raw xml formula from this bug attachment: <http://www.openoffice.org/nonav/issues/showattachment.cgi/57118 <Cell ss:Formula="of:=SUM([.A1:.A3])"> <Data ss:Type="Number">16.6</Data> </Cell> See: http://www.openoffice.org/issues/show_bug.cgi?id=94261 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
