Years ago I frequently had the same problem. My first spreadsheet
(1987) was a shareware product called ExpressCalc. It had a very
convenient function called NOPRINT. If I put that function (or a
formula that evaluated to that function) in any cell on a particular
row, that row would be skipped when I printed the spreadsheet.
This function was very handy whenever I wanted to build a re-usable
table that might allow for 100 rows of data entry & related
calculations, but in which not all rows are likely to be filled every
time. For instance, I might have an invoice sheet listing 30 different
possible items, but I only want the 5 that happen to have quantities
filled in to actually show up on the printout.
When I upgraded to Excel (1995), I chose Excel because (with help from
their tech support) I could do much the same thing using a couple of macros.
I've recently opened a feature request
(https://bugs.freedesktop.org/show_bug.cgi?id=74101) in hopes that the
folks with the programming skills would notice and add similar functions
to LibreOffice. If you think such a feature would be helpful to you,
please go to that bug and say so.
And Brian, I'd be interested in knowing that hint you gave Muriel.
Thanks,
-- Tim
===========================
225 Janice Drive
Athens, GA 30606-1638
email: t...@timdeaton.org
home: 706-543-0592
cell: 706-248-6544
fax: 888-415-5991
web: www.timdeaton.org
===========================
I know the plans I have for you:
Plans to prosper you and not to harm you;
Plans to give you hope and a future.
--- God (Jeremiah 29:11)
On 1/20/2014 12:11 AM, Muriel Parker wrote:
Thank you, all. I have figured a roundabout way to accomplish this, after
a hint from Brian Barker.
Muriel
--
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
