Clone formatting doesn't work on background color.
No repro with Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7a7eb4aa21ca0c83db825fe8d5a5278611b391d8 CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Please attach test file. Thank you.
Created attachment 186100 [details] Video showing error
Created attachment 186103 [details] Screenshot in my 7.5.1.2 It worked in my 7.5.1.2: Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW Calc: threaded However I noticed that when you applied the background color, all the line was filled. In my screenshot the background applied to the whole paragraph. The format clone should work on the paragraph style, but I'm not sure what your paragraph looks like. Maybe you can check your own paragraph format/style first.
Created attachment 186196 [details] Character color
Created attachment 186197 [details] Background color
I think that you used "character color" instead of "background color". Cf. attachments. Regards.
[Automated Action] NeedInfo-To-Unconfirmed
I tested as in your video with background color of text. I started with yellow background and used the brush and could add with it the background color to another string (new paragraph). I tried this again with that line and could apply the background color with the brush to a third text line (also in a new paragraph). Then I changed the background color in the third line and used the brush in the reverse direction (from string 3 to 1) and it works also. Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Thus the issue is resolved at least in the current version 7.5.5.