From koffice  Tue Jun 03 19:48:31 2003
From: Ferdinand Gassauer <gassauer () kde ! org>
Date: Tue, 03 Jun 2003 19:48:31 +0000
To: koffice
Subject: Re: Kspread - big usability issues
X-MARC-Message: https://marc.info/?l=koffice&m=105466983011146

Thomas Zander wrote:

> On Tue, Jun 03, 2003 at 09:15:06AM +0200, Luk?? Tinkl wrote:
>> Dne po 2. ?ervna 2003 19:59 Ferdinand Gassauer napsal(a):
>> > Hi!
>> > The following bugs represent a major usability problem and render the
>> > whole program obsolete. - unfortunately -
>> > IMHO this should be fixed for the next beta release to not upset tester
>> > http://bugs.kde.org/show_bug.cgi?id=58094
>> > http://bugs.kde.org/show_bug.cgi?id=58652
>> 
>> Yes, IMO the second bug is _very_ grave.
> 
> Notice that there are several issues in behavior where it differs
> from excel or openoffice.  Some not very logical behavior is happening
> there :) Anyway; you might want to look at how openoffice does things (its
> the same as excel).
> I was really wondering in the last bug if the c1 value was '=A1+$B$1' why
> both excel and openoffice alter the '$B$1' when I move C1 or B1...
> 
I do not  understand your wondering?
It's absolutely mandatory that cut/paste actions retain the inherent meaning
of the formula, that is the reference to the content of the cell. So if the
content is moved the coordinates of the cell have to be adapted. Otherwise
it would not be possible to rearrange cells without destroying the results.

But I agree that there are rare occasions where the current behavior of
kspread  would be useful. But it's easy to work around this problem
1) copy the content from cell (A) to cell (B)
2) erase cell (A)

For copy/paste it's a different story.

-- 
cu
ferdinand
____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
http://mail.kde.org/mailman/listinfo/koffice