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

[Colleyville Alan]

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.

[Tom van Stiphout]

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.

[Colleyville Alan]

"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.