Summary: | Macros: VBA macro which defines function doesn't work on save as ods and reopening of the file: #NAME? | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | eng.GeorgiGeorgiev |
Component: | BASIC | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | cno |
Version: | Inherited From OOo | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | BSA | ||
i915 platform: | i915 features: | ||
Attachments: | Both XLS and ODS files. Yellow field to be changed |
Hi Georgi, I confirm the behaviour > set to New. Did you happen to see if it worked correct in earlier versions? thanks, Cor (by the way: I tested in 4.2.4.1) (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 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.
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