Ask Your Question
0

Issues with Excel 2010 Documents Opened in Calc [closed]

asked 2013-08-13 01:24:51 +0200

aesterkin gravatar image

updated 2015-11-06 07:29:00 +0200

Alex Kemp gravatar image

When I open a large macro-enabled Excel 2010 document in LibreOffice 4.1 Calc, I experience two problems:

  1. All fonts are screwed up; row heights and column widths are radically changed, and any forms controls (buttons, scroll bars, etc) and ActiveX controls are in wrong places.
  2. Application.EnbleEvents = True/False lines in macros produce errors

This happens similarly in Windows 7 and in Fedora 18.

I am wondering if anyone could help me understand what is missing or getting wrong and what can be done about this.

Please, note that Apache OpenOffice cannot even open these Excel documents - gets into hung state indefinitely...

Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-06 07:29:21.417431

Comments

If possible, can you save your file in Excel 2003 XLS format? LO much better support XLS than XLSX.

Ljiljan gravatar imageLjiljan ( 2013-08-13 18:20:08 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-08-13 02:56:31 +0200

ROSt52 gravatar image

@aesterkin - This looks not very nice. I would try to make a test using 4.0.4. Can you do this?

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-08-13 01:24:51 +0200

Seen: 625 times

Last updated: Aug 13 '13