3 ms·

> I mean Excel is at its heart a query language. So your logic equally applies to Excel The least readable query language ever. Instead of names, everything m

by dspeyer 13y ago

> I mean Excel is at its heart a query language. So your logic equally applies to Excel The least readable query language ever. Instead of names, everything must be addressed as column,row. Imagine a C program that instead of declaring variables with sane names as needed, simply created a large array of each type and used constant numeric indecies. That's what Excel requires.

UnoriginalGuy 13y ago
Excel cells have been nameable since forever... It also has supported types since forever. I'm literally talking Excel 2000 or older functionality[1][2]. With respect do you even know how to use Excel? Because everything you just said is incorrect. [1] http://www.computerhope.com/issues/ch000704.htm http://www.computerhope.com/issues/ch000704.htm [2] http://support.microsoft.com/kb/274504 http://support.microsoft.com/kb/274504
- jeltz 13y ago
  Anecdotally I have to strongly disagree here. Only one of the tens of heavy users of Excel I have worked with know of this feature on others like it. I am not a heavy use of Excel but my theory is that this is due to a failure of explanation by the software. Excel does not by its design encourage good coding, and most of the users of Excel do not have any programming background so they do not realize that these features should even be there so they wont know to look it up in the manual.
  - eigenvector 13y ago
    And it's easy to write horrifically bad, but working, code in C or C++. How exactly do you propose Excel butt into your workflow to expose advanced features? If you plan to use Excel to aid you in making serious money (as countless business do), can't you fork out a thousand extra for an employee who actually knows how to use Excel properly?
- andreasvc 13y ago
  Naming a single cell doesn't solve the problem of accidentally using a different range of values. In a normal programming language you would define a variable such as GDP containing a list of values for the countries of interest, in Excel every formula has to restate the range, which is what caused the mistake.
  - LyndsySimon 13y ago
    That's not the case. You can have named ranges in Excel - in fact, you can have named ranges which are dynamically calculated based on a formula.

by dspeyer 13y ago

UnoriginalGuy 13y ago

Excel cells have been nameable since forever... It also has supported types since forever. I'm literally talking Excel 2000 or older functionality[1][2]. With respect do you even know how to use Excel? Because everything you just said is incorrect. [1] http://www.computerhope.com/issues/ch000704.htm http://www.computerhope.com/issues/ch000704.htm [2] http://support.microsoft.com/kb/274504 http://support.microsoft.com/kb/274504

jeltz 13y ago
Anecdotally I have to strongly disagree here. Only one of the tens of heavy users of Excel I have worked with know of this feature on others like it. I am not a heavy use of Excel but my theory is that this is due to a failure of explanation by the software. Excel does not by its design encourage good coding, and most of the users of Excel do not have any programming background so they do not realize that these features should even be there so they wont know to look it up in the manual.
- eigenvector 13y ago
  And it's easy to write horrifically bad, but working, code in C or C++. How exactly do you propose Excel butt into your workflow to expose advanced features? If you plan to use Excel to aid you in making serious money (as countless business do), can't you fork out a thousand extra for an employee who actually knows how to use Excel properly?
andreasvc 13y ago
Naming a single cell doesn't solve the problem of accidentally using a different range of values. In a normal programming language you would define a variable such as GDP containing a list of values for the countries of interest, in Excel every formula has to restate the range, which is what caused the mistake.
- LyndsySimon 13y ago
  That's not the case. You can have named ranges in Excel - in fact, you can have named ranges which are dynamically calculated based on a formula.