on 2012-03-30 1:31 metasys wrote
So on forum they specified that lion OS not support .xls , so we have to change it to .xlsx. I have tried out that but it is not working. I am using Fm 9 Advance. Plese help.
it won't work with version 9; it sounds like you are just tacking on the .xlsx
extension hoping that would change the format, but starting with version 10 (i
believe) there was a pop-up menu with specific option for .xsls format in the
Save Records As Excel dialog box
Yes, you do need to specify the file type in the script step if it's run without dialog, or in the dialog box if you leave that open to the user (though XLS won't be an option there if you're already on Lion).
The XLS file format requires the installation of Mac's Rosetta functionality to save an XLS file, and Rosetta is not supported by Lion -- not even as an optional installation.
I have a huge system which had scripts for hundred+ of Excel.xls reports. I ran a full-solution Database Design Report (DDR, FileMaker Advanced tool) for just the scripts, and then went through it searching on "xls" in the html content to quickly locate them all. Then I went into the files and reset the options in each such script I had found. It took several hours for a few hundred Excel scripts in over 60 files, but I got them all done before any of our users made the Lion upgrade.
Our accounting department, which is all Windows-based and using recent Excel version were thrilled not to have to convert old XLS files to XLSX anymore, as well.
Doing this after the Lion upgrade rather puts you under the gun, but it should remove the old XLS file option from the settings so you can't accidentally leave it selected once you start to change the dialog.
Reminder: Excel can open .htm tables if you can calculate (or export) this format.
and the browsers can read this, too. LOL!
thanks for your reply.
it won't work with version 9;
So we need Filemaker 10 or 11 to save the file in .xlsx format?
Yes, version 10 was where support for XLSX was introduced.
See FileMaker's online Knowledge Base article 7069 for details. This certainly indicates XLSX will not export with version 9.
Thanks to everyone for their help....:)