At 11:02 07/08/2020 -0400, Vince Bonly wrote:
On 8/4/2020 2:52 PM, Robert Großkopf wrote:The data are part of the database. This is good. But the format of the table is the problem.Open the table and mark the whole content (Click with the mouse left beside the first fieldname). Then right mousclick | Tableformat. You could choose the color for the font there. Best choice would be "automatic" or "black".I am having the same type of problem with another Calc sheet conversion to a Base table. This time, data within each field have an underline present. How do I remove the underscores/underlining? The Font Effects | Text Description | Underling: control box option indicates "(Without)", but after clicking OK button, nothing happens. What am I missing here?
As I suggested earlier, some aspects of formatting of some parts of the column headings in a spreadsheet are carried over - perhaps unhelpfully - not into the relevant field names but instead *all* the records copied. My previous solution will work: apply default formatting to the column heading row in your spreadsheet before copying the data. You can easily undo such a change in your spreadsheet if you wish.
A workaround may be to use Table Format... to change the Underlining style to something other than "(Without)" and then back again.
I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy