Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Problems with macro...
 
Notifications
Clear all

Problems with macro in lang.xls

12 Posts
2 Users
0 Reactions
6,997 Views
(@tonix)
Posts: 52
Active Member
Topic starter
 
[#3040]

I'm going to translate some parts of lang.xml, and I'm checking all necessary procedures before.
So, I have problems executing macros in lang.xls, which gave me error.
I'm using openoffice on Windows 7.
And, more strange, I had same error when executing macros using Excel on OSX.
Error is relative to fileDialog function (on line "Set fd = Application.FileDialog(msoFileDialogFolderPicker)").
What do you suggest?

Thanks,

Tonino


 
Posted : 12 Feb 2016 23H54
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

lang.xls macro have been designed to work on wirndows (sorry :blush: )
I had it work in linux quite easily. Just have to avoid all the mso... objects, with are pure Windows objects.
For instance, the msoFileDialogFolderPicker is not mandatory, it is just used to position saving on right place. Just use "save as" before running macro will also work right.
I'll try and retreive the linux version I had.
NB : on linux, macro take about 3mn to complete, and 5s on windows :silly:


 
Posted : 13 Feb 2016 14H31
(@tonix)
Posts: 52
Active Member
Topic starter
 

A "Save as" just made before does not work for me, but I solved anyway.
I just put these lines at beginning of function ChooseDirectory()

Function ChooseDirectory() As String
ChooseDirectory = ActiveWorkbook.Path
Exit Function

Now it saves in the same path of xls sheet.

Regards,

Tonino


 
Posted : 15 Feb 2016 11H58
(@tonix)
Posts: 52
Active Member
Topic starter
 

Two additional questions.
First question:
change I suggested works, but I have to edit it again each way a start lang.xls. Is there a way to make it permanent?

Second queston:
after generating new lang js files, put them in /tool/i18n/nls I do not see in any way new language in menu (starting draft for italian)? Of course I cleaned cache several times on browser. Is there any furtther operation I should do?
Thanks,
Tonino


 
Posted : 15 Feb 2016 17H57
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

change I suggested works, but I have to edit it again each way a start lang.xls. Is there a way to make it permanent?

Yes, but not as is as it does not work on windows (always saves on Document directory 🙁 )
So a version will be deployed on next version including your proposale condition on the OS.

after generating new lang js files, put them in /tool/i18n/nls I do not see in any way new language in menu (starting draft for italian)? Of course I cleaned cache several times on browser. Is there any furtther operation I should do?

Yes, you have to add new language selection in /model/Parameter.php file, about line 200 where languages are listed (hard coded, sorry)
This makes me think about evolution to dynamically generate lang list... for next version 😉

starting draft for italian

Great news !!! :woohoo:


 
Posted : 15 Feb 2016 18H30
(@tonix)
Posts: 52
Active Member
Topic starter
 

Don't worry, general procedure is easy, important is to have a check list.
Thanks,
Tonino


 
Posted : 16 Feb 2016 13H56
(@tonix)
Posts: 52
Active Member
Topic starter
 

I see also other translations in
html/external/dijit/nls/it
and
html/external/dojo/cldr/nls/it (actually missing)

Just to add a reference for a complete translation.

Regards,

Tonino


 
Posted : 19 Feb 2016 12H47
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

the /external refer to external libraries.
Dijit and Dojo are part of Dojo Framework.
Fo if you change thinks here in ProjeQtOr, migration to new version of dojo will erase changes.
Maybe you can share your translations with Dojo community 😉


 
Posted : 19 Feb 2016 12H50
(@tonix)
Posts: 52
Active Member
Topic starter
 

I'm just using dojo, not translating it, so I'm only adding /it files.
Adding of other languages here will be done automatically by Projeqtor team?
Regards,
Tonino


 
Posted : 19 Feb 2016 13H06
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

Adding of other languages here will be done automatically by Projeqtor team?

ProjeQtOr team will not upgrade languages in Dojo and Dijit sections.


 
Posted : 20 Feb 2016 18H17
(@tonix)
Posts: 52
Active Member
Topic starter
 

My request was not relative to upgrading, but to addiction.
If a language is missing in dijit and dojo folders of current distribution of projecqtor, will those languages be added?


 
Posted : 20 Feb 2016 18H20
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

No.
We take dojo distributions as they are.
If we integrate additional languages in current version, they will be erased when integrating latest dojo version (what is done as soon as new dojo version is deployed to benefit of fixings, performance improvements, and compatibility with newest browsers).
But you can keep it in your instance.


 
Posted : 20 Feb 2016 18H24
Share:

Scroll to Top