Xls (and xlsx) are the file formats used by Microsoft Office's Excel spreadsheet program; xlsx was used from Office 2007 onwards. These formats can also be opened by office programs on Ubuntu such as Openoffice or Libreoffice.
0
votes
0answers
113 views
LibreOffice Calc won't open in Excel
When I save my LibreOffice Calc file to Exel format it won't open correctly when opened in Excel. All of the cell information and text and any formatting goes away and it is one big mass of cell ...
0
votes
0answers
14 views
Testing a Worksheet Name using YEAR(TODAY())
I have a very simple question (hopefully)...
I've a WB, its WS Tabs are named 2011, 2012
In my AUTO_OPEN, I want to test for a Tab named the current year
If it fails, my MSGBOX says to go create the ...
3
votes
1answer
4k views
Can't open .xlsx file with LibreOffice
.xlsx files are not opening in LibreOffice 3.4.3 in Ubuntu 11.10.
Could not open "ABC.xlsx"
Archive type not supported.
5
votes
2answers
899 views
How do I save all images from .xls file?
I've got a xls file with exactly 167 images that I must save and post on a website. The sheer number itself is painful, but what complicates things is that you can't directly save images from Calc - ...
14
votes
2answers
2k views
Commandline tool for viewing xls fies
Is there a commandline tool for viewing/opening excel (.xls) files?
~~ edit: asking for follow up info ~~
So the answer works great unless the worksheets don't have a custom name.
When I try to ...
3
votes
1answer
1k views
How do you convert many files from .xlsx to .xls?
What is a way to convert a batch of .xlsx files to .xls format? I would prefer it to be a command-line solution, but anything is better than opening each manually, and manually saving in the new ...
