spiral
Member of DD Central
Posts: 910 
Likes: 456
|
Post by spiral on Jul 28, 2023 17:15:05 GMT
anyone know a simple way to .
paste from an excel grid into .
this table ?
|
|
|
|
|
|
| each of the above words came from a separate cell
|
|
|
|
|
|
| but after copy and paste, all went into same box.
|
|
|
|
|
|
| I wanted each word in its own box.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Jul 28, 2023 17:33:35 GMT
Try pasting the excel into this: theenemy.dk/table/Select BBCode in that and copy and paste the result into a post with BBCode selected here. BBCode is a pitta! Iirc I have locutus to thank for the converter link, it's been invaluable here! |
|
|
|
Post by overthehill on Jul 28, 2023 17:36:56 GMT
create an html file from excel. Then look for the section like below. replace all the < with [ and > with ]. Then paste into the BBCode mode and switch to preview mode. Worked for me. <table cellspacing="0" border="0"> <colgroup span="3" width="107"></colgroup> <tr> <td height="21" align="right" sdval="12" sdnum="2057;">12</td> <td align="right" sdval="22" sdnum="2057;">22</td> <td align="left">dsfsdfs</td> </tr> <tr> <td height="21" align="right" sdval="22" sdnum="2057;">22</td> <td align="right" sdval="22" sdnum="2057;">22</td> <td align="left">dsfdfsff</td> </tr> </table> |
|
spiral
Member of DD Central
Posts: 910
Likes: 456
|
Post by spiral on Jul 29, 2023 6:44:01 GMT
Try pasting the excel into this: theenemy.dk/table/Select BBCode in that and copy and paste the result into a post with BBCode selected here. BBCode is a pitta! Iirc I have locutus to thank for the converter link, it's been invaluable here! Thanks, I'll give it a try. overthehill, I did try your method after our private conversation and had some joy but there were some anomalies whereby once I reached a certain point in the table, the formatting went awry and the table failed to generate from that point onwards. I didn't want to keep pestering you so gave up. I then found this test area and had another go. 
|
|
|
|
Post by overthehill on Jul 29, 2023 8:32:58 GMT
Try pasting the excel into this: theenemy.dk/table/Select BBCode in that and copy and paste the result into a post with BBCode selected here. BBCode is a pitta! Iirc I have locutus to thank for the converter link, it's been invaluable here! Thanks, I'll give it a try. overthehill , I did try your method after our private conversation and had some joy but there were some anomalies whereby once I reached a certain point in the table, the formatting went awry and the table failed to generate from that point onwards. I didn't want to keep pestering you so gave up. I then found this test area and had another go.
You need to make sure none of the lines have extra and hidden cr/lf 's at the end effectively breaking a single line into two at a point not allowed.
|
|
spiral
Member of DD Central
Posts: 910
Likes: 456
|
Post by spiral on Jul 29, 2023 8:48:10 GMT
You need to make sure none of the lines have extra and hidden cr/lf 's at the end effectively breaking a single line into two at a point not allowed.
There was definitely something not right but as I said at the time, my table was about 6 columns by about 30 rows and the table was only getting to about the 5th box before failing so even if I'd identified the error, manually correcting it would've been a real pita.
|
|
