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 with0
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:
^(?!.*\..*).*