Uppercase digits

The same problem with the degree sign. Copied as a letter of the alphabet “o”

Hello,
Can you confirm which table type are you using for this use case,
is it perhaps pasting values from Excel ( or Word) to a Simple Table,
or do you maybe have the Premium Plugin version so you are using editable tables such as Manual Tables?
If you are using the premium Plugin version for Manual or SQL Query based tables,
please open a ticket on our?main Support platform here,
and one of our Agents will respond as quickly as possible.

Premium products are not supported in these forums, as per this comment by www.ads-software.com moderators.

–
But if you are using the Lite wpDataTables, and pasting the values in a Simple Table,
could you send us any sample of an Excel file with a cell such as from your example, then we can make a test to reproduce this on our end,
then we can confirm if this is a current limitation of our Plugin or a possible bug?
You can wrap the Excel in a zipped format and upload to anything like weTransfer, then send us a download link here if the file does not have any sensitive data.
If it has any sensitive data, you can open a ticket on our Premium Support, choose “Pre Purchase Questions for wpDataTables” then you won’t have to input the licence key,
so we can proceed there.
Kind regards.

Pasting values from Excel to a?Simple Table

https://dropmefiles.com/XdmZh

• This reply was modified 1 year, 5 months ago by nicolayka.

Hello,
To begin, I want to extend my heartfelt apologies for the delayed reply,which is due to an unexpectedly high volume of inquiries.We truly value your patience during this period.

We did a lot of testing in the meantime, and we can confirm that unfortunately, at this time, we have a limitation in our Plugin when it comes to passing values like this directly from Excel,
whether if it is linking a new DataTable from Excel source,
or copying + pasting the values from Excel to a Table as you are doing here.
–
As we mentioned on this Documentation for Excel Tables,
Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
–
Our Plugin basically needs the source content to be written as HTML in order to render the symbols/numbers as you need them.

For the Simple Tables, you can either write Custom HTML and CSS directly in a cell in order to achieve a subscript, superscript, degree, etc,

or you can paste them, as you mentioned, specific special characters,
also it’s possible if you find it ‘preformatted’ online as HTML and optionally CSS added in-line,
they can be copied as the full string directly to a Simple Table cell;

or you can use our HTML Editor to create symbols like that.

There we have a ‘subscript’ and ‘superscript’ as one of the options.

when you go for new entries or edit existing ones, there are these options “subscript” and “superscript”.

;

You can also input special characters, like this “R” I made here :

I copied the symbol from an example on a WordPress Tutorial page : ^? and input it into the HTML editor.

So, at the moment, values like that can not be copied directly from Excel,
unless if you write them as custom HTML in the Excel, then if you copy+paste it like that, it should render,
but Excel has a different way of rendering data and thus at this time we have that limitation.

We will do our best to improve that in the future, though.
Please feel free to search on our suggestions page (https://features.wpdatatables.com/), to see if someone may be already suggested this feature. If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list. You can certainly follow our changeLog if you’d like(https://www.ads-software.com/plugins/wpdatatables/#developers), where we state any changes/new features/bug fixes during updates; and our newsletter(https://wpdatatables.com/newsletter/), so you’re informed about new features, bug fixes, freebies, etc.