0

I am unable to open an xls file in Open Office 4.1.1. The same file is getting opened in Microsoft Excel. But in this, when I open the file, it is showing blank.

Improve this question
5
  • 1
    Try LibreOffice which is the fork of OpenOffice supported by Ubuntu and Debian Linux.
    – Ads20000
    Mar 21, 2015 at 9:16
  • Thanks for your immd reply,I am facing this issue in client place, and already our appln is in LIVE, hence kindly provide solution in openoffice itself.
    – Krishna
    Mar 21, 2015 at 9:19
  • Yes, Also would like to brief more so that it might be clear for you to help me. Excel file will be generated dynamically and saved in server where the client/customer will pick this excel (.xls) and opens it in ods but sees blank. Then I clicked saveas in open office it shows extension by default .xml, I renamed to xls then the data is shown.
    – Krishna
    Mar 21, 2015 at 9:36
  • Wouldn't automatically rename the files be an option (or better: edit the generating process) or am I missing something?
    – Jacob Vlijm
    Mar 21, 2015 at 11:14
  • Renaming the file in my machine and then open this file from client machine it works BUT if i rename the same file in client machine it is not working (i.e. data showing blank while opening in openoffice).
    – Krishna
    Mar 21, 2015 at 11:22

1 Answer 1

Reset to default
1

Possible solutions:

  1. Use LibreOffice instead.
  2. Convert it to ODS using Microsoft Office.
  3. Convert it to ODS by uploading and converting it to Google Sheets format first.
  4. Convert it to ODS by using a website such as Zamzar (source).
Improve this answer
2
  • I cannot do this as you said, kindly see my comment above.
    – Krishna
    Mar 21, 2015 at 9:40
  • I don't know sorry, what you're trying to do is WAAAY beyond my knowledge :(
    – Ads20000
    Mar 21, 2015 at 19:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.