You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by madhavilr <Ma...@kpitcummins.com> on 2012/09/21 09:12:37 UTC
implementing Paste Special feature of excel copying
Hi,
Want to know if there is any way we can program the generated xls using poi,
so that if user copy-pastes data from somewhere else, it automatically
pastes as “Paste Special -> Values”, so that only values are pasted and not
the cell formatting e.g. bg colors ?
Thanks in advance,
Madhavi.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/implementing-Paste-Special-feature-of-excel-copying-tp5710970.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: implementing Paste Special feature of excel copying
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
...and this might well get you started -
http://www.excel-vba.com/vba-prog-1-10-vba-excel-events.htm
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/implementing-Paste-Special-feature-of-excel-copying-tp5710970p5710999.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: implementing Paste Special feature of excel copying
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
I suspect that the only way to accomnplish this is with VBA. You will need to
use Excell itself to create a macro and then save that workbook as a
template - POI does not yet support the creation of macro code. Next, use
this template as the basis for every workbook you create using POI where you
want the substitute paste function to operate.
All of this is based on the assumption that you can hijack the paste event
and 'convert' it into a paste special event. I am sorry to say that I
suspect this is a question for an Excel forum and, off hand, I do not know
of any. Still, Google is your friend here I suspect.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/implementing-Paste-Special-feature-of-excel-copying-tp5710970p5710997.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org