Excel is a wonderful piece of technology, the full capacity of which I don’t even come close to fully utilizing. I can appreciate that as a piece of art, but I can also get everything I need done in libreoffice calc and then I don’t have to support and rely on microsoft.
I’ve worked at some banks quite a few years ago and Excel was basically a cheap application space for them. The cells were inputs/outputs, they used VBA, and COM+ which talked to SQL to perform calculations and all that. It was really weird but every iteration that they wrote to replace Excel (they needed to because of banking auditing regulations) had failed simply due to the features they would get from it. It was wild to see at the time.
Excel is a wonderful piece of technology, the full capacity of which I don’t even come close to fully utilizing. I can appreciate that as a piece of art, but I can also get everything I need done in libreoffice calc and then I don’t have to support and rely on microsoft.
I’ve worked at some banks quite a few years ago and Excel was basically a cheap application space for them. The cells were inputs/outputs, they used VBA, and COM+ which talked to SQL to perform calculations and all that. It was really weird but every iteration that they wrote to replace Excel (they needed to because of banking auditing regulations) had failed simply due to the features they would get from it. It was wild to see at the time.
I did some pretty amazing things with Excel and VBA in the day.
Or OnlyOffice, but there are problematic elements. Then again, what doesn’t have that these days?