cancel
Showing results for 
Search instead for 
Did you mean: 

Could Alfresco alter Excel macros ???

jpinheir
Champ in-the-making
Champ in-the-making
Hello,

I use Alfresco in a production environment (Alfresco 2.1 community in a RedHat environment and mysql database) since last january.
I have more or less 50 users that contribute to documents, and almost 300 that consult them.
In their majority, they use the CIFS access to update and create documents.

The problem is that in some cases, some macros in Excel documents seem to be altered when saved in Alfresco. These Excel documents contain a lot of macros, and are protected with a password.
I haven't been able to reproduce the problem, but it occurs regularly.

Here is an altered macro example:
Sub Init_Ga()
Attribute Init_Ga
Attribute Init_Ga
'
' Init_Ga
' Macro enregistrée le 21/02/2007 par G. Abbé
'
Dim i As Integer
Dim j As Integer
Dim NbreLignesAvancement As Integer
Dim DateDebut As Single
Dim DateFin As Single
Dim Debut, Fin As Date
Dim Avancement As Single
Dim Reponse As Varia
Dim JoursTotal, JoursResta

'Pas de mise à jour de l'écran (permet d'accélérererertraitement de la macro)
Application.ScreenUpdating = False

' Récupération des dates globales d'établissement du Ga
'Worksheets(Ga
DateDebut = Worksheets("Ga
DateFin = Worksheets("Ga
…..
Everywhere you see the word "Ga" (init_ga, worksheets("Ga ….) , it should be the word "Gantt" and the macro doesn't compile!!!

It can happen too that caracters are added :
Dim i As Integer
Dim jjjjjjjjjjjjjjjjjjNbreLignesAvancementjjjjjjjjjjjjjjjjjDateDebutjjjjSingle
Dim DateFinjjjjSingle
Dim Debut, FinjjjjDate
Dim AvancementjjjjSingle
Dim Re
Dim JoursTotal, JoursRestant, JoursConsojjjjSingle
The "j" caracters shoudn't exist !!!


I am suspecting it could come from the indexation mecanism, what do you think about that ? Could it really come from Alfresco ?
It is a very serious problem because my users are now afraid of storing documents in Alfresco and are beginning to stop using it …

Thank you for your answers or advices, I really don't know where to search to solve this problem.
1 REPLY 1

jpinheir
Champ in-the-making
Champ in-the-making
Hello,
No answer ? I'm only looking for ideas …
Could it come from POI ? Is POI able to write into files saved in Alfresco ?