[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: Norbert Andres <nandres () web ! de>
Date: 2002-04-13 17:41:03
[Download RAW message or body]
On Saturday 13 April 2002 17:31, Eva Brucherseifer wrote:
> > 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.
>
> Is the opposite way possible with kspread? And if not, would it be possible
> to add it?
>
> What I have, is an email with CSV-like data, but seperated by ":" and I'd
> like to insert it into a kspread sheet. Right now it insert everything into
> one cell.
Right now it's not possible. You have to save in a file first.
But it's a nice idea. I'll put in my TODO list.
Norbert
>
> Greetings,
> eva
>
> > 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
>
> _______________________________________________
> 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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic