468,114 Members | 2,095 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,114 developers. It's quick & easy.

3rd-party spreadsheet supports Windows clipboard but formatting is lost.

I am using Access and have embedded the ActiveX control Formula One that
came with Office 2000. (ver 3.04). I have created and formatted a
spreadsheet and now I want to copy the info with formatting to another
program.

The help file reads: "Formula One maintains its own internal clipboard and
also supports text on the Windows clipboard. The internal clipboard is more
flexible than the Windows clipboard. The internal clipboard retains formulas
and allows cell references to be adjusted when cells are pasted. The Windows
clipboard only holds text, and formatting; cell references are not
maintained by the Windows clipboard."

Well, it says that the Windows clipboard ",,,only holds text and formatting,
....". As I read that, the Windows clipboard holds text along with the
formatting. But when I try to paste data to another app, it only shows up
as unformatted text. They have unusual punctuation in that sentence with
the comman and semicolon causing a bit of confusion. Thus, I'm not sure if
they meant to group "text and formatting" together, or if they meant that
"formatting and cell references" should be grouped together (i.e. both would
be lost).

Anyhow, does anyone know if
1 - the Windows clipboard holds formatting?
2 - the registered version of Formula One has a clipboard that will post
formatted info to other apps?
FYI, I want to PasteSpecial as Picture in PowerPoint and if this can't do
that, I'll have to look elsewhere.
So question #3 - does anyone know of a grid whose clipboard control will
support formatting such that I can past an image into PPT?

Thanks.
Nov 12 '05 #1
2 1639
On Wed, 03 Dec 2003 06:55:05 GMT, "Colleyville Alan"
<ae***********@nospam.comcast.net> wrote:

Find out if the format is CF_TEXT. If it is, that's text only, and
"formatting" should be taken with a grain of salt.

CF_TEXT, as the word suggests, cannot handle pictures. I would be
looking into using Automation.

Otherwise, direct your questions to the manufacturer.

-Tom.

I am using Access and have embedded the ActiveX control Formula One that
came with Office 2000. (ver 3.04). I have created and formatted a
spreadsheet and now I want to copy the info with formatting to another
program.

The help file reads: "Formula One maintains its own internal clipboard and
also supports text on the Windows clipboard. The internal clipboard is more
flexible than the Windows clipboard. The internal clipboard retains formulas
and allows cell references to be adjusted when cells are pasted. The Windows
clipboard only holds text, and formatting; cell references are not
maintained by the Windows clipboard."

Well, it says that the Windows clipboard ",,,only holds text and formatting,
...". As I read that, the Windows clipboard holds text along with the
formatting. But when I try to paste data to another app, it only shows up
as unformatted text. They have unusual punctuation in that sentence with
the comman and semicolon causing a bit of confusion. Thus, I'm not sure if
they meant to group "text and formatting" together, or if they meant that
"formatting and cell references" should be grouped together (i.e. both would
be lost).

Anyhow, does anyone know if
1 - the Windows clipboard holds formatting?
2 - the registered version of Formula One has a clipboard that will post
formatted info to other apps?
FYI, I want to PasteSpecial as Picture in PowerPoint and if this can't do
that, I'll have to look elsewhere.
So question #3 - does anyone know of a grid whose clipboard control will
support formatting such that I can past an image into PPT?

Thanks.


Nov 12 '05 #2
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:5m********************************@4ax.com...
On Wed, 03 Dec 2003 06:55:05 GMT, "Colleyville Alan"
<ae***********@nospam.comcast.net> wrote:

Find out if the format is CF_TEXT. If it is, that's text only, and
"formatting" should be taken with a grain of salt.

CF_TEXT, as the word suggests, cannot handle pictures. I would be
looking into using Automation.


Thanks. I *am* using Automation, but wanted to use this 3rd party component
in place of Excel because working with Excel directly was much slower.
Also, the MS Office Spreadsheet (Web Component) included with Access seemed
to lack wordwrap and a few other formatting commands - hard to tell since
there is no decent documentation included.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by barcaroller | last post: by
reply views Thread by Dick Moores | last post: by
7 posts views Thread by Lycan. Mao.. | last post: by
3 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.