Google| Subject | Re: spreadsheet ergonomics |
| From | Snit |
| Date | 04/08/2017 08:44 (04/07/2017 23:44) |
| Message-ID | <D50DD4D0.9DB22%usenet@gallopinginsanity.com> |
| Client | |
| Newsgroups | comp.os.linux.advocacy |
| Follows | owl |
On 4/7/17, 11:23 PM, in article sczuv993.vy@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
owlHmmm, a sub-table? It does seem it uses the term inconsistently. Odd.
Snit <usenet@gallopinginsanity.com>wrote:Snitowl
On 4/7/17, 10:57 PM, in article ahvu003.ak3@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:
...Snitowl
Right... you can sort RANGES. ----- @index(e,r)
Use the value of the expression e to index into the range r. The numeric value at that position is returned. The value 1 selects the first item in the range, 2 selects the second item, etc. R should be either a single row or a single column. -----
I wonder why snipped this part about the index() function:
"With three arguments, the range must come first, and the second and third arguments will then be interpreted as row and column, respectively, for indexing into a two-dimensional table."
I've had enough of your bullshit. Plonk.LOL! You just do not like I called you out on your claim that a range of cells is a table and not, well, a range. There are times, as I showed with Excel, where a range can be treated like a table... and maybe they are trying to use this meaning in the sc documents. They should have a glossary!
Ok, looked for a spreadsheet glossary:
<http://w.sunybroome.edu/basic-computer-skills/functions/spreadsheets/2sprea dsheets_terminology.html>OR <http://tinyurl.com/n3h35bh>
Does not have the term "table" in it!
<http://jhigh.co.uk/ComputingSG/GPPs/SpreadSheets/Spreadsheet_Glossary.html> ----- A table is made up of data arranged in rows and columns like a spreadsheet and data is placed in the cells. -----
"like a spreadsheet". One table in the spreadsheet. OK.
<https://docs.google.com/document/d/1u93XLrLsV2vTlmnHab5o4wTzrsryShln9LyraZW 0bt4/edit#heading=h.g6f90lkgsqwf>OR <http://tinyurl.com/l5df2up>
Again no "table", but notes a range is what I say (and what you keep calling a table... except when you call it a pseudo-table): ----- Range or Array
A group of cells is called a range. The range highlighted below is A1:C11 and contains all of the cells in rows 1-11 across columns A, B, and C. When a range is used in a formula it is called an Array -----
Found some other definitions... but they leave wiggle room both ways. But seems you think it makes sense to refer to ranges in tables as tables, too... which is a bit silly to me.
Oh, and, no, I do not think for a second you really plonked me. Even though I have made it clear sc is a FAR better tool for the job of creating large tables with many preset formulas and even with pre-populated data you will want to rub it into my face and find ways to deny the benefits I showed in Numbers. :)
-- Personal attacks from those who troll show their own insecurity. They cannot use reason to show the message to be wrong so they try to feel somehow superior by attacking the messenger.
They cling to their attacks and ignore the message time and time again.
<https://youtu.be/H4NW-Cqh308>
03/31/2017-
-
-
