Hi,
it is not a validation, we talk about an equation.

And don't get confused with equal signs.
"==" means comparison, "=" means assigment.

So, what is your problem with creating a question of type equation before your array with the mentioned statements?
{tabelul_l1_c1=0}
{tabelul_l1_c2=0}
{tabelul_l1_c3=0}
...

Joffm

Hi,

Now I m trying to export the results on excel format but I got the attached error where said:
500: Internal Server Error
Class 'ZipArchive' not found.

From what I understand on similar question on Stackoverflow I need to install zip extension on my server. Is it correct?

What and how are you exporting?

When exporting your responses to EXCEL no zip file is created but a "results-survey123456.xlsx".

A zip file may be created when you download the attachments of "file upload" questions.

Joffm

Hello,

Was a user permission issue. I didn't have the right permission.
Fixed.
Thank you for response.

Joffm wrote: When exporting your responses to EXCEL no zip file is created but a "results-survey123456.xlsx".

xlsx, docx etc … are zip files
With specific files inside it

Same for ods

Then need specific zip extension for PHP

@Denis,
of course you're right.
I myself unzipped a xlsx to edit some things inside.

Sorry

Joffm

Hello,

For exporting of array of number in excel on the specific format is any option because I didn't find. For example for a table of 2 rows and 2 columns all the answears are exported in excel in rows. I would like to be as it is in array number(table) format. So if a field is on column to in array in my excel to be exported on column 2, etc...

I don't know if I was really clear here. I like to export table (array number) as it is in survey format.
Columns from survey goes to columns in excel.
In this result export form survey rows and columns goes in excel to rows only so you have to figure out which one is row and which is column. After that I have to check which is column in excel and cut/paste.

Hi,
I think it was clear.

But nobody knows how to answer such a question.
How do you imagine this could be possible?


Where to begin:
You know format of relational databases?
You know the requirements of most analysis tools; I am sure you want to do some statistical tests like CHI², t-Test, ANOVA, even factor- or cluster analysis. And all these work row wise.

Even EXCEL to be able to use "Pivot-tables".

You see, if you display it the way you described you can't calculate a simple mean of a cell in EXCEL without additional conditions.

In your first post about that you talked about a 2x2 matrix. Now if the next question is a 3x4 matrix? Or a multiple question? How do you want to display this?
Something like that?


Obviously this will not work.

have to figure out which one is row and which is column

As the format of export is well defined
Q_Y001_X001,Q_Y001_X002,Q_Y001_X003,...,Q_Y002_X001,Q_Y002_X002,
there shouldn't be anything to figure out.
Maybe, if you coded both (x and y)-axes "SQ001","SQ002",... it might be a bit confusing.
But as I saw, you coded "table1_l1_c1","table1_l1_c2",...

After that I have to check which is column in excel and cut/paste.

This you may do with a small macro in EXCEL, even because you have well defined codes for row and column.

And what is the reason to display such a matrix of a single respondent?
Usually you display the results of the entire survey or a subgroup ("males", "females").
And this is done by the cross tabulation of your statistic tool.

Joffm

Hello,

Thank for the response.

Right now I m trying to export the response in Excel but the response didn't save in Excel. And after I push the submit button it didn't appear any message of finishing, it's just like I press refresh button. Could this be because of to many structure on my survey. In this example (*.lss) I attached I have 4 array numbers.

I should say,

revise your design.
At least put your several t-questions into separate groups.

If you display everything on one page, your "max_input_vars" value may be far too low.

I could submit the questionnaire; and export as well.

And the responses remain saved in the excel. I mean you could see what you response in the Excel?