Using Calc Find and Replace [cntl-H], I use the options Direction "Columns" and Search in "Values". I keep the Find and Replace window open.
Often, after editing the spreadsheet, but not always, the Find and Replace window reverts to the default Direction "Rows" and Search in "Formulae". I can't deduce why it does this.
Why does it do this?
Can I stop it reverting to the default?
David Lynch
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded