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, [email protected] <[email protected]> wrote: > Topics (messages 4379 through 4405): > > [tdf-discuss] Re: Templates unavailable at templates.services.openoffice.org > 4379 - David Nelson <[email protected]> > 4380 - Marc Paré <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4381 - Karl-Heinz Gödderz <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4382 - drew <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4383 - Michael Wheatland <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4384 - Andy Brown <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4385 - drew <[email protected]> > > [tdf-discuss] Re: [Forum]How will the forum be organized? > 4386 - Marc Paré <[email protected]> > 4389 - Marc Paré <[email protected]> > 4391 - Marc Paré <[email protected]> > > [tdf-discuss] Re: [Forum]How will the forum be organized? > 4387 - David Nelson <[email protected]> > > [tdf-discuss] Re: [Forum]How will the forum be organized? > 4388 - sophie <[email protected]> > > [tdf-discuss] Download libreoffice button in new LibreOffice website > 4390 - Christian Lohmaier <[email protected]> > > [tdf-discuss] Links on LibreOffice.org/templates page > 4392 - Marc Paré <[email protected]> > > [tdf-discuss] Re: Links on LibreOffice.org/templates page > 4393 - Marc Paré <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4394 - Fabián Rodríguez <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4395 - "Charles-H. Schulz" <[email protected]> > > [tdf-discuss] Download libreoffice button in new LibreOffice website > 4396 - drew <[email protected]> > > Off-topic (was: Re: [tdf-discuss] Download libreoffice button in new > LibreOffice website) > 4397 - Christoph Noack <[email protected]> > > [tdf-discuss] Suggestions for your future extensions > 4398 - AndrewT <[email protected]> > > [tdf-discuss] Re: [libreoffice-documentation] Queensland floods not near me > 4399 - Michael Wheatland <[email protected]> > > [tdf-discuss] Re: LibreOffice version for Android platform > 4400 - Tom Tasche <[email protected]> > > [tdf-discuss] A better idea for a download package. > 4402 - Alan Reeve <[email protected]> > > [tdf-discuss] [Forum]How will the forum be organized? > 4403 - RGB ES <[email protected]> > > [tdf-discuss] Using free, open microblogging > 4404 - Fabián Rodríguez <[email protected]> > > [tdf-discuss] Re: LibreOffice version for Android platform > 4405 - Nguyen Vu Hung <[email protected]> > > > -- Unsubscribe instructions: E-mail to [email protected] Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
