Glad you started this thread Jimbo ... :)
I have installed free Gnumeric (Spreadsheet app) ... just playing with it so far to work it out.
- UI data opens OK in Excel 2010, including cell comments.
- uses Python to enhance versatility ... but at my age I have lost interest in learning another language.
But I do miss VBA in Excel 2003 for custom cell functions
Would like to find a non-ribbon Word alternative.
Last edited by bawldiggle; 05 Aug 2014 at 22:14.
@ DavidW7ncus :)
I have been writing MS-Excel VBA addins, creating Excel templates with VBA userforms etc and xls files with userforms and custom cell functions, before 2003 ( I date back to Word basic etc, I think I started around '95/'98)
Libre Office has left me cold ... from Libre forum there are a lot of bugs in Libre Office ... and it appears a user who wants to create custom macros has to use 4 different languages.??
And I have never been able to find a list of objects, methods, functions, enums etc, (if they exist)
The Excel-2003 (and Word-2003) VBEditor works extremely well.
(Granted any Excel file with VBA is prone to significant bloat ... I have written an XLA file to rebuild (not copy) bloated files.
I appreciate that MS-Excel >2003 version assembles xlsm, xlam, xltm file as a sort-of zipped file containing UI data + any code ... a lot more stable and file sizes are apparently smaller)
VBA is serving me well as I am on the home stretch of my working life, so learning new language/s is too daunting ... I think !?!
How does WPS spreadsheet VBA measure up to the versatility and accessibility of MS Excel VBA.
The ribbons in MS Office have created a headache for me as all my addins create a menu-bar sub-menu at run time.
One of my addins (menu) has 68 controls, which is more tidy/compact than icons on a ribbon (across the entire width of a screen).
Using a menu has also made it easier to assign hot keys to control-captions.
The idea of MS cloud based office is just a no-go for me. A lot of my work is highly confidential.
- so my secured PCs are not internet connected.
I hope my query makes sense :)
Hi there
Have a look at my ist post in this thread a complex spreadsheet so you can do a lot without VBA macros -- I think though the latest versions have VBA macros in them - I have yet to test the compatibility as I try and use a lot of the in built functions -- it makes for less hassle if a new version of Office comes out etc.
As for the ribbon - you can minimize it quite easily so that shouldn't be a bother. Works in Full screen mode if you like too !!
I'll try and test some VBA macros when I've got time though. What you *might* lose are any 3rd party addins - but I already stopped using those when I switched from 32 bit to 64 bit version of Ms Office 2010 as they didn't work and I could re-write the spreadsheets myself easily.
Screenshot - writer in full screen mode and in windowed mode - you can see the menu won't be a problem for anybody used to Ms Word.
Cheers
jimbo
Absolutely it is very nice
WPS Office 2014 is now out of beta and is sold on an annual subscription model - $3/mo or $30/yr (business edition $5/mo or $50/yr.) I paid a one-off fee for a "Lifetime" license to their earlier "Kingsoft Office" product, and although WPS Office 2014 is just a re-branding of Kingsoft Office 2013, it has become clear through my communications with them that they do not intend to honor the lifetime license they sold to me, and probably many others. Their position seems to be that I can use the 2013 version for a "lifetime," but that's it. As such, it's really just a misrepresented "Version License."
I purchased the Lifetime License mainly to reward them for creating such a fine product, and to a lesser degree, so that I would have access to everything the software has to offer if I ever needed it. As I recall, about the only thing really missing from the "Free" version was VBA macros, which I haven't really needed. But if they're going to sell a "Lifetime" license, I think they should honor it, especially as a thank you to the early adopters who helped pave the way for their current success.
The new WPS Office 2014 also has a free version, but installs as a 30-day trial of the fully-featured subscription model product. Reports I've read elsewhere (my copy is still within the 30 days, so this is hearsay from me at this point) is that, when it reverts to the "Free" version after 30 days, a lot of functionality goes missing and there are continual nags to upgrade to the paid subscription. Too bad.
I'll likely head back to LibreOffice, or there is a new one I just heard of today called SoftMaker Office. I don't know anything about it beyond a few screenshots I've seen on their website which show the interface to be sans-ribbon style. Also, to be quite honest, Google Docs looks better and better all the time...
I use it on my smartphone, VERY handy :P, and free. I just hope they fixed issues when you edit in different zoom modes and printer goes crazy with giant prints LOL...
Quote