- gibetom1979Asked on March 24, 2014 at 06:29 PM
when I do a excell report, the created files is a .xlxs.xls, wich is not readable on my open office
I do some report this mornig, and there was no problem, is there some change you do?
thank you for your answerPage URL:
- JotForm SupportjonathanAnswered on March 24, 2014 at 07:56 PM
Perhaps the Excel version is not supported by your open office application.
You may want to try downloading the submissions in CSV version instead.
Most spreadsheet application will be able to import CSV file formatted data. In this case, your open office application should be able to do so also.
Hope this help. Inform us if issue persist.
- gibetom1979Answered on March 25, 2014 at 08:47 AM
indeed the excel version is not supported by open office, but before it was ok, for an other form I deed some export and its work so good :(, did you change the excell version?
in the CVS export de input are not in the right case/column, I've got th name and a part of the phone number, and in the next colomn the rest of the phone number and the debut of the street adress.
I continue trying other report to find the good one
- jedcadornaAnswered on March 25, 2014 at 10:45 AM
I don't think that the version was change. Do you get any error message when opening an excel in open office? I will try to download a latest version and will let you know if I was able to open excel or not. About csv file can you send us a screenshot of how the fields are aligned?
Will send you feedback about excel once i'm done downloading the file and tested it on my end.
- gibetom1979Answered on March 25, 2014 at 01:20 PMhi
before the excell report was a .xls. now they are .xlsx.xls
here my screenshot of the CVS report on open office
2014-03-25 15:45 GMT+01:00 JotForm Support Forum :
- JotForm SupportTitusNAnswered on March 25, 2014 at 03:11 PM
Yes - the excel export was upgraded recently.
Try using Libreoffice - Its a relative of Open Office - uncannily similar if not the same projects.
You can also try integrating your form with Google Spreadsheet - if just to manage your form responses. Here's how to do it.
Let us know if this helps.
- besamAnswered on March 28, 2014 at 06:36 AM
I have the same problem as gibetom1979.
We are using our Excel reports for many years now and working with OpenOffice. We're glad to use this.
Moving to another program is not possible cause too many people involved and from IT regulations not able to install other programs...
=> Please will it be possible for you guys to tweak the reports again so they will be able to open in excell but ALSO in OpenOffice as they were before.
Many many thanks !!!
- JotForm SupportTitusNAnswered on March 28, 2014 at 06:52 AM
Please tell us about it on a new support request - That way your issue is prioritized.
You can create one by clicking on this link.
- LRGAnswered on March 28, 2014 at 09:46 AM
Here is the problem: when one downloads their submission report in Excel format, the file name has the extension .XLSX ... except the file type is Microsoft Excel 97-2003 Worksheet, which means the file extension should be .XLS (no X at the end).
So when Excel tries to read the file, it's confused since it's a 97-2003 file but has the newer file extension at the end. Therefore, I get this warning message every time: "The file format and extension of 'filename.xlsx.xls' don't match. The file could be corrupt or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?" ... I can click Yes and it opens.
I imagine this is why people who are not using Excel are having problems.
I have only noticed this happening in the last 2-3 weeks. Do you know when this will be fixed?
- KadeJMAnswered on March 28, 2014 at 11:24 AM
Thank you for pointing that out. I tested this and even in the latest version of MS Office I could see this gets appended incorrectly. I think this is probably due to a minor problem with the XML Header inside it that is probably causing this. We will have our dev's look into this problem asap.
- alp_denizAnswered on March 30, 2014 at 03:45 PM
This problem should have been fixed. Unfortunately I don't have OpenOffice to test it. Could you please let me know if the issue is totally resolved?
Thank you for your help
- gibetom1979Answered on March 30, 2014 at 03:51 PM
the problem is solved
it's working with openoffice without problem
- LRGAnswered on March 31, 2014 at 08:38 AM
Fixed with Excel as well. Thanks
- shirleythomas533Answered on October 21, 2014 at 06:14 AM
If your Excel file (. XLS and .XLSX) is not being open properly in your system than file may be corrupt or damaged by virus or other reasons. but you no need to care because you can use your file properly by using Kernel for Excel file repair tool. this tool supports all versions of MS Excel and Windows 95/98/2000/2003/XP/7/8. Visit us for free trial version.