Re: [libreoffice-users] Calc data in Writer

Thanks for the suggestions.  I have tried a number of things, and the
bottom line is that LO makes a simple task a real pain in the ass.  Many
people keep lists of things in spreadsheets - CD's, photos, tools in a
tool box, contents in the pantry, toys in the toy box, etc.  At some
time you may want an easy way to basically print out a formatted report
based on the spreadsheet data.  There is no easy way in LO.  That fact
needs to change.

I found that using the report functions of Base came the closest to
doing what I want, but doing a custom report is not easy for the casual
user.

My suggestion is to either beef up Writer, or build reports into Calc. 
Make them easy to understand and easy to create.

Dave,

On Tue, Aug 19, 2014, at 09:38 AM, dave boland wrote:
> All,
>
> Thanks for the replies - I think.  First, you can't do this with cut and
> paste because the formatting is just columns.  This is (hint) like a
> database report where the comment field is placed under the description
> field (see below).  The fields in the spreadsheet are: Date, Sender,
> Subject, Description, Comment.  What I want is to have all records
> printed on one page (or two if needed), not one record per page like
> mail merge typically does.
>
> Writer has data sources, and you can select fields, I just have not
> figured out how to fill the fields so they are printed like below (one
> record after the other).
>
> However, I believe it is possible to use Base to create the report I
> want.  I'll investigate that approach later today.  Any other helpful
> suggestions welcome.
>
> Dave,
>
> On Mon, Aug 18, 2014, at 11:17 AM, dave boland wrote:
> > All,
> >
> > I have a small Calc file of information I want to put into Writer - like
> > mail merge, but the data is not address.  What is the best way to do
> > this?
> >
> > The data is actually: Date, Sender, Subject, Description, Comment.  Waht
> > I want to do is something like this:
> >
> > Date     Sender     Subject       Description/Comment
> > 1/15/14  Mr. Black  Order Conf.   Confirmed the order.
> >                                   Will be able to ship by 2/1/14
> >
> > 1/16/14  (me)       Ship date     Shipping date 1/30, UPS
> >
> > 2/1/14   Mr. Black  Order Rec'd.  Order was delivered.
> >                                   Customer called to thnak us!
> >
> > Dave,
> > -- 
> >   dave boland
> >   dboland9@fastmail.fm
> >
> > -- 
> > http://www.fastmail.fm - Send your email first class
> >
> >
> > -- 
> > To unsubscribe e-mail to: users+unsubscribe@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
> -- 
>   dave boland
>   dboland9@fastmail.fm
>
> -- 
> http://www.fastmail.fm - A no graphics, no pop-ups email service
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@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
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - A fast, anti-spam email service.


-- 
To unsubscribe e-mail to: users+unsubscribe@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