https://bugs.freedesktop.org/show_bug.cgi?id=74101
--- Comment #4 from Winfried Donkers <winfrieddonk...@libreoffice.org> --- (In reply to Tim Deaton from comment #3) > With the NOPRINT function I suggested, the printing process would search for > the output of that function (just as it now searches for a "print range") > and on finding that output would perform those five steps automatically. Hi Tim, I have two more comments on your request that need consideration: - The NOPRINT function you suggest only supports not printing empty cell-rows, whereas the filter offers many more options. To make a NOPRINT function versatile (i.e. useful for many users, not just one or two), it would need to have rather a lot of arguments as various filter-options (ranges as well as criteria) must be possible. This makes the function less easy than your macro. - The NOPRINT function you suggest is not a function in the way the functions are defined (see http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1017860_715980110 ), i.e. a function returns a result which is shown in the cell where the function resides, a function is stored with the document together with its result (making it fast to read a spreadsheet document as no calculation is needed). All in all, I think that the functionality you want can be added in 3 ways: -use your macro and saved in in your default spread document so that it is available to you in all the spreadsheet documents that you create. This is a solution for you/your documents only; -make an extension that offers the functionality of your macro. Extensions can me made quite easily (if you can write macros, making extensions shoud be within your grasp, too) and can be made available to alle users who want his functionality; -develop an extra functionality in Calc. Not a function, but a menu option (something like 'print filtered selection ...'), possibly with remebering the filter settings, so that setting is needed only the first time and when settings are to be changed. The first two options are directly available to you, the third would need some discussion with UI-experts before developing can be started. It may even be that UI-experts say that the gain of the extra functionality is small compared with the added complexity of the menu. It is not that your idea is bad, not at all, but I try to balance the current possibilities with the effort needed to enhance them and the benefit to the general user. This is just my personal opinion; I interested in your thoughts. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs