Created attachment 190395 [details] edit pivot table value style i have change style in pivot table (Pivot table value edit Numbers - thousands separator) when i accept it in my pivottable not working (in case my data without number formating)
Please attach a sample file, and try to explain in more detail what you have done that does not work. Remember that in pivot tables after every update they use their own cell styles, any direct format is lost. https://help.libreoffice.org/latest/en-US/text/scalc/guide/datapilot_formatting.html?&DbPAR=CALC&System=WIN
i have already attach file when i report a bug this is what i work : 1. select Styles - Manage Styles 2. than right click Pivot Table Value - edit style 3. than i go Tab Numbers 4. i change format number like 3,123.00 5. i also activated : thousands seperator when i select OK in my pivot table not working still not format sorry my poor english
Created attachment 190397 [details] sample file sorry forgot my file
Please take a look in the help: https://help.libreoffice.org/7.6/en-US/text/scalc/guide/datapilot_formatting.html?DbPAR=CALC#bm_id931656104694657 "The number format of these cell styles cannot be changed in the cell style itself; you must format it in the data source"
ok...