Am 22.07.2012 01:48, Andrew Brager wrote:
On 7/21/2012 10:47 AM, Andreas Säger wrote:
Am 20.07.2012 23:50, Andrew Brager wrote:
Nevermind, I figured it out.
In case anyone else has a similar desire and wants to know... I simply
select all the rows I want to belong to a group, add a border around it
all, and insert a row above the box I just made. The inserted box
contains the label I want; I make sure to turn off word wrapping for
that one cell.
The component is named "Calc" because it is a calculator in the first
place. It is not a table editor nor database although many people use
it that way.
Base reports can turn raw, unsorted table data into grouped reports.
Thanks for your input. As you say.... "many people use it that way".
Since my intent is to have assistants work with it, I'm stuck with what
Spreadsheets are extremely difficult to maintain by untrained users. We
all use input forms on top of databases all day long online and offline
without even noticing it. Professional tools online and on the desktop
are built on top of databases. No professional would ever build such
things on top on spreadsheets.
What you try to do is unprofessional because you mix layout, formatting
and data on the same sheet. The whole thing relies on careful data input
in the right order.
Please ignore Tom. He is very kind but totally ignorant towards
LibreOffice Base which can read spreadsheet data as if they were
database data. Therefore you can generate professional reports from
spreadsheet data. You don't need to "convert" anything. Nevertheless, a
true database would be so much easier to maintain, particularly by
untrained users.
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
