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: [email protected]
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
