Reverse selection using Calc?

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?

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

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

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

To search for the cells without dot:

^(?!.*\..*).*