You need to be logged in to post in the forum - Log In

An active JCE Pro Subscription is required to post in the forum - Buy a Subscription

Support is currently Offline

Official support hours
Monday to Friday
09:00 - 17:00 Europe/London (BST)

Please create a new Ticket and we will get back to you as soon as we can.

#100111 import tables from LibreOffice fails

Posted in ‘Editor’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by mig69 on Monday, 03 June 2019 19:07 BST

mig69
Hi, I'm trying to import tables from LibreOffice in a joomla article with JCE Pro. My table is ok, in LibreOffice, I choose File -> See it in Web browser (not sure of the translation from my french LibreOffice...). I hit ctrl-U to see the source code and copy/paste in JCE (Code Tab). But when I then hit "Editor" the table is messed up except the 1st line. Then I go back to the "Code" Tab, and I can see that some translations have been realized (word "currentcolour") but, well... If I look at the cell properties, those of the 1st line are OK, but the others are not (I see some NAN...). Here is the initial code:

<table width="100%" cellpadding="4" cellspacing="0">
	<col width="85*"/>
	<col width="85*"/>
	<col width="85*"/>
	<tr valign="top">
		<td width="33%" style="border-top: 4.25pt solid #800080; border-bottom: 4.25pt solid #800080; border-left: 4.25pt solid #800080; border-right: none; padding-top: 0.1cm; padding-bottom: 0.1cm; padding-left: 0.1cm; padding-right: 0cm"><p>
			Sd fqsdf 
			</p>
		</td>
		<td width="33%" style="border-top: 4.25pt solid #800080; border-bottom: 4.25pt solid #800080; border-left: 4.25pt solid #800080; border-right: none; padding-top: 0.1cm; padding-bottom: 0.1cm; padding-left: 0.1cm; padding-right: 0cm"><p>
			Sdf 
			</p>
		</td>
		<td width="33%" style="border: 4.25pt solid #800080; padding: 0.1cm"><p>
			<br/>

			</p>
		</td>
	</tr>
	<tr></tr>
	<tr></tr>
	<tr></tr>
	<tr valign="top">
		<td width="33%" style="border-top: none; border-bottom: 4.25pt solid #800080; border-left: 4.25pt solid #800080; border-right: none; padding-top: 0cm; padding-bottom: 0.1cm; padding-left: 0.1cm; padding-right: 0cm"><p>
			<br/>
			</p>
		</td>
		<td width="33%" style="border-top: none; border-bottom: 4.25pt solid #800080; border-left: 4.25pt solid #800080; border-right: none; padding-top: 0cm; padding-bottom: 0.1cm; padding-left: 0.1cm; padding-right: 0cm"><p>
			Er ter 
			</p>
		</td>
		<td width="33%" style="border-top: none; border-bottom: 4.25pt solid #800080; border-left: 4.25pt solid #800080; border-right: 4.25pt solid #800080; padding-top: 0cm; padding-bottom: 0.1cm; padding-left: 0.1cm; padding-right: 0.1cm"><p>
			<br/>

			</p>
		</td>
	</tr>
</table>
And here it is after the "translation":

<table style="width: 100%;" cellspacing="0" cellpadding="4">
	<colgroup>
		<col width="85*" />
		<col width="85*" />
		<col width="85*" /> </colgroup>
	<tbody>
		<tr valign="top">
			<td style="border-color: #800080 currentcolor #800080 #800080; border-style: solid none solid solid; border-width: 4.25pt medium 4.25pt 4.25pt; padding: 0.1cm 0cm 0.1cm 0.1cm; width: 33%;">
				<p>Sd fqsdf</p>
			</td>
			<td style="border-color: #800080 currentcolor #800080 #800080; border-style: solid none solid solid; border-width: 4.25pt medium 4.25pt 4.25pt; padding: 0.1cm 0cm 0.1cm 0.1cm; width: 33%;">
				<p>Sdf</p>
			</td>
			<td style="border: 4.25pt solid #800080; padding: 0.1cm; width: 33%;">
				<p> </p>
			</td>
		</tr>
		<tr></tr>
		<tr></tr>
		<tr></tr>
		<tr valign="top">
			<td style="border-color: currentcolor currentcolor #800080 #800080; border-style: none none solid solid; border-width: medium medium 4.25pt 4.25pt; padding: 0cm 0cm 0.1cm 0.1cm; width: 33%;">
				<p> </p>
			</td>
			<td style="border-color: currentcolor currentcolor #800080 #800080; border-style: none none solid solid; border-width: medium medium 4.25pt 4.25pt; padding: 0cm 0cm 0.1cm 0.1cm; width: 33%;">
				<p>Er ter</p>
			</td>
			<td style="border-color: currentcolor #800080 #800080; border-style: none solid solid; border-width: medium 4.25pt 4.25pt; padding: 0cm 0.1cm 0.1cm; width: 33%;">
				<p> </p>
			</td>
		</tr>
	</tbody>
</table>
Any idea anybody ? Why does it work for the 1st line ? Thanks in advance, jc

Ryan
Please try JCE Pro 2.7.14 RC2 - https://www.joomlacontenteditor.net/downloads/editor/pro/development

Ryan Demmer

Lead Developer / CEO / CTO

Just because you're not paranoid doesn't mean everybody isn't out to get you.

mig69
Hi,
no change 🙁 When I'm in a cell of the 2nd line, then right-click -> Cell -> Table cell properties -> Advanced, in the Border section the width is Nan, the Style isn't set and the color is #nand7d7.
But the 1st line is OK. I tried to go on the first line, then right-click -> Cell -> Table cell properties -> Advanced, then choose "Update all cells in table" 😉 but when I click On the Update button nothing happens... 🙁

Ryan
I choose File -> See it in Web browser (not sure of the translation from my french LibreOffice...). I hit ctrl-U to see the source code and copy/paste in JCE (Code Tab).


Instead of viewing the source code, hit CTRL + A to select all the HTML, then paste this into the Editor (no the Code tab).

Do you get a better result with this method?

Ryan Demmer

Lead Developer / CEO / CTO

Just because you're not paranoid doesn't mean everybody isn't out to get you.

mig69
No. In that case, all formating is lost : size, color...

Ryan
Please try JCE Pro 2.7.14 RC3 - https://www.joomlacontenteditor.net/downloads/editor/pro/development

If you copy the source code, as in your original post, when editing the table cell, the border values should now correctly show in the Advanced tab.

Please note that it is not currently possible to edit individual border positions (top, bottom, left, right) using the Border control in the Advanced tab

Ryan Demmer

Lead Developer / CEO / CTO

Just because you're not paranoid doesn't mean everybody isn't out to get you.

mig69
It works. Thanks.