[Libreoffice-bugs] [Bug 69993] PRINTING: Option "view zero values" does not affect the page style option "print zero values"

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=69993

--- Comment #15 from Eike Rathke  ---
Conditional formatting style with white font is overkill (i.e. quite heavy if
used a lot) in most situations and doesn't help when changing the cell
background. Consider using a number format to suppress displaying and printing
of 0 values, for example

0.00;-0.00;;

Note the empty code in the third (=0) condition.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 69993] PRINTING: Option "view zero values" does not affect the page style option "print zero values"

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=69993

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 Status|NEW |RESOLVED
 CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com
   |.freedesktop.org|
 Resolution|--- |WORKSFORME

--- Comment #14 from Heiko Tietze  ---
We discussed the topic in the design meeting. The visualization option in tools
> options is independent from the printing option under page > sheet, which
could be improved by taking what is configured globally for newly created
documents. But we expect to run into other trouble with this approach and
concluded to accept the current behavior.

Btw, meanwhile cell styles and conditional formatting has improved
significantly. Hiding zeros by white font color could be a good workaround.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 69993] PRINTING: Option "view zero values" does not affect the page style option "print zero values"

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=69993

--- Comment #13 from cson...@halmai.hu ---
In the beginning it was not clear for me where to find these checkboxes so if
somebody has the same problem then here is the precise location of them.

The Tools -> Options -> Libreoffice Calc -> View -> Display -> Zero values
checkbox 
- is an application-wide setting and 
- determines whether the zeros are to be shown or hidden _on_the_screen_.
By contrast, the Format -> Page -> Sheet -> Print -> Zero values 
- is a setting with the scope of the current file and 
- refers to print or not to print zero values.

It is obvious that the current behaviour can be confusing if the printed
content is different than the one on the screen. 

I personally cannot see the benefit of hiding all the zero values globally in
all documents so I think the Tool -> ... -> Zero values is useless in its
current shape, therefore, it should be removed.

On the other hand, the Format -> ... -> Zero values setting has its benefit but
the location of this setting is not the best, nor the usability.

I think whether to display zero values or not, it should be a toggle switch
under the View menu, for example: View -> Show Zero Values, similarly to the
View -> Formatting Marks in Writer. The reason is that in most cases it is not
a per-document setting. It is much rather a per-moment setting. I want to see
the zeros _now_ and don't want to see them a minute later. This setting should
not be saved into the document but its current value should impact both the
screen and the printed versions.

If the user wants to have _saved_ settings for hiding/showing zero values then
they should use conditional formatting on the appropriate cells (or all of the
cells). Format -> Conditional formatting -> Condition -> "Cell value is equal
to 0, Apply style -> Hidden". 

(The Hidden style should be defined at first with Apply Style -> New Style ->
Organiser -> Name = "Hidden", Numbers -> Format Code = "")

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 69993] PRINTING: Option "view zero values" does not affect the page style option "print zero values"

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=69993

--- Comment #12 from Regina Henschel  ---
The property ShowZeroValues is per document. The setting in Tools > Options
works on the current active document. For new documents it is always checked,
in case you use the default document template.

There is no ODF property for ShowZeroValues, but it is saved in the
settings.xml. Content of the setting items in the settings.xml file are not
standardized. So if LibreOffice decides to change the behavior so, that it is
per sheet, that would be possible without ODF problems.

For printing it is standardized in ODF. It is the attribute style:print in the
element .

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 69993] PRINTING: Option "view zero values" does not affect the page style option "print zero values"

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=69993

Heiko Tietze  changed:

   What|Removed |Added

 CC||rb.hensc...@t-online.de
  Component|LibreOffice |Calc

--- Comment #11 from Heiko Tietze  ---
Regina, is there any reason to hide zeros per workstation and not per document
like it's done for printing?

(Added this topic to the agenda for the design meeting Nov/29 2017.)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

QA Administrators qa-ad...@libreoffice.org changed:

   What|Removed |Added

 Status|NEEDINFO|NEW
  Component|Spreadsheet |ux-advise

--- Comment #9 from QA Administrators qa-ad...@libreoffice.org ---
Per new procedures, moving this to NEW and requesting ux-advice (Stefan, et.
all). This should not be in NEEDINFO - it's a simple UX enhancement request
that UX should decide how to move forward.

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WONTFIX

--- Comment #5 from Cor Nouws c...@nouenoff.nl ---
One is in the VIEW settings and the other is in the TEMPLATE/document settings.
IMO this is a WONTFIX
Setting so in absence of any discussion on UX. 

Pls let's don't change old behaviour without very obvious reason or decent
discussion :)

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

--- Comment #6 from Stefan Knorr (astron) heinzless...@gmail.com ---
(In reply to comment #5)
 Pls let's don't change old behaviour without very obvious reason or decent
 discussion :)

If you are aiming for discussion, I don't get why you would be closing the bug
(which generally is an attempt to shut down further discussion)...
Not reopening solely to avoid an open/close-war, but I think this should be
reopened.

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|WONTFIX |---

--- Comment #7 from Cor Nouws c...@nouenoff.nl ---
Enough war without us adding some ;)
Will set to NEEDINFO then ..

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|REOPENED|NEEDINFO

--- Comment #8 from Cor Nouws c...@nouenoff.nl ---
because that is what we need from a proper discussion IMO

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

Stefan Knorr (astron) heinzless...@gmail.com changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #4 from Stefan Knorr (astron) heinzless...@gmail.com ---
Can reproduce on LibreOffice 4.2.4.2 (from OpenSUSE), setting to NEW.

I do agree with Eugen to some extent: the setting in Tools  Options 
LibreOffice Calc  View should also toggle the setting in Format  Page  Sheet
_on new documents_ (or documents where the Page setting is unset in the XML
format).
That way both options could stay mostly independent and the general user
expectation of printing what is on screen would be met. If a user wants the
display  print options to differ, they would have to set that once per
document.

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

--- Comment #3 from QA Administrators qa-ad...@libreoffice.org ---
Dear Bug Submitter,

Please read the entire message before proceeding.

This bug has been in NEEDINFO status with no change for at least 6 months.
Please provide the requested information as soon as possible and mark the bug
as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in
NEEDINFO status with no change in 30 days the QA team will close the bug as
INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located
here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as
UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

Qubit qu...@runcibility.com changed:

   What|Removed |Added

 Whiteboard|BSA,|BSA
 CC||qu...@runcibility.com

--- Comment #2 from Qubit qu...@runcibility.com ---
Removing comma from whiteboard (please use a space to delimit values in this
field)
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started

-- 
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

[Libreoffice-bugs] [Bug 69993] PRINTING: Option view zero values does not affect the page style option print zero values

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=69993

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Whiteboard|BSA |BSA,
 CC||c...@nouenoff.nl,
   ||libreoffice-ux-advise@lists
   ||.freedesktop.org
 Ever confirmed|0   |1

--- Comment #1 from Cor Nouws c...@nouenoff.nl ---
Hi Eugen,

Thanks for writing your suggestion. 
On beforehand I would say that I do not agree with you. It's not for nothing
that both are offered and work separate ..

You could start a discussion on the UX-list, if you like to see what others
think.
Cheers,
Cor

-- 
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