r/LibreOfficeCalc

Hi All

I have a spreadsheet with a stack formatting some of which is direct e.g. various borders but a lot of which is conditional using vlookups involving named ranges in a separate sheet

Ultimately I want to lift a completely standalone copy of the sheet so that all the values are static and all the formatting is direct cell formatting so there's no reliance on any other data source

Making the values static is easy (Paste special > values) but I not been able to find a way to convert conditional formatting to direct cell formatting

I've done some research and found a downloadable set of add-on tools that includes a conditional convert feature but that same set of tools also includes features that I know are built into Calc e.g. converting character cases which makes me think the conditional convert tool is using an existing built in feature but is making it easier to access in some way

Before I go digging into the conditional convert tool to work out how it works can anyone tell me if I'm missing something and that there is already a convert feature built in but I'm just not seeing it

tia

---

Version: 26.2.4.2 (X86_64)

Build ID: 620(Build:2)

CPU threads: 32; OS: Linux 6.17; UI render: default; VCL: gtk3

Locale: en-GB (en_GB.UTF-8); UI: en-US

Ubuntu package version: 4:26.2.4.2-0ubuntu0.24.04.1~lo1

Calc: threaded

I copied some information into a spreadsheet. Some of the cells take up multiple lines.

Such as
Item 1
Item 2
Item 3
in one cell

However these look more like "Item 1 " on each line. I used Trim() to remove extra spaces.

"Item 1"

Now I have one column that is wrong and one that is corrected. I want to replace the wrong column with the corrected column. So I cut the corrected column and paste it as Unformatted Text. This makes the function into text, but it also removes the line breaks.

Such asItem 1Item 2Item 3in one cell

I undo then use Find & Replace to change all line breaks into @ symbol. Cut and paste as Unformatted Text again to make the function text.

Such as@Item 1@Item 2@Item 3@in one cell

Now I need to change the @ symbol back into a line break but nothing I have looked up is working as it's described.

Problem with "FIND". CELL "E"

E1 =IF(FIND("PAY",A1<>0)B1,0) Answer 113.75. Correct

E2 =IF(FIND("PAY",A2<>0)B2,0). Answer #VALUE. Should be "0"?

A B E

TESCO PAY AT PUMP	113.75			113.75
B & Q 1179	79.76			#VALUE!