#openoffice-calc

[stackcopybiz]

Resolved: Copying just text, not formulas, in OpenOffice Calc #it #development #answer

Resolved: Copying just text, not formulas, in OpenOffice Calc #it #development #answer

Copying just text, not formulas, in OpenOffice Calc

How do I copy and paste the text (not the formulas) from one Calc sheet to another in OpenOffice?

Answer [by jwaddell]: Copying just text, not formulas, in OpenOffice Calc

Select the cells you want to copy, and use Ctrl-C to copy them.

Select the cell where you want to copy the cells.

Open the Edit->Paste Special menu.

In the Selectionsection,…

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

[stackcopybiz]

How to: How to create a formula for every row in a column in Google SpreadSheet? #solution #it #programming

How to: How to create a formula for every row in a column in Google SpreadSheet? #solution #it #programming

How to create a formula for every row in a column in Google SpreadSheet?

I use three columns. A, B and C. In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2.

How can I do so I don’t have to type in the new formula in column C for every row?

I use it in both Google Docs SpreadSheet and OpenOffice SpreadSheet.

Answer [by Geoff]: How to create a…

View On WordPress