Jon Peltier
My feedback
-
19 votes5 comments · Excel for the web » Macros, Scripts and Add-ins · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
An error occurred while saving the comment -
17 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
174 votes22 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier
commented
I can envision hybrid dynamic array tables. Given a Table, I would like to write a dynamic array formula in a cell that spills into an entire column. Given a dynamic array formula, I'd like to convert the spill range to a Table, or at least apply some features of Tables to the spill range. The more I think of it, the more powerful and more complicated it sounds.
Jon Peltier
supported this idea
·
-
84 votes10 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
46 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
9 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
10 votes3 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier
commented
Yet another problem is that the LAMBDA formula is not exposed to VBA. When you query the .RefersTo property of a Name, all you get is "=".
Jon Peltier
supported this idea
·
An error occurred while saving the comment Jon Peltier
commented
Another problem is that the Refers To box is stuck at one line only, while the Comments box is else to grow without limit. I've never used the Comments box, but I'm always stuck with the to small Refers To box, even if I'm not editing a Lambda function.
-
129 votes24 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier
commented
I imagine we'll need more than 8192 characters in a formula soon, especially if we start to allow inline comments and indenting.
Jon Peltier
supported this idea
·
-
23 votes6 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier
commented
Also include it among VBA's WorksheetFunction offerings.
Jon Peltier
supported this idea
·
-
2 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier
commented
I've never used the Select Objects tool to select objects in a chart or on a chart sheet, but I can see how it would be helpful. I can verify that it did in fact work in Excel 2010 and does not work in Excel for Microsoft 365.
Jon Peltier
supported this idea
·
-
164 votesJon Peltier
supported this idea
·
-
2 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
52 votes1 comment · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
294 votes45 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
63 votes0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
We’d like to see how many votes this gets as a way to help us prioritize the work. Thanks!
Jon Peltier
supported this idea
·
-
21 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
10 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
10 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
69 votes4 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
-
70 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Jon Peltier
supported this idea
·
Kind of an old thread, but I'm just starting to investigate Excel Online. I don't care about ActiveX controls, since they don't even appear in Excel for Mac (a non-negligible fraction of my customer base), and they can be flaky in Desktop. But I sure wish Form controls could be used in Excel Online. I can work around this gap with Data Validation, but listboxes, option buttons, and checkboxes are a nicer user experience.