473,765 Members | 2,121 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1945
On Wed, 03 Dec 2003 06:55:05 GMT, "Colleyvill e 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.spa m.cox.net> wrote in message
news:5m******** *************** *********@4ax.c om...
On Wed, 03 Dec 2003 06:55:05 GMT, "Colleyvill e 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
2829
by: John Bentley | last post by:
Note this is crossposted to comp.lang.javacript and microsoft.public.dotnet.scripting. After some Googling and FAQing my understanding of these terms is, crudely: Javascript (3 different definitions): 1. The scripting language originally developed by Netscape. (I offer a Brief handle: "Original Netscape Script") 2. The current implementation of the ECMAscript 262 (3rd ed.) standard by Netscape. (I offer a brief handle: "Current...
10
1773
by: barcaroller | last post by:
Can anyone tell me what the difference is between the 3rd Edition and the Special Edition of Stroustrup's "The C++ Programming Language"?
1
1302
by: Stephanie Wright | last post by:
I'm having a probem with my 3rd and 4th boxes not showing the correct data to pick. My database is normalized and I have Me! statements for each combo box in the After Update but something is quirky about it. Also I have a subform that is supposed to show the results and it does for the first 2 but not for the 3rd and 4th. I'm not using the child link method, it's in the code for that too. Any ideas what might be wrong? *** Sent via...
9
6619
by: VMI | last post by:
I have two tables and I want to compare these two tables with a query( ie. "select * from A where B.key = A.key") and the result will be stored in a 3rd table (table C). is this possible? If necessary, I can create the schema for the 3rd table (C) since it'll be exactly like table A. But I'm more interested in being able to store the resulting set into another table. Thanks.
5
1032
by: nicholas | last post by:
Have a multi-page subscribtion. So the user fills in some data on the first page, than an other part on the 2nd and the last part on the 3rd page. What is the best and simplest way to get all the inserted data on the 3rd page to insert in de dbase? (not using request.querystring! as this is not secure) I tried with context, but I can't manage it to work.
0
1040
by: Dick Moores | last post by:
Several months ago I saw an item on the O'Reilly site to the effect that the 3rd. ed. of Programming Python was in the works. I made a note to myself to check back in January. I just did, but could find nothing at all about a 3rd. edition. Anyone know? Thanks, Dick Moores
1
1955
by: Mike | last post by:
Hi, I'm auctioning the book "The C++ Programming Language" 3rd Ed. by Bjarne Stroustrup on ebay, details as follows or see eBay item number 250030480853. Softback. Condition : Good. Pub. Addison Wesley 1997. 3rd Edition. 910 pages. "The C++ Programming Language" by Bjarne Stroustrup is the classic C++
7
1945
by: Lycan. Mao.. | last post by:
Hello, I am a newbie in C++ and I'm in trouble in choosing books, I hope some one who can give me some tips. I'm already know C and a little about Scheme, C#, Python, Lua and so on, and now I want to use C++. After reading parts of "Accelerated C++", I feel so good about it (both the language and the book) and want to pick "C++ Primer" to have a deeper look into C++. But you see, there are two "C++ Primer" --- the 3rd and the 4th. Of...
3
2287
by: travellinman | last post by:
Hi, I'm trying to combine the text in two original fields and paste them into another 3rd field on a form, but the problem is that there are leading zeros in both original fields, which access does not copy into the 3rd field. For example, if field 1 = 07 and field 2 = 0001, i'd like the 3rd field to be 070001, but instead access returns 71 in the 3rd field. Adding to the complexity a bit is that field 2 is an autonumber field. so when i...
8
2485
by: Cerian | last post by:
Hi there, I'm having trouble getting my 3rd dependent combo box to work in Access 2003. I have three dependent boxes named cbogroup, cbosection and cbofunction. Each one is dependent on the selection made in the previous box. All of these appear on one form called 'records subform'. The information for each box is taken from a different table. The first from 'functional group' which has only 2 fields: 'group' and 'group code'. The...
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9398
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9951
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9832
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8831
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5275
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5419
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2805
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.