Ask Your Question

Find-replace at the beginning of each cell? [closed]

asked 2018-06-03 11:11:58 +0200

Adobe gravatar image

updated 2018-06-03 16:07:45 +0200

How do I match a beginning of the cell in find-replace dialog of Calc?

In regexp mode, I'd expect ^ to match that, but it does not work:

image description

The doc does not give any hints:

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-06-04 23:46:52.443684


In regexp mode, ^ works. If it does not work for you, please provide details.

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-03 12:09:57 +0200 )edit

@MikeKaganski: I've just added a screenshot.

Adobe gravatar imageAdobe ( 2018-06-03 16:08:18 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-03 16:39:56 +0200

updated 2018-06-03 16:40:18 +0200

^. -> ''&

edit flag offensive delete link more


Thanks, it works. But isn't it weird? One can use an end-of-line anchor directly, $, but for beginning of line one must to carry a group,

Adobe gravatar imageAdobe ( 2018-06-03 16:47:28 +0200 )edit

No, it isn't weird. When looking for $, the result (the characters in the line that might be replaced) is the trailing newline, which may be removed (it's for Writer; in Calc, it's also searchable - possibly because the machinery is common for the components). For the beginning of the line, there's nothing real that is represented by ^ which can be the result of the search.

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-03 17:31:14 +0200 )edit

Question Tools

1 follower


Asked: 2018-06-03 11:11:58 +0200

Seen: 59 times

Last updated: Jun 03 '18