Calc Builder Support

Calc Builder support
Public write access is disabled. Please login

UTF-8 format 18.10.2011 21:41

Hola Chicos,

Me gustaría saber cómo guardar el cálculo de UTF-8 idiomas. Cuando se guarda en el texto de un PDF y XLS es distorsionada!


Re: UTF-8 format 18.10.2011 21:42

would you mind to send us a link to your calculator? We would like to check it and test how pdf/xls export are showing your output.

Thank you,
Moonsoft Team

Re: UTF-8 format 18.10.2011 21:42

Dear Sirs,

My project is still offline and I can not send the link to you!

I'm taking out all accents and special characters of text.

I tried the code to change the word ANSI UTF-8 and could not find!

Maybe when putting the project on the host it is resolved!

Thank you for your response and my congratulations on your extension! It is excellent!

Re: UTF-8 format 18.10.2011 21:42

thank you for your feedback!
If you are still working on localhost, maybe you could send us an exported pdf, just to see what are you getting. This way maybe we could send you a solution before going live, (although we are almost sure we would find it afterwards anyway).
Moonsoft Team

Re: UTF-8 format 18.10.2011 21:43

I am sending an image of the excel file when exported!

Note the markings what is happening with words with accents "'" and with special characters "ç". This is happening both in the Matrix when the results!

The same problem was also happening in the PDF but I did a test now and could not be ...

Another issue: I'm trying to put a questionnaire in which the user would choose one of several options. How to do it without the OPTION LIST? Radio buttons are not appropriate for this. And do not get the YES / NO. I could explain or send some examples. XML?

Hugs all around!

Re: UTF-8 format 18.10.2011 21:43


PDF and excel could have troubles with encoding (maybe could be solved), but you told us the error is also in matrix in frontend. So, could this problems is refears to page encoding? In order to see it in our pc´s, can you send us the source of the page (from browser)?

About second issue, to choose one of several options we recommend option list. But, if you don´t want to show a select or a radio button, what kind of view do you want to see? can you send us an example?

Thanks. Regards,
Moonsoft Team

Re: UTF-8 format 18.10.2011 21:44


Firstly, thank you for the attention that is giving my problems. Never before had acquired Joomla extensions and received a helpful and friendly support as well. Thank you so much!

Let the problems:

I am sending 3 files for you:

1 - calcbuilder.xls21.xls --> is an Excel file and how I'm getting the special characters. Is it in case I change some files of the component or module for UTF-8 or something?

2 - codigofontepagina.txt --> is a file. TXT page that generates the Excel file.

3 - radiobutton.png --> is an image I want to do using the CalcBuilder. Is it possible?

4 - I would like to make a field such as: number set to receive even numbers only. To explain: If a user tries to put a number of different character he could not. The field is number and he tries to put there "ab., Cd-ef ..." button does not print. It will print only even numbers!

Is it possible?

Again, thank you!

Re: UTF-8 format 18.10.2011 21:44


We see your page is in utf-8 and this is the normal charset. In fact we test calcbuilder in this charset. The data wich is not shown properly is stored in database. Can you see what´s your database encode? maybe in phpmyadmin or similar.
Also we review pdf code file and we use utf8_decode function to convert UTF-8 in ISO-8859-1, and about excel, ussually excel convert all characters correctly. But in web matrix frontend code are directly taken from database, so you could check in jos_calcbuilder_matrix table value column if it´s ok.

I´m sorry, calcbuilder shows select and not radiobuttons. You can do changes in modules/mod_calcbuilder/tmpl/default.php in order to change select by radiobuttons.

Making validation is possible but I think is more difficult because fields are dynamically inserted, but If you know something about joomla validation you can do it yourself in the file above.

If you are interested, we could make custom changes to your component.
Moonsoft Team
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback