How to copy HTML as TEXT value to window clipboard?

JavaScript and client side scripting.

Moderator: General Moderators

Post Reply
WWF222
Forum Newbie
Posts: 3
Joined: Tue May 13, 2014 10:41 pm

How to copy HTML as TEXT value to window clipboard?

Post by WWF222 »

Hi my dear expert friends here,

Can help me with this problem as stated above?

Problem details:

I need to copy a table from HTML and paste it to Lotus Approach. But when i copy a fraction(1 1/8) from HTML and paste it , it become 1.125.

Below picture show the output when i copy and pasted to excel file, it look like window will auto change a fraction(1 1/8) become a floating value(1.125) after copy from a HTML:
window will auto change a fraction(1 1/8) become a floating value(1.125) when copy from a HTML
window will auto change a fraction(1 1/8) become a floating value(1.125) when copy from a HTML

this is what i want it to copy and when i paste it, it remain as a text value which is 1 1/8 not change to 1.125....
this is what i wish to get....
this is what i wish to get....

Any kind experts can please help me? Thank you~
Last edited by WWF222 on Wed May 14, 2014 4:24 am, edited 3 times in total.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: How to copy HTML as TEXT value to window clipboard?

Post by requinix »

Make sure the cell is formatted as a number. If that doesn't do it then you'll probably have to put "1.125" in your HTML because otherwise it won't know how to deal with what you have on your clipboard.
WWF222
Forum Newbie
Posts: 3
Joined: Tue May 13, 2014 10:41 pm

Re: How to copy HTML as TEXT value to window clipboard?

Post by WWF222 »

Hi requinix, thank you for your kind reply. Sorry that my poor english make u miss understand. Actually i want to ask, how to make clipboard that copy from a HTML with value 1 1/8 to remaind as 1 1/8 when paste in Lotus or Excel file? My problem now is after i copy 1/8 and paste it to excel, it will paste as 1.125, it didnt remain as 1 1/8.

I have edited the post, to make it more clear. Thanks Ya!
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: How to copy HTML as TEXT value to window clipboard?

Post by requinix »

Then the opposite of what I said: make sure the cell is formatted as text and not a number.
WWF222
Forum Newbie
Posts: 3
Joined: Tue May 13, 2014 10:41 pm

Re: How to copy HTML as TEXT value to window clipboard?

Post by WWF222 »

Hi requinix, thank again for your reply.

how to format a table cell in a HTML to text not number?
Ok i will tell the details about my problem.
I have just entered this company, and which they are still using lotus approach. I'm php web developer that developing a php web to integrate with the old lotus approach. I have no experience on lotus either.

Now that I have done created a website and just use normal manual(ctrl+c) to copy a table in HTML format, and i wanted to pass the copied data to Lotus Approach(previous lotus developer create a button with paste function).
While i paste it to Lotus, it show me a message that data not match. Therefore i paste it to an Excel file just to see the pasted output format. When i paste it to excel, i found that all data are "genaral" format except "1 1/8" changed to "1.125" with "fraction" formate(as shown in the picture attached).

Did u have any ideal?
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: How to copy HTML as TEXT value to window clipboard?

Post by requinix »

I don't know Lotus Approach either. I do know that it's a database system and not a spreadsheet which means Excel has absolutely nothing to do with any of this.

Maybe the system is expecting a number? You'd have to change it to a text.

If you can't find the answer yourself then you might be out of luck considering how little information there is about it available - there doesn't even seem to be any references to it on IBM's own site.
Post Reply