I’m converting from Apache and had occasion to copy-paste a range of cells from AOO into Calc. When I did it over cells containing data there was no overwrite warning. I checked the options and Warning was selected. Then I experimented with data copied from other cells within the Calc sheet and that gave the proper warning. Apparently the source of the data matters.
Is there someway to make the warning universal?