Bug 51856 - Better way to set/store Printing of 0 Values ? (currently done in page styles in documents / templates )
Summary: Better way to set/store Printing of 0 Values ? (currently done in page styles...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: difficultyBeginner, needsDevEval
Depends on:
Blocks: Options-Dialog
  Show dependency treegraph
 
Reported: 2012-07-07 19:06 UTC by João Mac-Cormick
Modified: 2017-07-26 19:11 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
zero values in print (54.42 KB, image/png)
2012-07-07 19:06 UTC, João Mac-Cormick
Details
Option to activate / suppress printing zero values (66.22 KB, image/jpeg)
2012-10-03 19:42 UTC, armin.wuertenberger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description João Mac-Cormick 2012-07-07 19:06:17 UTC
Created attachment 63960 [details]
zero values in print

LibreOffice Calc has a very good function.

In "Options-> LibreOffice Calc-> View-> Zero Values" that can be set or not display zero values.

This is very useful in large spreadsheets, where the occurrence of many zeros has to leave the reading of the sheet a little more confusing. When not on the screen prints zeros, reading the sheet is made more pleasant and even avoid reading errors.

However, in requesting the printing sheet in a printer system, the zeros are printed.

It would be interesting to implement the same option "View-> Zero Values" also in "Options-> LibreOffice Calc-> Print."

==============================

O LibreOffice Calc possui uma função muito boa.

Em "Opções-> LibreOffice Calc-> Exibir-> Valores Zero" podemos configurar que sejam, ou não, exibidos valores zero.

Isso é muito útil em planilhas grandes, aonde a ocorrência de muitos zeros vem a deixar a leitura da planilha um pouco mais confusa. Quando não se imprime na tela os zeros, a leitura da planilha é feita de forma mais agradável e até mesmo evitamos erros de leitura.

Porém, ao solicitar a impressão da planilha, em alguma impressora do sistema, os valores zeros são impressos.

Seria interessante implementar a mesma opção "Exibir-> Valores Zero" também em "Opções-> LibreOffice Calc-> Imprimir".
Comment 1 Joel Madero 2012-09-12 23:00:35 UTC
I'm going to attempt this one, it could take awhile but we'll see what I can come up with
Comment 2 armin.wuertenberger 2012-10-03 19:40:01 UTC
Actually, there has not option to be added, since it is already there.
Follow Format->Page, Sheet tab

I found the answer here: http://help.libreoffice.org/Calc/Sheet (since I was looking for such an option)

Lucky you ;) probably nothing to fix here!
Comment 3 armin.wuertenberger 2012-10-03 19:42:17 UTC
Created attachment 68054 [details]
Option to activate / suppress printing zero values
Comment 4 Joel Madero 2012-10-03 20:41:49 UTC
Awesome. Marking as INVALID since you already found a solution. This was on my long list of things to do so I'm glad you found something
Comment 5 clive 2012-10-15 10:17:47 UTC
But ... next time you open Libre Calc the tick box (Zero Values) is ticked again.
you need to be able to save it as a default setting. everytime you print a spread sheet, you have to go into format, page zero values and uncheck the box.
Comment 6 Joel Madero 2012-10-15 15:18:13 UTC
Edited title to reflect new issue. It is now a minor bug not an enhancement. These settings should be saved :) Thanks for the update
Comment 7 João Mac-Cormick 2012-10-16 10:19:58 UTC
 I thank all the dedication
:)
Comment 8 Marcos Souza 2013-04-26 18:32:05 UTC
Some code pointers here?

I believe this is not SO difficult...?

Thanks since now!
Comment 9 Cor Nouws 2013-04-29 13:32:15 UTC
(In reply to comment #0)

> It would be interesting to implement the same option "View-> Zero Values"
> also in "Options-> LibreOffice Calc-> Print."

Hi, IMO this issue is invalid. Or at least not necessary.
Printing options for spreadsheets are set in the page styles:
  Format > Page ... tab Sheet
(See F11 for more page styles and Help for how to work with them,)

Among printing zero values, there are some other usefull settings...

Opinions?
Comment 10 Cor Nouws 2013-04-29 13:33:42 UTC
and if an issue: we talk about inherrited wise behaviour from OpenOffice.org, that may be enhanced with options during printing...
So setting Version and Importance accordingly.
Comment 11 Cor Nouws 2013-04-29 13:36:30 UTC
Hi,

Sorry for not reading all comments before posting ...

(In reply to comment #5)
> But ... next time you open Libre Calc the tick box (Zero Values) is ticked
> again.
> you need to be able to save it as a default setting. everytime you print a
> spread sheet, you have to go into format, page zero values and uncheck the
> box.

Then you have to change the template or the default template.
(See my previous comment pointing to templates.)
Comment 12 Michael Meeks 2013-04-30 11:08:28 UTC
Oh - interesting; that setting is not persisted to the config - it is persisted to the file AFAICS; so - you want some way to edit the default value of that for new files ?

clive - what kind of sheets are you printing ? if you save as ODS this setting should be persisted (seems to be for me).

Otherwise I guess we should get some ux-advice on this (if any is forthcoming) - as to what to do wrt. the default there. There is plenty of space on the tools->options->calc->printing page - but adding just this one default option there might be a bit odd.

git grep RID_SCPAGE_PRINT

for that page; and/or just git grep for semi-unique strings you see in a dialog to find the code for that dialog ...
Comment 13 Cor Nouws 2013-04-30 20:49:54 UTC
I love proper summaries, so tried my best for this one ;-)
Comment 14 Joel Madero 2013-04-30 20:55:33 UTC
Should be NEW - reopened is only appropriate when there is a developer assigned :)
Comment 15 Joel Madero 2013-04-30 20:55:59 UTC
hahha which of course I was assigned - but really just not time. Hope someone else picks it up
Comment 16 Joel Madero 2013-05-29 21:58:32 UTC
*** Bug 63367 has been marked as a duplicate of this bug. ***
Comment 17 Joel Madero 2014-02-27 23:13:31 UTC
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise
Comment 18 Robinson Tryon (qubit) 2015-12-14 06:11:55 UTC Comment hidden (obsolete)