#libreoffice-calc

[stackcopybiz]

How-to: What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"? #answer #computers #solution

How-to: What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"? #answer #computers #solution

What is in LibreOffice Calc the equivalent to Excel’s "Paste Special > Value"?

In my professional life, I’m limited to use Microsoft Office. In Excel there is an option ows to render the result of a formula to be pasted as a “fixed value”.

For instance A1 = "I",B1 = "ride", C1 = "a" and D1 = "bike" In E1, I can place a formula to concatenate the values of A1 through D1 to display the sentence “I…

View On WordPress

[stackcopybiz]

Resolved: How to color rows based on cell value in Open/Libre Office #dev #computers #development

Resolved: How to color rows based on cell value in Open/Libre Office #dev #computers #development

How to color rows based on cell value in Open/Libre Office

How do you automatically set the background color of an entire row based on the value of a specific column in that row in Open/Libre Office? There are similar questions for Excel, but this doesn’t completely work in Libre Office.

I can set a conditional formatting rule using a formula to set the color of a specific cell based on the…

View On WordPress