News for hackers. Stuff that matters.
Re:Applying programming language research ideas to transform... by cm2187 on Sunday January 20, 2019 @02:20AM (#18951648)
It is great that Microsoft is investing in Office again. I just got upgraded at work from office 2007 to 2016 (we like to take our time, I was on WinXP not so long ago), and I can barely see the difference. They changed some colors, there are menus that open in a panel instead of a modal box. I don’t think a single user cares about these changes (and they seem to have carefully preserved the bugs). And the problematic UI (for instance the tiny non resizable modal when you click the fx button) have not been updated.

But there are still massive pain points or improvements that could be added. For instance:

- linking between excel and powerpoint. Almost anyone who will show an analysis, whether in a bank, accounting firm, consultant, etc will prepare some table and charts in excel and will want to use them in powerpoint. The link between the two is unstable, screws the formatting, or requires lots of manual steps.

- Microsoft should really look into Apple’s take on excel, with a sheet being a canvas on which you can add tables, charts, the tables have scroll bars if they overflow. Instead of the rigid single grid per tab, where if you show two tables one over the other you need to align the columns even when they have different data types.

- VBA hasn’t been updated in 20 years and it clearly shows. There needs to be a more modern scripting language. I have heard rumors about javascript. Not convinced it’s a great choice, but that would still be better than VBA.

Re:Applying programming language research ideas to transform... by fxfan on Sunday January 20, 2019 @05:20AM (#18952322)
You clearly missed out on the magical fill. Search for Sumit gulwani excel. Another collaboration with MSR
Re:Applying programming language research ideas to transform... by hliyan on Sunday January 20, 2019 @08:37AM (#18952970)
This is a headache for me too: with a sheet being a canvas on which you can add tables, charts, the tables have scroll bars if they overflow. Instead of the rigid single grid per tab, where if you show two tables one over the other you need to align the columns even when they have different data types

Another thing I'd like to see is to be able to treat cells as objects rather than single scalar variables. For example, to represent data that has more than two dimensions.

Re:Applying programming language research ideas to transform... by pjmlp on Sunday January 20, 2019 @02:44AM (#18951745)
I can tell you one big difference, the set of statistic formulae that are now available.
Re:Applying programming language research ideas to transform... by kgwgk on Sunday January 20, 2019 @09:21AM (#18953143)
Microsoft want’s to kill VBA but customers won’t allow that. https://en.m.wikipedia.org/wiki/Visual_Studio_Tools_for_Offi... may make sense for developers, but users like the ability to do things in the “wrong way”.
Re:Applying programming language research ideas to transform... by cm2187 on Sunday January 20, 2019 @12:23PM (#18954157)
VSTO isn't great. There was something called VSTA earlier, basically a little visual studio embedded in Office, you could do with any .net language what you could do with VBA. Unfortunately they canned it.
Re:Applying programming language research ideas to transform... by clausok on Sunday January 20, 2019 @01:16PM (#18954518)
Especially with ExcelDna, it's hard to make an argument for using VSTO. And even with ExcelDna (i.e., an xll written in F#\C#), I find there are still niche areas where vba is effective, particularly when working with the Excel object model. The split I like is to have vba orchestrate interactions with the object model, Sheets, Books, Ranges, Range.Find(), etc. So for example, have your F#\xll code parse "60d" into the last 60 trading days, and then use vba to select those days in Excel's autofilter.
Re:Applying programming language research ideas to transform... by cm2187 on Sunday January 20, 2019 @01:28PM (#18954606)
Possibly stating the obvious, but you know that you can manipulate the excel object model from ExcelDNA in the same way that you can with VBA (thanks to VSTO!).

Add a reference to Microsoft.Office.Interop.Excel, and get a handle on the Excel Application object using ExcelDna.Integration.ExcelDnaUtil.Application.

Alternatively you can use the excellent NetOffice.Excel (instead of Office.Interop.Excel), which will have less functionalities but with better version support.

Re:Applying programming language research ideas to transform... by keithalewis on Sunday January 20, 2019 @02:15PM (#18954938)
If you know C++ and want to embed C++ objects in Excel you can use a library I wrote. Here is an example of how single inheritance works: https://github.com/keithalewis/xll12/blob/master/sample/hand...
Re:Applying programming language research ideas to transform... by clausok on Sunday January 20, 2019 @01:59PM (#18954822)
Where has NetOffice.Excel been hiding?! Thank you for that.

What I've found with interop is there's a little more debuggability/edit-and-continue friction that can accumulate into a large loss of time during development. Maybe that loss is offset, or more than offset, by doing the interop with a vastly superior language. I'm not sure. Any thoughts about this trade-off?

Re:Applying programming language research ideas to transform... by cm2187 on Sunday January 20, 2019 @02:14PM (#18954935)
I don't know. I find VBA to lack so many modern features (type inference, linq, generics, etc) that I favor using a more modern language over edit&continue. VBA and interop have nearly the same syntax so you can always toy in VBA and then implement it in .net. NetOffice sometimes has a different syntax so is a bit more iterative.
Re:Applying programming language research ideas to transform... by kgwgk on Sunday January 20, 2019 @12:41PM (#18954294)
Did VSTA for Excel ever exist? I can find only references to InfoPath (whatever it is, it seems it was part of Office for a while).
Re:Applying programming language research ideas to transform... by cm2187 on Sunday January 20, 2019 @12:51PM (#18954341)
No it never existed. But I believe that at one point it was the intention, it was meant to cohabit with VBA, and work essentially in the same way.