Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

If you want a range of number to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

See the following simple example (after having pressed Find All dialog `Search Results is shown and all matching cells are highlighted)

image description

Hello,

If you want a range of number to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

See the following simple example (after having pressed Find All dialog `Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Hello,

If you want a range of number to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containg a A or an B)

See the following simple example (after having pressed Find All dialog `Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Hello,

If you want a range of number to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containg a containing A or an B)

See the following simple example (after having pressed Find All dialog `Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Hello,

If you want a range of number numbers to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog `Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Hello,

If you want a range of numbers to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option `Regular expressions). Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog `Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Hello,

If you want a range of numbers to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog `Search Results Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Hello,

If you want a range of numbers to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Update 1 for exact matching: Use regexp ^[1-4]$

Hello,

If you want a range of numbers to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Update 1 for exact matching: Use regexp ^[1-4]$

in Find

Hello,

If you want a range of numbers digits to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Update 1 for exact matching: Use regexp ^[1-4]$ in Find

Hello,

If you want a range of digits to be found, use [pattern].

Example - you want to find all cells containing at least one out of the numbers digits 1 to 4 (i.e one of 1,2,3,4) use [1-4] (don't forget to tick option Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

Note: In this case [1-4] is also a short version of [1,2,3,4] (Now it is easy to adapt to other question like Show me all cells containing A or B)

See the following simple example (after having pressed Find All dialog Search Results is shown and all matching cells are highlighted)

image description

Have a nice trip to the world of regular expressions!

Update 1 for exact matching: Use regexp ^[1-4]$ in Find