News for hackers. Stuff that matters.

Show HN: Excel 2013

Not exactly a side project but my work for the last 2.5 years. As an avid HN lurker would love to hear feedback.

Background: I am a PM on the Excel team in charge of the advanced data analysis tools (http://www.microsoft.com/en-us/bi/Products/OfficePreview.aspx)

To download: http://www.microsoft.com/office/preview/en

( 17 comments | 20 points | on HN )
Re:Show HN: Excel 2013 by Cyrix on Monday July 23, 2012 @11:17PM (#4284213)
We really want VBA to use all cores of the CPU rather than just one.

VBA is currenly simply too slow, NOT able to use more than 25% of CPU capacity (3 out of 4 cores are idle when VBA is running).

Re:Show HN: Excel 2013 by codeonfire on Tuesday July 17, 2012 @03:24AM (#4254602)
I see that Excel still doesn't have any macro programming options except VBA. Where is support for C# (at least) programming of macros?
Re:Show HN: Excel 2013 by doppenhe on Tuesday July 17, 2012 @12:03PM (#4256305)
C# is absolutely supported through the COM interface. Although the built in IDE can only do VBA there is a full library that can be used with C# (how most add-ins are built)
Re:Show HN: Excel 2013 by codeonfire on Tuesday July 17, 2012 @12:23PM (#4256410)
Right, you can automate Excel in C# from outside of Excel or make an add-in, but you can't store code inside an Excel document or edit it from within Excel, or assign a worksheet control handler to directly execute C# code, etc.
Re:Show HN: Excel 2013 by doppenhe on Tuesday July 17, 2012 @02:26PM (#4257068)
thats right, but now you can do all that with JS/Html5. All in all I feel your pain though since i fall into this limitation myself (not a huge VBA fan).
Re:Show HN: Excel 2013 by revorad on Tuesday July 17, 2012 @09:22AM (#4255536)
Thanks for the preview! I don't understand if this is a web app or desktop app.
Re:Show HN: Excel 2013 by doppenhe on Tuesday July 17, 2012 @12:04PM (#4256315)
the apps will stream to your desktop but are desktop apps. O365 is also available which is the web apps.
Re:Show HN: Excel 2013 by dougbarrett on Monday July 16, 2012 @06:30PM (#4253024)
Is there going to be a release for OS X?
Re:Show HN: Excel 2013 by mikeyouse on Monday July 16, 2012 @06:43PM (#4253075)
As a follow-on question from someone who was forcefully converted from Win7 to OSX at a new job;

Is the release for OSX going to be productivity-crippling due to bugs (status bar disappears at random, etc.), frequent crashes (usually with powerpoint involvement), and haphazardly changed shortcut keys?

Love your Excel-for-Windows work though.

Re:Show HN: Excel 2013 by doppenhe on Monday July 16, 2012 @06:50PM (#4253092)
again I cannot comment on the OSX release because I actually don't know. If your having stability issues make sure to send those crash reports we actually have some pretty cool collection and analysis tools for crashes that lets us work on the reliability of the product.
Re:Show HN: Excel 2013 by mikeyouse on Monday July 16, 2012 @07:07PM (#4253152)
No worries, it was mostly tongue-and-cheek anyways. I went from being a maestro at the keyboard to hunting and pecking with the switchover to the OSX version. This is nobody's fault but my own.

I'm very curious to try the Windows version though, what are some of the bigger changes? (Aside from the better pivot tables, better sharing, and smart-fill on the product page).

Re:Show HN: Excel 2013 by doppenhe on Tuesday July 17, 2012 @02:41PM (#4257157)
For Excel in particular the list is actually really long. The big ones are flash fill (pattern recognizition for data cleansing), quick analysis (live preview of different analysis elements with your data), side by side Excel sheets, Chart animations, automatic PivotTable recommendations, automatic Chart recommendations, Data model (Powerpivot - in memory data analysis engine that allows creating relationships between data sources -db style), among 100 more.
Re:Show HN: Excel 2013 by sharth on Tuesday July 17, 2012 @01:50AM (#4254296)
Yes: http://www.microsoft.com/office/preview/en/faq

They somewhat claim that it will be released alongside the Windows release.

Re:Show HN: Excel 2013 by dougbarrett on Tuesday July 17, 2012 @02:35AM (#4254432)
Unless I'm wrong, they are talking about Office 365 which is their web app version of Office.

I'm thinking that by the time the new version of Office is released, Google will make their website more tablet friendly, or beef up Google Drive for tablets to be more than just a document viewer.

Re:Show HN: Excel 2013 by doppenhe on Monday July 16, 2012 @06:48PM (#4253086)
the windows and OSX releases are not usually tied together and are actually developed by different teams. I do not have any info on their vnext release sadly.
Re:Show HN: Excel 2013 by tonyjwang on Monday July 16, 2012 @11:05PM (#4253875)
Flash fill looks sick.
Re:Show HN: Excel 2013 by doppenhe on Tuesday July 17, 2012 @12:05PM (#4256322)
its really is pretty awesome, straight from Microsoft Research. I have been using it for the last couple of months and I don't think I could live without it at this point :)