What is the terminology and concept behind this? It is probably easy to learn about if we knew the name of this oddity.
Our spreadsheet shows formulas that show like this:
{sum(if(...))}(1,1)[0][0]
The ... indicates omitted detail. We want to modify the formula to get data from a different column, but any attempt to edit the formula causes the curly brackets and stuff at the end to vanish. Then the cell shows "#VALUE!" unless we back out of the change.
Related to this is that when we save this spreadsheet in Gnumeric, and try to read it in Excel (not sure which version) the curly brackets and funny stuff don't appear unless we are careful to save it as "Excel 5.0/95", we wear the right color socks, and Mercury is trine with Jupiter... Is there a more reliable, version-independent way to accomplish whatever magic is going on?
BTW, google isn't any good at searching for "(1,1)[0][0]"!
Our spreadsheet shows formulas that show like this:
{sum(if(...))}(1,1)[0][0]
The ... indicates omitted detail. We want to modify the formula to get data from a different column, but any attempt to edit the formula causes the curly brackets and stuff at the end to vanish. Then the cell shows "#VALUE!" unless we back out of the change.
Related to this is that when we save this spreadsheet in Gnumeric, and try to read it in Excel (not sure which version) the curly brackets and funny stuff don't appear unless we are careful to save it as "Excel 5.0/95", we wear the right color socks, and Mercury is trine with Jupiter... Is there a more reliable, version-independent way to accomplish whatever magic is going on?
BTW, google isn't any good at searching for "(1,1)[0][0]"!