Bug 74656 - Macros: VBA macro which defines function doesn't work on save as ods and reopening of the file: #NAME?
Summary: Macros: VBA macro which defines function doesn't work on save as ods and reop...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version: Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-07 09:05 UTC by eng.GeorgiGeorgiev
Modified: 2014-05-06 18:30 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Both XLS and ODS files. Yellow field to be changed (16.60 KB, application/zip)
2014-02-07 09:05 UTC, eng.GeorgiGeorgiev 		Details
View All

Description eng.GeorgiGeorgiev 2014-02-07 09:05:01 UTC 
Created attachment 93592 [details]
Both XLS and ODS files. Yellow field to be changed

Problem description: 
When I open an Excel file with very simple VBA macro in it, in Calc everything works fine. When I save the file in ODS format it also works fine. But when I reopen the ODS file with Calc the macro is not working (the macro defines new function called Linearinterp). I know that similar bug was reported, but it was for macros that doesn't work back in Excel, here problem is in the ods file, looking in the macro code the Calc is converting it someway, but still doesn't work    
Steps to reproduce:
1. Open xls file
2. Save as...*.ods
3. Reopen the *.ods file

Current behavior:
Formula that is defined with the macro is not working on reopening
Expected behavior:
To have macro works fine.

              

              
Operating System: Windows XP
Version: 4.1.4.2 release
Comment 1 Cor Nouws 2014-05-01 23:06:40 UTC 
Hi Georgi,

I confirm the behaviour > set to New.
Did you happen to see if it worked correct in earlier versions?
thanks,
Cor
Comment 2 Cor Nouws 2014-05-01 23:06:56 UTC 
(by the way: I tested in 4.2.4.1)
Comment 3 eng.GeorgiGeorgiev 2014-05-05 06:35:02 UTC 
(In reply to comment #1)
> Hi Georgi,
> 
> I confirm the behaviour > set to New.
> Did you happen to see if it worked correct in earlier versions?
> thanks,
> Cor

Hello Cor,
actually this is the only version I've tested it (4.1.4.2). I don't know if it works on earlier versions,
Regards,
Georgi
Comment 4 Cor Nouws 2014-05-06 18:30:21 UTC 
I see the same behaviour in LibreOffice 3.3.0, so I guess this is not yet implemented in the VBA-interoperability (See also Tools > Options > Load/Save > VBA Properties)

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.