Ask Your Question
0

Reverse selection using Calc?

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

zewny gravatar image

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

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 close merge delete

2 Answers

Sort by » oldest newest most voted
0

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

karolus gravatar image

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

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 +0200 )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 +0200 )edit
0

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

m.a.riosv gravatar image

To search for the cells without dot:

^(?!.*\..*).*
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 1,405 times

Last updated: Mar 27 '17