Re: [libreoffice-users] Calc: how do I?

2020-09-16 Thread Brian Barker
At 10:29 16/09/2020 -0400, Dan Lewis wrote: I have a dBase database with several tables. How do I open this database in Calc so that each table will have its own sheet? You can do it piecemeal: o Open the database. o Display Tables. o Select a table. o Copy. o Create a spreadsheets with an

Re: [libreoffice-users] Calc: how do I?

2020-09-16 Thread Regina Henschel
Hi Dan, Dan Lewis schrieb am 16-Sep-20 um 16:29: I have a dBase database with several tables. How do I open this database in Calc so that each table will have its own sheet? Dan Here something different than simple copy: 1. You make a .odb file for the dBase database and register it. That is

Re: [libreoffice-users] Calc: how do I?

2020-09-16 Thread Alan B
Hello Dan, As far as I know, each table needs to be opened separately. That will open a separate Calc window with a tab for the table that was opened. The tabs can then be moved into a single spreadsheet by right-click the tab in one of the spreadsheets and selecting the "Move or Copy Sheet..."

[libreoffice-users] Calc: how do I?

2020-09-16 Thread Dan Lewis
I have a dBase database with several tables. How do I open this database in Calc so that each table will have its own sheet? Dan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] Calc - How do I preserve number format for printing?

2013-04-05 Thread paulwhitehurst
When I print a spreadsheet the number format isn't preserved. I use a format that shows two decimal places. When I print integers they have no .00 and formulas have a long string past the decimal. It appears correct inside the spreadsheet. Thanks, Paul Whitehurst whan...@aol.com -- View

[libreoffice-users] Calc: how do I change what cell a form control is anchored to?

2012-02-11 Thread Jim Trigg
I can change whether a form control is anchored to the page or to a cell, but not what cell it's anchored to. I want to anchor it to the cell that it populates, but it seems to always (no matter where on the page it is) anchor it to cell A1. This is LibreOffice 3.4.5 on Xubuntu 11.10. Thanks,