By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,677 Members | 1,890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,677 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
"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.