Groups | Search | Server Info | Login | Register

Groups > uk.comp.os.linux > #23632

Re: LibreOffixe Puzzle

Show all headers | View raw

On 2025-05-21 13:54, Java Jive wrote:
> 
> What, as far as possible, you need to do is to ensure that all those 
> cells that *SOMETIMES* have numeric data in fact *ALWAYS* have numeric 
> data, even if it's just zero, and deal with the display of it separately 
> by conditional formatting, for example from memory I'm reasonably sure 
> that it's possible to hide cells containing zeros.  I'm sorry that I 
> haven't time to explain this more thoroughly by experimenting myself and 
> giving you precise instructions as a result, because I'm extremely busy 
> preparing for a trip away for a family wedding, but if you can't make 
> progress yourself following the guidelines given above, I'll be able to 
> give more attention to it upon my return sometime after the weekend.

Now that I'm back from the wedding, I thought I ought to check up on my 
statement above based only on memory, and indeed I was correct. 
Although it is slightly more complex than I thought I remembered (but 
probably that memory was based on Excel), you can use conditional 
formatting to hide zero values, as follows:

   1)  Select the cells to be formatted

   2)  Format, Cells

   3)  In the Format Code field, enter something like the following 
(this for UK currency, other currencies can be adapted similarly to 
this) ...

       [=0];[<0][RED][$£-809]#,##0.00;[$£-809]#,##0.00

... explained as follows ...

       [=0];                      # If =0, no formula, nothing displayed
       [<0][RED][$£-809]#,##0.00; # If <0, usual formula but red
       Remainder                  # If neither of above, usual formula

At least for my installation of v24.8, further details are available 
from ...

   file:///<LibreOfficePath>/help/<language>/text/shared/01/05020301.html

... which for me is ...

   <file:///C:/Programs/LibreOffice/help/en-US/text/shared/01/05020301.html>

-- 

Fake news kills!

I may be contacted via the contact address given on my website: 
www.macfh.co.uk

Back to uk.comp.os.linux | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

LibreOffixe Puzzle Davey <davey@example.invalid> - 2025-05-21 10:19 +0100
  Re: LibreOffixe Puzzle Java Jive <java@evij.com.invalid> - 2025-05-21 13:04 +0100
    Re: LibreOffixe Puzzle Java Jive <java@evij.com.invalid> - 2025-05-21 13:54 +0100
      Re: LibreOffixe Puzzle Davey <davey@example.invalid> - 2025-05-21 14:32 +0100
      Re: LibreOffixe Puzzle Java Jive <java@evij.com.invalid> - 2025-05-28 14:26 +0100
        Re: LibreOffixe Puzzle Daniel James <daniel@me.invalid> - 2025-05-29 11:57 +0100
          Re: LibreOffixe Puzzle Java Jive <java@evij.com.invalid> - 2025-05-29 12:36 +0100
    Re: LibreOffixe Puzzle Davey <davey@example.invalid> - 2025-05-21 14:36 +0100
      Re: LibreOffixe Puzzle Mike Scott <usenet.16@scottsonline.org.uk.invalid> - 2025-05-21 15:46 +0100
        Re: LibreOffixe Puzzle Davey <davey@example.invalid> - 2025-05-21 17:18 +0100
    Re: LibreOffixe Puzzle Andy Burns <usenet@andyburns.uk> - 2025-05-21 16:11 +0100
      Re: LibreOffixe Puzzle Davey <davey@example.invalid> - 2025-05-21 17:16 +0100
        Re: LibreOffixe Puzzle Andy Burns <usenet@andyburns.uk> - 2025-05-21 19:00 +0100

csiph-web