[tdf-discuss] Loss of formula in open document spreadsheet via excel

Readers,

Admittedly not using LO but the predecessor calc, recently realised
that if a spreadsheet is created using calc and saved in native ods
format, upon open using m$excel the formulas of a cell disappear to
leave only the total value? Yet if calc is used to create the same
spreadsheet and saved in m$excel 2007 (i.e. not xlsx but xls), formula
is retained?  For example:

calc

(sheet2.a1)
formula=sheet1.a1*sheet3.a2

Result (of sheet1a1=2 and sheet3a2=2) in xlsx:

(sheet2.a1)=4

in xls:

formula=sheet1!.a1*sheet3!.a2

Presumably m$ is at fault, but is it correct to advise people to save
odf spreadsheets in a legacy m$ format in order to keep formulas,
instead of using ods???


On 11/01/2011, discuss+help@documentfoundation.org
<discuss+help@documentfoundation.org> wrote:
> Topics (messages 4379 through 4405):
>
> [tdf-discuss] Re: Templates unavailable at templates.services.openoffice.org
>       4379 - David Nelson <commerce@traduction.biz>
>       4380 - Marc Paré <marc@marcpare.com>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4381 - Karl-Heinz Gödderz <LibreOffice@GuKK-Online.de>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4382 - drew <drew@baseanswers.com>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4383 - Michael Wheatland <michael@wheatland.com.au>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4384 - Andy Brown <andy@the-martin-byrd.net>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4385 - drew <drew@baseanswers.com>
>
> [tdf-discuss] Re: [Forum]How will the forum be organized?
>       4386 - Marc Paré <marc@marcpare.com>
>       4389 - Marc Paré <marc@marcpare.com>
>       4391 - Marc Paré <marc@marcpare.com>
>
> [tdf-discuss] Re: [Forum]How will the forum be organized?
>       4387 - David Nelson <commerce@traduction.biz>
>
> [tdf-discuss] Re: [Forum]How will the forum be organized?
>       4388 - sophie <gautier.sophie@gmail.com>
>
> [tdf-discuss] Download libreoffice button in new LibreOffice website
>       4390 - Christian Lohmaier <lohmaier+ooofuture@googlemail.com>
>
> [tdf-discuss] Links on LibreOffice.org/templates page
>       4392 - Marc Paré <marc@marcpare.com>
>
> [tdf-discuss] Re: Links on LibreOffice.org/templates page
>       4393 - Marc Paré <marc@marcpare.com>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4394 - Fabián Rodríguez <magicfab@member.fsf.org>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4395 - "Charles-H. Schulz" <charles.schulz@documentfoundation.org>
>
> [tdf-discuss] Download libreoffice button in new LibreOffice website
>       4396 - drew <drew@baseanswers.com>
>
> Off-topic (was: Re: [tdf-discuss] Download libreoffice button in new
> LibreOffice website)
>       4397 - Christoph Noack <christoph.noack@documentfoundation.org>
>
> [tdf-discuss] Suggestions for your future extensions
>       4398 - AndrewT <Roeplay@lavabit.com>
>
> [tdf-discuss] Re: [libreoffice-documentation] Queensland floods not near me
>       4399 - Michael Wheatland <michael@wheatland.com.au>
>
> [tdf-discuss] Re: LibreOffice version for Android platform
>       4400 - Tom Tasche <tomtasche@gmail.com>
>
> [tdf-discuss] A better idea for a download package.
>       4402 - Alan Reeve <techal@reeve36.plus.com>
>
> [tdf-discuss] [Forum]How will the forum be organized?
>       4403 - RGB ES <rgb.mldc@gmail.com>
>
> [tdf-discuss] Using free, open microblogging
>       4404 - Fabián Rodríguez <magicfab@member.fsf.org>
>
> [tdf-discuss] Re: LibreOffice version for Android platform
>       4405 - Nguyen Vu Hung <vuhung16plus@gmail.com>

-- 
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org
Archive: http://listarchives.documentfoundation.org/www/discuss/
*** All posts to this list are publicly archived for eternity ***