Re: [libreoffice-users] Re: Bug saving as .xls format - loses a name reference

Hi :)
The 3.4.1 is really for early adopters only.  It 'should' say that on the 
downloads pages but seems to be missing at the moment.  


Please could you install the 3.3.3 instead, or alongside
http://wiki.documentfoundation.org/Installing_in_parallel

The 3.3.3 is the latest stable version and has a full years support.  The 3.4.1 
will soon be out-dated anyway.
Good luck and regards from
Tom :)




________________________________
From: Gérard Fargeot <gerard.fargeot@orange.fr>
To: users@global.libreoffice.org
Sent: Mon, 18 July, 2011 7:45:31
Subject: [libreoffice-users] Re: Bug saving as .xls format - loses a name 
reference


steelej wrote:
> LibreOffice 3.4.1 
> OOO340m1 (Build:103)
>
> I have a spreadsheet that I have been using for years. 
>
> This contains column where the formula in each  cell is similar to
> *"=gall_to_litre*F4/B*4"
>
>  *gall_to_litre* is defined as a global name and contains a number. 
>
> When I enter this formula the spreadsheet calculates correctly. When I
> save the spreadsheet as Excel 97 ... and then re-open it it loses the name
> reference (shows an error) and the formula then generates an error.
>
> When I save as ods format the formula remains intact.
>
> I have just converted from Open Office 3.2 to LibreOffice 3.4. It worked
> correctly in OO 3.2 and all previous versions back to 2.x. I have one
> machine where I still have Excel 2003 and would like to continue using
> .xls format.

It is a known (and annoying) bug :
https://bugs.freedesktop.org/show_bug.cgi?id=38113

--
View this message in context: 
http://nabble.documentfoundation.org/Bug-saving-as-xls-format-loses-a-name-reference-tp3176718p3178288.html

Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted