OpenOffice Calc

[OpenOffice Calc] How to replace cell value automatically if the cell value is a number

Suppose you are working with OpenOffice Calc which requires lot of filters. And you want to replace a cell value with a digit to some text or value in another column. If this is the situation, then you can use a combination of IF() and ISNUMBER() to accomplish this task.

Technical Solution | 2 min read

Suppose you are working in OpenOffice Calc and you are writing some functions. And you want to apply this function to large number of column cells. You can do it by dragging the formula upto the last cell. But dragging is some times a very boring or tedious job. So let us check two simple ways to accomplish this task.

Technical Solution | 2 min read

Suppose you are working in OpenOffice Calc. Your requirement is to copy the Column B value into Column A, if Column A is blank. If the columns have lots of cells, filling it manually is extremely tedious. So, read on to know how to do it.

Technical Solution | 2 min read

The vlookup or Vertical Look Up Function in Openoffice calc can be used to search a range of cells.Suppose you have two spreadsheets and you want to append data from one sheet to another. We can use vlookup() in open office calc to accomplish this task. vlookup() searches for values in one column and given values in another column in true condition. Read on to know how to user VLookup. The syntax for vlookup() is VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Technical Solution | 3 min read

SSH Protocol's features can be changed using the sshd_config file.The sshd_config file is the main configuration file that allows the user to make the changes in the features of SSH protocol. This file resides in /etc/ssh folder. There are many features for this protocol and these can be made or changed according to the users needs. By making configuration changes, the protocol also provides more security to the user and server/system that we are using. Some of the main features of the SSH protocol are listed below.

[OpenOffice Calc] How to replace cell value automatically if the cell value is a number

[OpenOffice Calc] How to to apply a formula in entire column without dragging in OpenOffice Calc

How to append data from one column to another if some of the cells in first column is blank in OpenOfficeCalc?

vlookup() function in OpenOffice Calc with an example

Features of SSH protocol