Troubleshooting tables
If the changes do not take effect:
-
Check that you have uploaded and saved the correct file in Umbraco.
-
Still not working? Open and resave the file with a different name. You can, for example, put a number in the name (for example Ovrig_Tabell2.xls). Then upload the file again in Umbraco.
To find the media library logically, the names in the tree should reflect the name of the image, graph, or table it contains. However, avoid the letters å, ä and ö, and use "_" instead of spaces.
If it is difficult to remove an Excel table embedded in content:
- Place the cursor at the bottom right of the table and press backspace.
- Try selecting the entire table and pressing backspace.
If a table is behaving strangely in any way —for example, lines that are too long, a large gap under the table to the next paragraph, too many decimal places, or if the table is getting data from the wrong place—you can do the following:
- Check line breaks . Make sure there are no extra line breaks before or after the table in the content. Also double-check the HTML code, as there may be invisible line breaks there. A line break in HTML is written <p> <p>.
- Remove hidden code in Excel . Go into the Excel file and delete a number of rows/columns next to and below the table in Excel. Delete the entire row and the entire column, not just the content. There may still be invisible code or spaces that affect the table in Umbraco.
- Check the format tab . Check if everything is correct. Does the formatting describe more columns than are in the table? For example, if the table should only have 6 columns and there is formatting for 7 columns in the format tab, the table may look strange.
- Save the Excel file in another file format . Change from .xls to .xlsx or vice versa and see if that fixes the problem.
Thousands separators and decimals:
- Numeric numbers are recognized by the engine, and thousands delimiter and decimal handling is done automatically depending on the language of the website where they are displayed.
- Formatting numbers should be done by typing the value numerically (eg 1234) into the cell and then formatting it as a number with a thousands separator (1,234). This way, the value in the cell can be correctly interpreted by the engine.
- Dates must be formatted as dates in Excel and have the CSS formatting "date" in the style sheet.
- Years must be formatted as text to avoid thousands separators.