View original (French)

[Calc] delete the word "empty"

tsing Posted messages 72 Registration date   Status Member Last intervention   -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,
How to remove the "(empty)" label from empty rows in a pivot table?

Thank you
latest version of LibreOffice,

3 answers

  1.
    yclik Posted messages 3874 Registration date   Status Member Last intervention   1 609
     
    Hello
    Right-click on the TCD result table > Layout
    Plus button
    Check '"Ignore empty rows"
    3
    1. tsing Posted messages 72 Registration date   Status Member Last intervention   80
       
      Thank you yclik, but it's not the empty line; it's actually some cells in certain rows (sorry for the imprecision!)

      and it's that "(empty)" that I would like to remove.
      0
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    So you need to fill in these cells ...

    --
    Retirement is great! Especially in the Caribbean ... :-)
    Raymond (INSA, AFPA, CF/R)
    0
    1. tsing Posted messages 72 Registration date   Status Member Last intervention   80
       
      Hey, hello Raymond!
      "Fill in the cells": what does that mean? Put something in there?! It's not possible, I can't invent what doesn't exist: a check for example.

      While surfing, I read that I needed to put a space somewhere, but I didn't understand where or how?! ...

      Does that make sense to you?
      0
  3. yclik Posted messages 3874 Registration date   Status Member Last intervention   1 609
     
    Hello
    Apparently, the result of a Pivot Table shows (empty) if "a row field" in the Pivot Table comes from an empty cell.
    In the example below, it indicates empty if a date is missing on the left.
    Without a provided example, it is possible to create a formula to obtain - if the cell is empty
    example in B2 =IF(A2="","- ",A2)
    and select only column B to build the Pivot Table
    0
    1. tsing Posted messages 72 Registration date   Status Member Last intervention   80
       
      Hello,
      Thank you! But I'm lost! Since then, I've also seen that an empty source cell shows "(empty)" in the pivot table (PVT^^); just like in your example.

      Our software doesn't look the same, and I don't understand your suggestion!
      For example, my source table has 8 columns, and the PVT uses 5 as row fields and 3 as data fields. There's no filter.

      LibreOffice may not allow any other solution, without using macros, than filling all the source cells.
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      what if you uploaded a file so we can see what you're talking about precisely?
      eric
      0