How to style table |
Post Reply | Page 12> |
Author | |
TC2020
Groupie Joined: Mar 26 2020 Location: Canada Status: Offline Points: 61 |
Post Options
Thanks(0)
Posted: Jul 19 2021 at 11:39pm |
Hi, I am using tables and would like to know how to properly style the following of a table: - Table outline (width and color) - Cell outline (width and color) - Row height - Column width - Cell background color At this time, I use cell internal margins to affect row height and column width. Also, is there a way to select multiple cells?. Thank you.
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6194 |
Post Options
Thanks(0)
|
The table element is not very flexible
If you are looking for some fancy design and different cell color, you should create your table in Excel then save the range as html with auto update. Open your OE page and use the External Page / iframe element. This table was created with OE https://www.chpsupply.com/laveuses-pression-pressure-washer/eau-froide-cold-water/fixe-fixed/commerciale-commercial.en-us.htm This table was created with Excel https://www.chpsupply.com/aspirateurs-vacuum-cleaner/commercial.en-us.htm
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6194 |
Post Options
Thanks(0)
|
TC2020
Groupie Joined: Mar 26 2020 Location: Canada Status: Offline Points: 61 |
Post Options
Thanks(0)
|
For link to site created by OE, how was that table created?. It has cell outlines. This is one of the properties that I am looking for. My table currently does not have any outlines. I have tried: selecting a cell, drop down to select Cells (as in your image above), and add Border properties (Style panel). That did not work for me (no outline), maybe I have done it wrong?. My application of table is not to present static information but it is used as placeholders for real-time data that get updated regularly, such as every 5 seconds. The server side code just has to find the cell locations and populate them with data. Is this going to work with OE table as I have not done this yet? Thank you.
|
|
TC2020
Groupie Joined: Mar 26 2020 Location: Canada Status: Offline Points: 61 |
Post Options
Thanks(0)
|
Relating to using Excel, are there any tutorials available that deal with charting on a Web page with plots/graphs using Excel as data source?. Your suggestion reminds me of Google Charts where they use their online Spreadsheet as data source, populate data in the spreadsheet, select the data range, and plug them in their data visualization apps (html codes) for various types of charts (pie, line, bar, etc...). It is quite good but you need to be online and login to use Spreadsheet as data source (due to data security reason). This does not really work for my application as it is not always online connected to the Internet.
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6194 |
Post Options
Thanks(0)
|
Table outline Cell Outline Result |
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6194 |
Post Options
Thanks(0)
|
I don't remember any tutorial
|
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6194 |
Post Options
Thanks(0)
|
Plots and graph with excel produces an image that you can allways use as an image.
Saving spreadsheet as an html file will poduce a sub directory that contains an xml and images files. This directory must be available on the server but will not be automatically handled by OE. FileZilla will help.
Edited by Hobby001 - Jul 20 2021 at 3:37pm |
|
TC2020
Groupie Joined: Mar 26 2020 Location: Canada Status: Offline Points: 61 |
Post Options
Thanks(0)
|
Before your comments above, I managed to add outlines and background colors to cells. However, I did it cell by cell; i.e. click on a cell (until it shows cell-x-y in red) then make changes to border and background properties on the right panel Styles/Customize. I still cannot figure out how to select multiple cells (like in Excel). The border styling (group of elements container in this case) sometimes it does and sometimes it does not show changes made in Styles/Customize. The editor window and preview in browser still show the previous color even after a page Save and/or Refresh. What I find is that after a color change, I just toggle the thickness value (like change the value and then change it back) then color change takes effect quite consistently. Is there a proper way to get this right every time?. I will try your method above with table and also Excel charts. Thank you for your help. |
|
Hobby001
Admin Group Joined: Jun 05 2018 Location: Canada, Québec Status: Offline Points: 6194 |
Post Options
Thanks(0)
|
Post Reply | Page 12> |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |