Apache OpenOffice (AOO) Bugzilla – Issue 119226
Rogue user defined formats can't be permanently deleted
Last modified: 2013-12-05 07:28:49 UTC
A number (~100) of 'User-defined' time formats have appeared in the 'Numbers' tab of the 'Format Cells' dialogue box. All take the form [SS].0"............" with anything up 300 full stops. It is possible to remove them using the 'remove' button, but if the format cells dialogue box is closed & reopened, the rogue formats reappear. These entries swamp the genuine, useful formats, making them impossible to find.
I don't know if you have done but you have to click on the [Remove] button and the also on [OK] to really delete it. After that this suer-defined format was gone in my tests. However, I've no clue where these ~100 user-defined formats origins from.
Quite the opposite. Clicking remove button deletes the formats. They are no longer there. Pressing the OK button closes the dialogue & (as I said) when it is reopened, the formats reappear.
Please provide the steps you followed so we get a clue of the user defined formats that you mentioned here. (In reply to comment #2) > Quite the opposite. Clicking remove button deletes the formats. They are no > longer there. Pressing the OK button closes the dialogue & (as I said) when > it is reopened, the formats reappear.
Created attachment 80219 [details] Screen shot of the format cells dialogue box, showing the rogue formats The formats should be visible in the formats window - the one's of the form '-1139158230.0..........................' I've not counted but there must be around a hundred of them.
There are no steps, the formats are just *there* (?!?)
Formats not encountered in various revisions.
I've upgraded to the newest version of calc, removed every last undesirable formats. Reopening the dialogue box no longer restores the formats, but closing down calc and reopening it still does. I can try re-installing the program if anyone thinks that might help, but last time I upgraded, the process seemed analogous to re-installation anyway, so I can't see how it would (?)
Do you see these formats with every document or only for special documents? A format cannot be removed, if it is in use. So please look, whether a cell uses such format directly or whether a cell style uses this format.
I've checked all the cells in the two documents that I use most often - no sign of any of the formats, let alone all of them. That being said, they do seem to appear in only some documents; not just these two, but some do seem OK, as do new ones. Although if I try to copy sheets, sections or even individual cells from the affected documents, the new ones appear to become 'infected.'
Please attach an infected spreadsheet.
Created attachment 82042 [details] Blank spreadsheet with rogue user defined formats.
Thank you. Confirmed with AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7