Re:Ask HN: Language compiled to Excel spreadsheets?
by gus_massa on Friday July 24, 2015 @07:09PM
(#9945778)
The problem is that the spreadsheets are 2D, so you iterate easily over two variables, the row and the column.
If you need to "program" this in an Excel spreadsheet
For i = 1 to 5
For j = 1 to 5
If 2 * i + j = i * j then
Print i, j, "*"
End If
Next
Next
You can "write" this in a 6x6 block with the values 1 2 3 4 5
1 =If(2*B$1+$A2=B$1*$A2, "*", "")
2
3
4
5
And copy the formula from B2 to all the cells, so you get 1 2 3 4 5
1
2
3 *
4 *
5
Re:Ask HN: Language compiled to Excel spreadsheets?
by dang on Saturday July 25, 2015 @01:30AM
(#9946664)
Ah, that's what I thought you might mean. Can you talk about why you use spreadsheets in the first place, then? You're dealing with nontrivial problems if you hit this limitation, and you could write programs in a general-purpose language if you wanted to. So what do you get from Excel?
(I care about this, btw, because my real job is making a new spreadsheet.)
Re:Ask HN: Language compiled to Excel spreadsheets?
by bradleyland on Friday July 24, 2015 @03:02PM
(#9944370)
I don't know what the limit for `for` loops is, but Excel has some limits to nesting of flow control structures like `if`. For example, you cannot nest `if` statements more than seven deep. I suspect the parent poster is referring to a limitation similar to this, but for nesting `for` loops.
I'm curious what you mean by this. Care to explain?