Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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 ***

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.