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

--- Comment #2 from [email protected] ---
Created attachment 70378
  --> https://bugs.freedesktop.org/attachment.cgi?id=70378&action=edit
Example balance sheet / cash till float spreadsheet

Thanks. I tried version 3.6.4RC1 and after my PC hung on me mid-install leaving
a 'program' folder with no access and no owner which I cannot delete or take
ownership of even as administrator, I managed to install it in a different
folder. (Windows 7 Professional 32 bit on AMD Turion 64-bit processor with 4GB
RAM)

Still have some problems, so I attach Cash_Check_test.ods saved using that
version of LibreOffice Calc

Cells K2 to K13 have three-way conditional formatting depending on whether
lower, equal or higher than cell N2 to N13.

For example, change K4 from 30 to 40 and notice it becomes light-blue. Change
it to 20 and it becomes light-red (pink). Set it back to 30 and it becomes
green.

Now, still on K4, hit Delete. It's treated as zero, and goes light red.

Hit Undo, and it reverts to 30 and green.

Now select two cells, K4:K5 and hit delete. This time all formatting is lost.

Not to worry, you might think, just hit Undo. The values return.

But, Oh, where has my conditional formatting gone!?

It seems to lose the Conditional Formatting when deleting a multiple selection
and the Undo doesn't realise it has gone, so I don't think it's an intended
feature of hitting delete on a multi-cell selection.

There doesn't seem to be a problem with Paste Special / Numbers changing the
formats now, but at least I can demonstrate a bug of the sort I mentioned with
steps to try to replicate it.

Thanks,

rh

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to