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 > > dbola...@fastmail.fm > > > > -- > > http://www.fastmail.fm - Send your email first class > > > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@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 > dbola...@fastmail.fm > > -- > http://www.fastmail.fm - A no graphics, no pop-ups email service > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 dbola...@fastmail.fm -- http://www.fastmail.fm - A fast, anti-spam email service. -- To unsubscribe e-mail to: users+unsubscr...@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