Re: [libreoffice-users] Randomly lost sheet

On 14/06/15 10:38, Andrea Venturoli wrote:

> > Which version of MS Office was used to generate the files?

> Hard to tell... I'd have to ask my customer and I'm not sure she knows.
> It's even possible in some cases [Libre|Open|Neo]Office was used.
> In any case I believe they've been working for some time with
> LibreOffice 4.3 only, and I'm sure some of the files were last saved by
> LO 4.3 (Mac or Windows).

You should never generate XLSX files with LibreOffice, unless you need
to exchange them with MS Office users. In this case, you must save the
file in ODS format (more stable), and use XLSX only for
interoperability. With MS Office 2013 users, you can use ODS files.

> > You
> > have a choice between the following formats: ECMA OOXML for MS Office
> > 2007, Transitional OOXML for MS Office 2010, Transitional OOXML for MS
> > Office 2013, and Strict OOXML for MS Office 2010. Each file format has
> > peculiarities.

> Is there any way to tell by opening/unzipping/looking at the files?

Of course not, this is part of the lock in strategy applied to pseudo
standard formats. You can possibly understand it from the namespaces
(which are different, but undocumented, for every version).

-- 
Italo Vignoli - Marketing & PR
mobile +39.348.5653829 - email / jabber italo@libreoffice.org
hangout / jabber italo.vignoli@gmail.com - skype italovignoli
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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