Re: Copy or Drag from a listbox?

[Keith Goebel via 4D_Tech]

I’d like to offer a belated thank you to everyone who replied to my post and 
offered suggestions how to do it.
Much food for thought.
Cheers, Keith
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[info--- via 4D_Tech]

when using selection listbox don't forget QuickReport for exporting.
- create a qr
- copy listbox-columns into qr-columns
- use selection
- set qr destination
- qr run
done


Regards
O r t w i n Z i l l g e n
-
Mitglied des Entwicklernetzwerkes www.die4dwerkstatt.de
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Arnaud de Montard via 4D_Tech]

> Le 7 mars 2017 à 10:33, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> a écrit :
> 
> [...]
> 
> I have done something similar from a button on the form, but the list box was 
> array based. A bit easier, because I could loop over the arrays to get the 
> data out of them.

With a selection listbox, execute on server is (quite) mandatory, for 
performance reasons. Some formula columns can be difficult (ex: formula using 
data loaded on client side only). 

-- 
Arnaud de Montard 




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Koen Van Hooreweghe via 4D_Tech]

Hi Keith,

For copy/paste you have to put a tab delimited text on the pasteboard.

First of all you'll have to intercept the cmd-c and Copy menu items in 4D to 
make it run your code when the listbox has focus.
Then run over the selected lines (records) to get the data. Finally loop over 
the fields set in the columns to get the right data.

A bit of work, but can be done IMHO.

I have done something similar from a button on the form, but the list box was 
array based. A bit easier, because I could loop over the arrays to get the data 
out of them.

Kind regards,
Koen

Op 6-mrt.-2017, om 20:26 heeft Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> 
het volgende geschreven:

> I can't think how to do it using copy/paste.



—
Koen Van Hooreweghe
—


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Chip Scheide via 4D_Tech]

I do not have any ideas to add to the suggestions for getting the data 
out of 4D.
BUT - to D multiple line hold the option/alt key while dragging

On Tue, 7 Mar 2017 08:26:04 +1300, Keith Goebel via 4D_Tech wrote:
> Hi all.
> A client has asked: 
> I have the list (selection based listbox) showing  the records I'm 
> interested in, and I have set the columns to show only those I want 
> and put them in the order I want them (all available from the list 
> interface).
> Why can't I select the rows and copy/paste or drag and drop them onto 
> an Excel spreadsheet instead of having to go through the export 
> interface? (they select the fields and order to export).
> 
> Using 4D v15.2 on Win7, I've played briefly with setting a listbox to 
> Draggable and tried dragging a selected row to an Excel spreadsheet 
> and also to a NotePad++ doc, but nothing happens.
> I don't think drag and drop can be done because if you click a row 
> (to drag it) that is already selected with other rows, only that row 
> remains selected.
> 
> I can't think how to do it using copy/paste.
> 
> If we could do this, it would certainly be a big plus for our 
> application in the eyes of our users (well, this particular user 
> anyway :-).
> 
> Does anyone know if the above idea is possible?
> Cheers, Keith
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Scott Staley via 4D_Tech]

Keith,

A gentleman by the name of Flury Olivier offered a databrowser component to
this mailing list a few months back.  Here is the link to his thread.

  http://4d.1045681.n5.nabble.com/Databrowser-component-td5740863.html

The databrowser component includes another component called FSUty.  It is a
package of utilities that he uses to support the databrowser and I assume
other databases as well.  The utility component includes a group of listbox
methods and one of the methods called UtyLB_SelectionToText will copy a
selection based listbox into a text variable.  From there you can just
execute SET TEXT TO PASTEBOARD($t_theData) to put the text variable into the
clipboard.

The components can be downloaded from the above link.



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Copy-or-Drag-from-a-listbox-tp5750587p5750601.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Keith Goebel via 4D_Tech]

Thanks to John and Kirk for your ideas.
Cheers, Keith
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Spencer Hinsdale via 4D_Tech]

http://kb.4d.com/assetid=49867 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Copy or Drag from a listbox?

[Keith Goebel via 4D_Tech]

Hi all.
A client has asked: 
I have the list (selection based listbox) showing  the records I'm interested 
in, and I have set the columns to show only those I want and put them in the 
order I want them (all available from the list interface).
Why can't I select the rows and copy/paste or drag and drop them onto an Excel 
spreadsheet instead of having to go through the export interface? (they select 
the fields and order to export).

Using 4D v15.2 on Win7, I've played briefly with setting a listbox to Draggable 
and tried dragging a selected row to an Excel spreadsheet and also to a 
NotePad++ doc, but nothing happens.
I don't think drag and drop can be done because if you click a row (to drag it) 
that is already selected with other rows, only that row remains selected.

I can't think how to do it using copy/paste.

If we could do this, it would certainly be a big plus for our application in 
the eyes of our users (well, this particular user anyway :-).

Does anyone know if the above idea is possible?
Cheers, Keith

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**