.xlsx libre issue

users
#1

I have a .xlsx file which once had 9 tabs, that, after a save in libre 3.3.3 ... now it seems to have one. needless to say, the formatting is jacked up too. i've tried opening in ms/ms for mac 2008/google docs ..etc.

It is also protected by an nda agreement so, i should not really send a copy. any known cure?

#2

Marc

I have a .xlsx file which once had 9 tabs, that, after a save in libre 3.3.3 ... now it seems to have one. needless to say, the formatting is jacked up too. i've tried opening in ms/ms for mac 2008/google docs ..etc.

It is also protected by an nda agreement so, i should not really send a copy. any known cure?

Are using a Mac?

At the left hand bottom of the spreadsheet does it say something like
"Sheet 1/x" with this document? X is the number ot sheets in the
workbook.

#3

save as pdf. from excel 2008 for mac creates individual pdfs per sheet. thankfully.

#4

Marc

save as pdf. from excel 2008 for mac creates individual pdfs per sheet. thankfully.

> I have a .xlsx file which once had 9 tabs, that, after a save in libre 3.3.3 ... now it seems to have one. needless to say, the formatting is jacked up too. i've tried opening in ms/ms for mac 2008/google docs ..etc.
>
> It is also protected by an nda agreement so, i should not really send a copy. any known cure?

If I need to edit a MSO file, I prefer to open and save immediately in
corresponding odt format and keep the original intact so if there are
any problems I can try to sort them out.
The MSO 2007/2010 formats tend to not behavior as nicely as we would
like and there are reports of problems.

Do you know if there any macros or advanced features used in the MSO
version?

#5

Hi :slight_smile:
Do you still have a good copy of the MS Office xlsX file? Ods is the better
format for LibreOffice & OpenOffice but the file should be able to just open in
Calc and then use "Save As ..." to get into Ods. The Odt is for text
'obviously' but it's clear what Jay meant.

If you saved the corrupted xlsX over the top of the existing file then do you
have a back-up or have you emailed it internally or got a copy on usb-stick or
something? Sometimes it is faster to work from an old copy and just update it
than it was to do the work in the first place.

Is the question about document recovery or have you still got the data safe?
Good luck and regards from
Tom :slight_smile:

#6

Hi :slight_smile:
Possibly the best way to deal with the whole issue is to open the file in MS
Office 2007 or 2010 on a Windows machine. I think their MS Office for Mac 2008
is really based on their 2003 release not their 2007 one. I think they did add
the infamous ribbon rather than normal menus but it's still using 2003
underneath. I could be wrong as my memory is a bit vague about it.

Use their "Save As ..." to save to Ods format. Then it should open in
LibreOffice with no problems. MS Office uses the older Ods format, version
1.0/1.1 instead of 1.2 but LibreOffice has no trouble with that. Alternatively
use "Save As ..." to save in "Excel (97/2000/Xp)" format so that it save as the
xls without the X at the end. Again LibreOffice has almost no trouble with
that. I don't know why MS couldn't use the newer ODF formats, it's not as
though they were hidden or any more difficult to implement.

Regards from
Tom :slight_smile:

#7

REMOVE FROM MAILING LIST

#8

On 07/06/2011 07:39 AM, Tom Davies wrote:

Hi :slight_smile:
Possibly the best way to deal with the whole issue is to open the file in MS
Office 2007 or 2010 on a Windows machine. I think their MS Office for Mac 2008
is really based on their 2003 release not their 2007 one. I think they did add
the infamous ribbon rather than normal menus but it's still using 2003
underneath. I could be wrong as my memory is a bit vague about it.

Use their "Save As ..." to save to Ods format. Then it should open in
LibreOffice with no problems. MS Office uses the older Ods format, version
1.0/1.1 instead of 1.2 but LibreOffice has no trouble with that. Alternatively
use "Save As ..." to save in "Excel (97/2000/Xp)" format so that it save as the
xls without the X at the end. Again LibreOffice has almost no trouble with
that. I don't know why MS couldn't use the newer ODF formats, it's not as
though they were hidden or any more difficult to implement.

Regards from
Tom :slight_smile:

________________________________
From: marc moran<marc@cfmc.com>
To: users@global.libreoffice.org
Sent: Wed, 6 July, 2011 0:10:46
Subject: [libreoffice-users] .xlsx libre issue

I have a .xlsx file which once had 9 tabs, that, after a save in libre 3.3.3 ...
now it seems to have one. needless to say, the formatting is jacked up too.
i've tried opening in ms/ms for mac 2008/google docs ..etc.

It is also protected by an nda agreement so, i should not really send a copy.
any known cure?

#9

REMOVE FROM MAILING LIST

#10

Hi :slight_smile:
For unsubscribe instructions: E-mail to

users+help@global.libreoffice.org

Good luck and regards from
Tom :slight_smile:

#11

Or just read the instructions at the bottom of every email that comes out on this list...

Hal