Ask Your Question
0

Reverse selection using Calc? [closed]

asked 2017-03-24 21:47:34 +0100

zewny gravatar image

updated 2017-03-25 19:46:48 +0100

Is there a way to reverse selection using Calc? Reverse selection is, having some of the cells selected e.g. in a square 10x10 cells, and then you got opposite cells selected in that square. I have found no solution or direct Calc modules for reverse selection and no mention this could exist. EDIT: I have found VBA module for an Excel... anyone please?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-28 16:33:55.742245

2 Answers

Sort by » oldest newest most voted
0

answered 2017-03-25 21:41:50 +0100

karolus gravatar image

updated 2017-03-27 17:39:37 +0100

Of course its possible by Script, but for what advantage??

  • select whole "frame" of interest, hold <ctrl>-key and start with deselecting the pieces…

Edit: advice based on you comment:

  • search ^(\d+)$ replace with $10
  • search (\.\d+)$ replace with 0

both with Option regular expression

edit flag offensive delete link more

Comments

DESELECTING is obvious. I have 8000 cells fullfiled, and some of the cells have a dot ( .), and the others don't have dots. I can search for presence of dots ( . ) so it marks all the cells that contain a dot, but I cannot search for dots absence. It's financial data for 2000 entreprises built like 64.3 billions or 60 millions. It is so important because I want to add a zero IF there is no dot, and if there is a dot and a number, (64.3 make to 640) I want to make them zero. That would be the adv

zewny gravatar imagezewny ( 2017-03-27 17:22:16 +0100 )edit

This freaking excel now makes dates from numbers and they say I CANT TURN IT OFF

zewny gravatar imagezewny ( 2017-03-27 17:28:34 +0100 )edit
0

answered 2017-03-27 22:52:56 +0100

m.a.riosv gravatar image

To search for the cells without dot:

^(?!.*\..*).*
edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2017-03-24 21:47:34 +0100

Seen: 2,606 times

Last updated: Mar 27 '17