automatically insert symbol and align from right to left

  • Resolved karemkadidola

    (@karemkadidola)


    6 years ago

    Hello,

    i have imported a table from excell with price list with Euro sign € the only problem is i can view the euro sign in my excell table but this euro sign is not visible in formule text box and again when i upload it in tablepress the euros sign doest no show only the numbers. is there a way to automatically add euro sign at the end of every number (can’t do it manually because i have just toooo many cells.

    in my excell file the prices are aligned from right to left but when imported i lose that alignement for that colon is there a way to align from right to left

    best reagrds

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    To fix the Euro symbol, I recommend to save the table to a CSV file in Excel and then import that .csv file into TablePress. This should keep the Euro symbols.

    To then right-align the columns, add this to the “Custom CSS” textarea on the “Plugin Options” screen of TablePress:

    .tablepress-id-1 .column-2,
.tablepress-id-1 .column-3,
.tablepress-id-2 .column-2,
.tablepress-id-2 .column-3 {
  text-align: right;
}

    Regards,
    Tobias

    Thread Starter karemkadidola

    (@karemkadidola)

    Hello dear Tobias you know before installing your plugin i went to read some comments and many people mentioned the outstanding support. But i am just impressed you replied to me in less than 1 minutes. I just wonder how you do. how can you have a plugin with more than 700.000 installation and still be as fast as your are to adress issues Waoooo i am just wonderfully impressed. i will try your solution and thank you for your help

    Please send me direct link to rate your plugin it deserves more than 5 stars. I will give the maximum all the same ??

    Thread Starter karemkadidola

    (@karemkadidola)

    Hello,

    I have tried the cvs solution but the dollar sign comes as a question mark sign ;-(

    Thread Starter karemkadidola

    (@karemkadidola)

    sorry i say dollar sign but i mean Euro sign

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    you are welcome for the fast support! I try my best, but it’s only possible because people support me with donations.

    Can you check what the symbol looks like in the CSV file when you open it in a normal text editor? This sounds like a problem with the character encoding on your server, unfortunately.

    Regards,
    Tobias

    Thread Starter karemkadidola

    (@karemkadidola)

    Well if this can help i just found a solution is first save file as unicode then change extension from txt to cvs and that is done.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    perfect! Yes, using Unicode is the best solution here!
    Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘automatically insert symbol and align from right to left’ is closed to new replies.