At 00:07 15/06/2009 +0300, Dotan Cohen wrote:
What setting can one make to Calc such that it will not complain that one is "pasting into cells that contain data" when the cell in question only contains formatting, such as a border?
My version (3.1 for Windows XP) does not behave as you describe. The warning (which occurs only if I have a tick at Tools | Options... | OpenOffice.org Calc | General | Input Settings | Show overwrite warning when pasting data) is not produced when there is only a border or background colour or text colour set in the cell.
When pasting data over data, I need a warning, but when pasting data into a cell that contains only formatting, there should be no warning!
Are you sure that you do not have, for example, a blank or blanks in the cells? Or perhaps some significant value that fails to show because of the cell formatting, e.g. a zero value formatted as "#"? Or a formula which happens to result in nothing appearing in the cell, e.g. "=xx" where xx is empty? All of those would (correctly) stimulate the warning message.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
