Created attachment 125340 [details] Colour red background on cells present in sheet E FORMATTING: If i copy and paste conditional formatting from a cell on a lot of cell (90 cols x 50 rows), it works fine but the last cols not update but if a try to change conditional formatting for this cells, the rule is present. If i save file (ODS) and reopen, formatting not update automatically.
(In reply to matteazzi.antonio from comment #0) > Created attachment 125340 [details] > Colour red background on cells present in sheet E I don't see any cond. formatting in sheet E (manage shows nothing).
Hello Buovjaga, Yes, on sheet E there is not formatting. I may have badly explained the problem. On the sheet R each cell have a conditional formatting about the values of cells in sheet E. for each row, if a number in a cell of sheet R is included in corresponding row on sheet E, the background of cell number must be red. It works fine, but if i save, close the file and reopen, conditional formatting of cells on sheet R not refresh (only first column works). If i copy from first cell (A1 for example) and special paste (only formatting) on other cells on sheet R, all works fine again. Thanks
Ok, sorry for being lazy in my testing. I tried the special paste to all cells and after saving & reloading, only A and B columns in sheet R have the conditional formatting. I'll set to NEW. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: c6d553b5fac93d97cb0d316586db34f4d5a8def1 CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on June 3rd 2016 Ubuntu 16.04 64-bit Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
Might be a duplicate of Bug 100393.
(In reply to Markus Mohrhard from comment #4) > Might be a duplicate of Bug 100393. You are right, I can't repro with my fresh build. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: 5c8ad526447934a5eae94fa5f40584083a874d9f CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on September 19th 2016 *** This bug has been marked as a duplicate of bug 100393 ***