Created attachment 59044 [details] Screenshot of errror I have a spread sheet that contains macros. This spreadsheet work will in Ms-office 2003, 2007 and 2010 I have tried in on libreoffice on both Ubuntu 12.04 and Windows 7, both running libreoffice 3.5.1. I get the same error in both. It is 100% reproducible. BASIC runtime error. '1' Type: com.sun.star.lang.illegalArgumentException Message: Attached is a screenshot of the error and the offending line I have not attached the spreadsheet, as it has some confidential information, however I will make it available to anyone working on the bug with the understanding that it will not be attached to a public bug report.
Thanks for bugreport What if copy-paste only this Basic function to another spreadsheet? May be produced spreadsheet will also demonstrate this bug, but will be possible to attach it here.
Created attachment 63342 [details] this is a sample spreadsheet that exibits the same problem. this is a sample spreadsheet that exibits the same problem. It is the same spreadsheet that generated the original issue, but I now have access to a copy of excel 2007 and have been able to remove the confidential information. NOTE: there are other bugs that the spreadsheet exhibits. Saving from calc will cause it to crash. Deleting a worksheet will cause a crash.
Thanks for attachment reproduced in 3.3.4, 3.5.4 and 3.6.beta1 on Fedora 64 bit msExcel 2007 outputs this message: Run-time error '1004': Wrong password As I can see, problem of Calc with this attachment is not that macro not works, but that error message is empty. Impossible to understand it.
@ Noel Greetings What do You think about this bug?
(In reply to comment #3) > Thanks for attachment > reproduced in 3.3.4, 3.5.4 and 3.6.beta1 on Fedora 64 bit > > msExcel 2007 outputs this message: Run-time error '1004': Wrong password > > As I can see, problem of Calc with this attachment is not that macro not works, > but that error message is empty. Impossible to understand it. well, this is the same error the underlying libreoffice api gives back, sure... could be a better message. That's an enhancement at best ( and should be an easy hack imho ) more worrying is that it seems the xls[x|m] import doesn't import the protection passwords, don't know why that is, perhaps that information is in an unpublished format ?, I have no idea, but.. looking at the code I can see that a password is not set ( protection *is* set, but with a blank password ). IMHO that is worth a bug
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.