At 13:15 04/08/2020 -0400, Vince Bonly wrote:
I am having a problem when I attempt to create a LO Base table from a LO Calc spreadsheet, and I am stumped. This is what I have done:In Windows 10 Home x64, I highlighted & Copied the data, A1:E161, from a LO vers 6.4.4.2 (x64) Calc file to the win10 clipboard. In LO Base-Tables panel, I used Ctl-V to paste the data. Under Tables-Options, selected Definition and data. Check marks placed at "Use first line as column (i.e., field) names", and also at "Create new field as primary key". Primary key named: Passwrd-ID. then clicked the Create button. Table1 appeared in Tables panel.Doing a left mouse click on Table1, I see the field names, but do not see the record data. If I select a field, at the top, the record data is visible only as white text on a dark blue background. Why am I not able to see the record data throughout each field when doing the above described procedure? What am I not doing correctly?
This is a pure guess, based on the experience of another user. Are the column titles in your spreadsheet (which become field names) formatted as white text on a coloured background? (And why not?) If so, it may be that the text colour, but not background colour, has been carried over and - unhelpfully - applied to all of the records in addition. If that is the problem, there are two alternative solutions, I think:
o Change the spreadsheet formatting (perhaps temporarily) so that the headings are no longer in white text. Create the database table anew.
o In the database Tables panel, use Edit | Paste Special... (or right-click | Paste Special...) instead of ordinary Paste and select an alternative option - perhaps "Formatted text [RTF]"?
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