The dominant programs at the peak of the pre-suite period were the Lotus 1-2-3 spreadsheet, the WordPerfect word processor, and the dBase database program.
LIBREOFFICE VS MICROSOFT OFFICE ONLINE SOFTWARE
Gone were the days of running a disparate collection of software on your desktop. These bundled the most-used types of office software into coherent families of software. There are however some workarounds and extensions available to try and simplify this somewhat (refer this Apache OO forum thread).The office suite came hot on the heels of the success of the earliest word processor and spreadsheet programs. There is no native IDE for Python in LO and no native method of saving Python macros in ODS (the scripts are saved to the user profile under Scripts/python/). Also note this answer about the option required at the head of a VBA macro to allow it to run. Tools > Options… > Load/Save > VBA Properties > indicates whether a copy of the existing VBA macro is preserved or not. There are evidently tools to allow limited Python manipulation in XLS/X, but you do not indicate what you are considering in this area.īy way of general answer to your title, I have recently written this outline of MS binary vs OOXML support in LO. In either case though, macros are likely to be an issue as XLSX will only save VBA macros, while ODS can save LO Basic and VBA.
LIBREOFFICE VS MICROSOFT OFFICE ONLINE WINDOWS
My home computers are all running Ubuntu and therefore I’m using LibreOffice, however my work computer runs windows and Microsoft Office.Īs indicates, for compatibility with LO you are going to have to either: I would like to integrate my spreadsheets with Python and build several Macro’s. Or should I build a Microsoft and Libre Office version? So what I want to know is that, if I build all my spreadhseets in LibreOffice, will I be able to transfer them over into Microsoft Office for work successfully. My home computers are all running Ubuntu and therefore I’m using LibreOffice, however my work computer runs windows and Microsoft Office. That would then find the appropriate palce and automatically input the item.Īfter that the sheets would be set to automatically incorporate the new data into their analysis, updating any statistical tables and graphs I’ve set up. There I’d set up a programme which would ask me for a job number, time spent and the day in which I’m talking about. Another would be for my timesheet system. If not the programme will prompt me about the item if it doesn’t to tell iin order to figure out where to put it (in this case the response would then be stored in the hopes that future items will be remembered). If it recognises the item it would automatically place it into a specific row/column/sheet.
Samples of what I would build is a prompting system which reads through a fie of my finances containing each item for the month. In order to automate these as much as possible I would like to integrate my spreadsheets with Python and build several Macro’s. I want to make two spreadsheets, one for working out my timesheets and figuring out how much time I’ve spent on a job compared to others etc.Īnother which deals with my finances.
0 kommentar(er)
