'Re: Copy As Text, was: Re: question about freeze and patch'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: Copy As Text, was: Re: question about freeze and patch
From:       John Dailey <dailey () vt ! edu>
Date:       2002-04-12 14:20:53
[Download RAW message or body]

Apparently both the submitter of the bug and myself were confused about the 
purpose of the "copy as text" vs. "copy" functions.  I don't think it's very 
intuitive that "copy as text" will copy what I see on the screen while the 
"copy" will copy mimetyped data.  If I'm Joe user wanting to copy my 
spreadsheet results into a text file, my gut reaction is to highlight it and 
hit ctrl+c.  I suppose when that doesn't work I'd hunt through the menus and 
decide to try copy as text.

There's a bug in either case, because without any patch, copy as text on one 
cell will copy the formula and copy as text on a region will copy the 
results.

Also, I think this points out a big weakness in that there is no help for menu 
items on the status bar.  A hint about what each of these is supposed to do 
would be extremely helpful.  I'll try to take care of that this weekend (I'll 
be gone all next week).

John
dailey@vt.edu

On Friday 12 April 2002 04:29 pm, Norbert Andres wrote:
> On Friday 12 April 2002 11:48, John Dailey wrote:
> > Actually, I believe that is what they want -- this "copy as text" is a
> > different operation than just selecting the cell and Ctrl+C copy.  Look
> > in the menu and they're two different options.  I could be wrong but I
> > thought that was the point of copy as text.
> >
> > Am I wrong in assuming that "copy" copies the output in the cell (what
> > you see) and "copy as text" is supposed to copy the input to the cell
> > (what you typed)?
>
> No, for me "copy as text" is the only chance to copy data to another
> application, because other applications cannot understand the mimetype of
> kspread. So, I create a table and calculate some data: what I want to send
> to somebody else is not the way I created the data (the formulas) but the
> results. What would you want to do with a table in an email/other document
> which contains something like:
>
> Results 2001
> A		B			C
> Months	+			-
> Jan		2000			1500
> Feb		3000			3400
> Mar		...			...
> ...
> Sum		=SUM(B1:B12)	=SUM(C1:C12)
>
> Result 	=B14-C14
>
> This information would be useless. Because you might know what income you
> had (+) how much money you spend (-), but you are interested in "did I earn
> money last year".
> Or using KSpread for that would be useless, because KSpread does some work
> for you. But you just see how it does the work (what you know as well) and
> not the result (which you don't know). If I want somebody to be able to
> calculate the data for himself, I'll send him a kspread file.
>
> That's why I suggest copying the strOutText() instead of text() is better,
> so copying the results to the clipboard.
>
> Regards
> Norbert
>
> > -John
> >
> > > If you have a table like
> > >
> > > 	A	B
> > > 1	2	4
> > > 2	=A1+B1
> > >
> > > The user wants
> > > 2	4
> > > 6
> > > to be inserted in e.g. KMail. And not the formula which wouldn't be
> > > really useful in this case. (That's at least what I think)
> > >
> > > I would apply this instead: (to fix the spaces between columns in text
> > > mode)
> > >
> > > Index: kspread_table.cc
> > > ===================================================================
> > > RCS file: /home/kde/koffice/kspread/kspread_table.cc,v
> > > retrieving revision 1.337
> > > diff -u -r1.337 kspread_table.cc
> > > --- kspread_table.cc    2002/04/11 20:11:45     1.337
> > > +++ kspread_table.cc    2002/04/12 05:17:52
> > > @@ -3963,6 +3963,8 @@
> > >        }
> > >      }
> > >
> > > +    ++max;
> > > +
> > >      for (y = m_rctSelection.top(); y <= m_rctSelection.bottom(); ++y)
> > >      {
> > >        for (x = m_rctSelection.left(); x <= m_rctSelection.right();
> > > ++x) @@ -3971,8 +3973,9 @@
> > >          if( !cell->isDefault() )
> > >          {
> > >              int l = max - cell->strOutText().length();
> > > -            for ( int i = 0; i < l; ++i )
> > > -              result += " ";
> > > +            if (x > m_rctSelection.left())
> > > +                for ( int i = 0; i < l; ++i )
> > > +                  result += " ";
> > >              result += cell->strOutText();
> > >          }
> > >          else
> > >
> > >
> > > Regards
> > > Norbert
> > >
> > > On Friday 12 April 2002 01:39, John Dailey wrote:
> > > > According to the release schedule, as of today "KOffice is
> > > > temporarily frozen".  Does this mean we need to post patches on this
> > > > list?  Or do we still commit at will, but only bugfixing patches?
> > > >
> > > > Just in case, here's a patch to fix bug 40465 (Copy as text doesn't
> > > > work if more than one cell is selected).
> > > >
> > > > -John
> > >
> > > _______________________________________________
> > > koffice-devel mailing list
> > > koffice-devel@mail.kde.org
> > > http://mail.kde.org/mailman/listinfo/koffice-devel
> >
> > _______________________________________________
> > koffice-devel mailing list
> > koffice-devel@mail.kde.org
> > http://mail.kde.org/mailman/listinfo/koffice-devel
>
> _______________________________________________
> koffice-devel mailing list
> koffice-devel@mail.kde.org
> http://mail.kde.org/mailman/listinfo/koffice-devel

_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread] 