At least comment out, and let it run without errors the next time when you enable them. Hmm, but you ought to be able to edit them. If I leave macros disabled, of course I cannot edit or debug them. Guess I’ll have to look around the Linux world for some other spreadsheet app that is more sensibly designed, instead of one that blindly duplicates how Microsoft Excel handles things. Even if all I could do was just to print out each module, that alone would be a blessing. It’s an absolute shame that Calc provides no way to load my modules into the debugger without going through all that. It’s going to be hell trying to reverse engineer what I did I was hoping to refresh my memory by at least seeing the code.īut as I said, loading the main workbook with macros enabled means dismissing something like 60,000 error notices as it loads–a rough estimate, considering how many cells contain formulas and how many user-defined functions each formula contains. That means I can’t even see what I did, much less try to figure out how to handle the sorts of things I want to do in LibreOffice Basic. So none of you can suggest any way to get into the debugger unless macros are enabled before the spreadsheet is loaded? This is a bitter, bitter disappointment. You would also face the problem trying to port a “complex” solution from LibreOffice to MS “Office” Getting involved with the API of complex software initially will always mean giving up the simple portability of the solution in question. calculated) data but also range objects as parameter values to functions used in spreadsheet formulas, VBAsupport is usually sufficient. If, for example, it is mainly a question of being able to pass not only (prob. If the VBA part of the existing solution (for whatever) consists mainly of supplementary spreadsheet functions, you can try to see what works using the options Option VBASupport 1 and Option Compatible, and whether the pitfalls can be eliminated by minor changes. The API is provided in a completely different way in LibreOffice. After all, VBA is not just a programming language, but above all the API of the respective software. You'll probably want to create a folder in which only those accounts that you give permission can see and/or edit the documents.If the design of the linked documents really exhausts the peculiarities of VBA, the implementation of the functionality in Calc requires a completely new development. Your colleagues who have Microsoft Office can obtain them back directly from SkyDrive and also save them to SkyDrive from current versions of Office, if that makes it easier for you (and for all of you when not in the office). In all cases, you will have to experiment to see which routes provide the greatest preservation of fidelity in the spreadsheets. You'll be warned if a spreadsheet uses features not supported by the SkyDrive versioin. You don't need Microsoft Office installed. You can then view and edit them in a browser (Internet Explorer, Firefox, or Chrome). xslx files to SkyDrive by creating an account at. If your colleagues are using the new version, Office 2013 Excel, the best route may be to have them save the documents as ODF for you.Īnother alternative is to upload the. You can try later versions of LibreOffice (3.6.2 is declared stable) and also the latest version of Apache OpenOffice, AOO 3.4.1.
0 Comments
Leave a Reply. |