I recommend the following edit to Chapter 2 of Base Guide 6.2 on Spreadsheets (page 67):
Users can take data from a spreadsheet and insert it as a new table that is editable in LibreOffice Base. Open the source spreadsheet and highlight all of the cells that you wish to make a table of (including column headings, if you have them). Copy that data. Navigate to the Tables pane in LibreOffice Base and right click on empty space (right clicking on an existing table will append your data there). Now select 'Paste' and follow the prompts to create a new table. Now the data that was in your spreadsheet is a table that LibreOffice Base will allow you to edit. I get data from my dispatch center in spreadsheet format and it needs some editing. Under LibreOffice Base I was told that you could not do that. I found this technique only after a lot of trial and error. This allows me to take the data provided to me in spreadsheet format, create a table, perform the edits I need, and then run the queries we use to keep our elected officials informed of our incident counts. Knowing this made LibreOffice Base a usable option for our agency. Without this little tidbit of information, LibreOffice Base was not a usable platform for us. This information may make life easier for other users. Thanks! Doug Bleeker Assistant Chief Spokane County Fire District 9 3801 E. Farwell Road Mead, WA 99021 509-466-4602 dblee...@scfd9.org -- To unsubscribe e-mail to: documentation+unsubscr...@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/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy
