Hello! Today there's a Q&A with the Excel developers in Reddit (Friday, April 4 at 1:00pm PDT/4:00pm EDT on reddit). We don't usually have a chance to give feedback since the Microsoft Connect initiative doesn't contemplate Office, and they won't even take bug reports from users; their attention is mostly on the big corporate users and no the analysts. So I though we should try to coordinate some questions about the worst parts of Excel. Here's what I think are the things that need the most attention, presented as questions for the Excel Dev team:
*1. When will you update the 20 years old VBA Editor to something more modern? *The need for VBA won’t go again even if you ignore it! *2. When do you plan to improve the scripting tools, adding things like modern .net operators, string and table methods, etc? *Apps for Office, VSTO and ExcelDNA all address different needs than those of the vast VBA community, which is mostly comprised of analysts scripting solving for special cases, or SMBs in which the switch to another technology wouldn’t make sense cost-wise (and who you won’t hear given the lack ways of providing feedback for Excel). We can't use "Apps for Office" for the kind of problems we solve here! Proprietary coding for multiple users in a large enterprise = bad, proprietary coding for analysis = GREAT! *3. When will you begin accepting bug reports and feature requests from the whole Excel community?* There’s no way to provide feedback for the Excel/Office team unless you’re a big MSFT partner; Excel/Office is one of the products without presence in Microsoft Connect. There’s little software that won’t take feedback from its community, and Excel’s is large! 4. Will you add new worksheet functions? Even if Excel is the superior product, there are a lot of community UDFs and functions introduced by Google Spreadsheets that are great additions. For instance, see some of the formulas that Google has and we're missing out: the REGEXEXTRACT, REGEX*, SPLIT... text formulas, the filter formulas (UNIQUE, SORT….), the XPath scrapping functions (IMPORTHTML), the data sources functions (IMPORTDATA...) *5. When will you improve Excel’s charting abilities for analysts and fix the old, old bugs that have yet to get attention? *They are lacking, often requiring a lot of manual “hacking” to achieve results; look at the amount of MVPs that dedicate themselves at explaining such hacks in their blogs. The Excel community has documented over the years TONS of bugs and shortcomings of Excel charting but instead of addressing those you only take care of the big partners requests which are biased towards only a part of the user base.There’s a lot of stuff that comes to mind: LINE CHART GAPS FOR ERRORS OR “”!!!, cycle plots, dynamic data ranges, pattern fills, labelling that stays in its place even if you change the data range, fixing the many problems with date category axis, the inability to accurately select a specific point in a time series where many are drawn, such as a daily series spanning years; the impossibility of easily applying filters to charts such as displaying a level series as a % change over a year ago; the incredible difficulty of highlighting specific time spans in charts; candle charts; the manual labour required to display chart labels to the right of the last observation of a series with the proper formatting; the difficulty in going from a series to the source data range.... etc etc. I hope you agree that this is an opportunity we shouldn't pass. Thanks! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
