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:
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....
Any kind experts can please help me? Thank you~
How to copy HTML as TEXT value to window clipboard?
Moderator: General Moderators
How to copy HTML as TEXT value to window clipboard?
Last edited by WWF222 on Wed May 14, 2014 4:24 am, edited 3 times in total.
Re: How to copy HTML as TEXT value to window clipboard?
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?
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!
I have edited the post, to make it more clear. Thanks Ya!
Re: How to copy HTML as TEXT value to window clipboard?
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?
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?
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?
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.
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.