'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:       "Michael Marcucio" <michaelmarcucio () hotmail ! com>
Date:       2002-04-12 18:50:52
[Download RAW message or body]

here is an idea that worked for me but i am not sure if it fits in the 
koffice/kde way of doing things:

I think the correct way to do it(IMHO) is to have 2 clipboards. when a user 
does a copy it copies the plain text to the system clipboard and the 
kword/sheet/whatever mimedtype data to an internal clipboard used only by 
that application. when a paste occurs outside the program everything works 
great because there is plain text on the clipboard. when a paste occurs in 
kword/spread/whatever we figure out which clipboard to paste from. if system 
clipboard still is the plain text equlivant of the internal clip then paste 
from internal clip else paste from the external clip(there was anoter copy 
outside the program)

mike

>From: Norbert Andres <nandres@web.de>
>Reply-To: koffice-devel@mail.kde.org
>To: koffice-devel@mail.kde.org
>Subject: Re: Copy As Text, was: Re: question about freeze and patch
>Date: Fri, 12 Apr 2002 20:41:24 +0200
>
>On Friday 12 April 2002 16:20, John Dailey wrote:
> > 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.
>
>What do you want to do instead? Most application won't understand what 
>Ctrl+c
>puts to the clipboards (in fact no application), so right now "copy as 
>text"
>is the only way. The best solution would be to copy something to the
>clipboard, that keeps all the data (incl formulas) for inserting in KSpread
>again, but provides pure text for other applications. But I have really no
>idea how to do that.
>
>I think the way right now is not bad, because if I want to paste something 
>in
>KMail, I know that it has to be pure text. So I chose "Copy as text" (copy
>won't work at all anyway).
>
>The only question for me right now is: do we copy results or formulas?
>Why do you want to copy results?
>As mentioned in my previous mail I see no use in copying the anything else
>than the results.
>
> > 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.
>Yes, and what do you want to get? Result or formula?
>Still: ctrl+c for both ways would be the best.
> >
> > 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.
>No, not with the recent source.
>
> >
> > 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).
>
>Good idea!
>
>Ok, but what do we do now? Change for copying the formula or copying the
>result.
>
>Norbert
> >
> > 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
>
>_______________________________________________
>koffice-devel mailing list
>koffice-devel@mail.kde.org
>http://mail.kde.org/mailman/listinfo/koffice-devel

_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

_______________________________________________
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] 