Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2014-02-07 Thread e-letter
On 07/02/2014, Dennis E. Hamilton wrote: > I no longer follow these lists, so I'm of limited help. > > If gnumeric produces an ods file, Excel 2013 should attempt to read it. > However, the format you gave as an example is not ODF and I am doubtful. I > don't have gnumeric, so I can't check that

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2014-02-06 Thread Tom Davies
Hi :) I think they fixed the problem in MS Office 2013. Prior to that for spreadsheets in ODF formats MS Office would apparently lose the formula and leave values as a fixed. Errr, i think there is a lot more there but i only managed to make sense of the last paragraph. Hopefully others can help

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2014-02-06 Thread e-letter
On 06/02/2014, e-letter wrote: > > As an alternative, can anyone confirm if formulae are kept in xml > formatted spreadsheets, for example of gnumeric or LO calc xml > spreadsheets are imported by m$? For example simple formula from > gnumeric: > ... > > 3 > 5 > 3 >

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2014-02-06 Thread e-letter
From: James Knott [mailto:james.kn...@rogers.com] > Sent: Wednesday, January 23, 2013 05:20 > To: LibreOffice > Subject: Re: [libreoffice-users] how to tell m$ about ods formula behaviour > failure > > e-letter wrote: >> after opening in m$ excel 2010 (yes, m$ can open ods >

RE: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-24 Thread Dennis E. Hamilton
om: e-letter [mailto:inp...@gmail.com] Sent: Thursday, January 24, 2013 01:02 To: dennis.hamil...@acm.org Cc: James Knott; LibreOffice Subject: Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure On 23/01/2013, Dennis E. Hamilton wrote: > ODF 1.0/1.1 did not specify a

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-24 Thread James Knott
Tom Davies wrote: Hi:) Yes. With regards to paragraph 1 with the amendment that i think you mean MSO 2010 rather than the non-existent MSO 2012. There is a version for Mac called 2011 but that is really just 2010 redone for Mac and it takes them about a year to do that. MSO just doesn't dev

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-24 Thread Tom Davies
lf, for your own use, for your main copy of the file and then share by first taking a snapshot of your file in MS format = "Save as MS Xp format" Regards from Tom :)  >____________________ > From: e-letter >To: dennis.hamil...@acm.org >Cc: James Knott ; LibreOffice > >Sent: Thur

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-24 Thread e-letter
On 23/01/2013, Dennis E. Hamilton wrote: > ODF 1.0/1.1 did not specify a standard for spreadsheet formulas. Formulas > were left implementation-specific. Microsoft did not support the > OpenOffice.org-specific formulas. Instead, they used Excel-specific > formulas in ODF 1.1. On input of a not-

RE: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-23 Thread Dennis E. Hamilton
t: Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure e-letter wrote: > after opening in m$ excel 2010 (yes, m$ can open ods > spreadsheets, so use that format please!!!) , the formulas were lost, > leaving only the result values in the spreadsheet cells. > >

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-23 Thread James Knott
e-letter wrote: after opening in m$ excel 2010 (yes, m$ can open ods spreadsheets, so use that format please!!!) , the formulas were lost, leaving only the result values in the spreadsheet cells. Instead of reporting another erroneous LO bug, does someone know how to forward this error with m4 e

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-23 Thread Tom Davies
Hi :) MS Office uses  ODF 1.1 not 1.2.  The 1.1 had some troubles with retaining formulas.  The answer in LibreOffice and other office programs is to use the 1.2 which they have mostly been using for many years now.  The MSO answer is to buy their new MSO 2013.  I thought the original problem

Re: [libreoffice-users] how to tell m$ about ods formula behaviour failure

2013-01-23 Thread Regina Henschel
Hi "e-letter", e-letter schrieb: Readers, Despite the opinion of the original poster (http://bugs.freedesktop.org/show_bug.cgi?id=38113), the loss in information is not the fault of LO, but m$, who claim not to support such compatibility (http://office.microsoft.com/en-za/excel-help/difference