This fonts is used only in PDF export (and thinks is not needed since we use dejavusans for PDF export)
Here : use a real tools to read CSV.
The CSV file is in UTF8 : then force UTF8 when open it. ANd use comma (comma seperated value).
Best is to directly use LibreOffice Calc ....
libreoffice.org/
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. -
Professional support
-
Plugins, theme and development
. I don't answer to private message.
Thanks Denis...
I use notepad++ and its work for me also, but i want to close this bug for feature release
i already start look in export_helper.php and look where can be a problem
If you can help me with advice and knowledge will be great.
Now we avoid problem using different piece of software that encoding file correctly i what so solve csv file to be working without using others encoding tools
LimeSurvey produce clean UTF8 CSV file.
MS Excel have a bug. I don't fix bug on MS-Excel
If you export at xls : excel open it.
You can try xlsx export format, but this format is very complicated ...
And please : don't try to fix csv export : else i can not import it directly in LibreOffice CAlc and other CSV editor.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. -
Professional support
-
Plugins, theme and development
. I don't answer to private message.
Any info what i shuld change to get this excel working...
i change java script to unblock selection , now seems that it dont get all data bechause of somewhere in php has limit...
i don whant to spend hours looking file by file....if anyone can help will be great...
I what to use excel without any external manipulations...and will do it to be working i just whant to save time , java script changed:
exportresults.js
on line 4 : if ($(this).val().length > 22255 && $('#xls').prop('checked')) {
on line 17: if (selectedCount> 22255)
As far as I know, the export library that creates the excel does only create the old excel format and this format is limited to 255 columns. So far no one really was willing to put the effort in to implement a new library that can create xlsx files which would be able to cope with a lot more columns.
Most will just export to CSV and then import into excel I guess.
However, I am sure that the team is happy if someone is willing to work on a implementation for the newer Excel format that supports more columns.
Help us to help you!
Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
As far as I know, the export library that creates the excel does only create the old excel format and this format is limited to 255 columns. So far no one really was willing to put the effort in to implement a new library that can create xlsx files which would be able to cope with a lot more columns.
Most will just export to CSV and then import into excel I guess.
However, I am sure that the team is happy if someone is willing to work on a implementation for the newer Excel format that supports more columns.
Help us to help you!
Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
