Hi --
There are many situations where it is desirable to copy data from
one region to another on the spreadsheet. This is particularly
common when part of one sheet tracks part of another sheet.
AFAICT, copying is nontrivial when the source contains empty cells.
The simple "=" operator
On 6/3/20 7:09 PM, Morten Welinder wrote:
> You are better off creating a new function, say COPYVALUE, in fn-info
> to do the copying.
But doesn't that guarantee that my spreadsheets will be totally
un-portable?
I share spreadsheets with people, very few of whom are in a position
to compile
It's possible with CELL("contents",A42)
(I'm not saying that's a good idea, only that it is possible.)
M.
___
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Actually, it's not a good idea. Excel seems to return 0 in this case
making our result a bug.
You are better off creating a new function, say COPYVALUE, in fn-info
to do the copying.
M.
___
gnumeric-list mailing list
gnumeric-list@gnome.org
Thanks, I'll check it out.
Em qua, 3 de jun de 2020 22:39, Morten Welinder
escreveu:
> Goal-seek changes the cells. I don't see that happening in a sheet
> function.
>
> However, something like this could probably be done in Python using
> the introspection machinery. A good starting point
Goal-seek changes the cells. I don't see that happening in a sheet function.
However, something like this could probably be done in Python using
the introspection machinery. A good starting point for exploring that
is the code in test/t3001-introspection-simple.py which shows
basically how to