[libreoffice-users] Re: Labeling in Calc

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: users+help@global.libreoffice.org
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