Page 1 of 1

How to copy HTML as TEXT value to window clipboard?

Posted: Wed May 14, 2014 12:32 am
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~

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

Posted: Wed May 14, 2014 1:40 am
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.

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

Posted: Wed May 14, 2014 4:45 am
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!

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

Posted: Wed May 14, 2014 12:23 pm
by requinix
Then the opposite of what I said: make sure the cell is formatted as text and not a number.

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

Posted: Wed May 14, 2014 9:38 pm
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?

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

Posted: Thu May 15, 2014 4:10 am
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.