Problem solved: Indeed, putting all the data into a single worksheet works
OK.
The only drawback is empty documents for kids who didn't attend a given
year, but this could be avoided by adding some conditional loop in the Word
mail merge document to avoid printing empty sections (eg. "If
Trimester
Thanks everyone for the feedback.
As I learn more about spreadsheets, I thought merging all the years together
into a single sheet and filtering data so that the wordprocessor would only
see a subset of it would solve the issue... but it's not such a great idea
since some students will attend more
On 2014-03-20 02:55, Gilles wrote:
Sorry about that.
The spreadsheet 1) has too many columns to fit on a document, even in
Landscape mode (she wants Portrait), and 2) data are spread on multiple
sheets, one by year.
She needs to print the data thusly:
=
Last Name: Doe
First Nam
Hi :)
Would the optimal thing to do be to import that Excel tables into Base
and then export into an external back-end? Then enter data using some
Form in Base. For the reporting set-up a Report in Writer or Calc?
It sounds like it would be a lot of hassle but possibly would end-up
with somethin
How about using a single sheet for the data, and add an extra column for
year? Something like:
Year Last NameFirst Name...
2012-2013Doe John ...
2013-2014Doe Jane ...
Then mail merge on that. I don't know about Word, but in LO Wri
On 03/19/2014 10:24 AM, Gilles wrote:
Here's a better illustration of what I mean:
http://postimg.org/image/hw6kh9vx1/
--
View this message in context:
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102157.html
Sent from the Users mailing list a
Le 19/03/2014 15:24, Gilles a écrit :
Hi,
In theory, a LibreOffice Database report should be able to do something
like that, but :
- if you bind a Calc or Excel file, you will not be able to write/edit
any of the data in the bound Calc or Excel file, as these become
read-only - in order to updat
Here's a better illustration of what I mean:
http://postimg.org/image/hw6kh9vx1/
--
View this message in context:
http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102157.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe
Sorry about that.
The spreadsheet 1) has too many columns to fit on a document, even in
Landscape mode (she wants Portrait), and 2) data are spread on multiple
sheets, one by year.
She needs to print the data thusly:
=
Last Name: Doe
First Name : Jane
Date of Birth: 12/12/2000
Ye