Cannot delete user-defined cell formats

English
#1

I’ve got these odd user-defined formats that I wanna get rid of, but when I try deleting them, next time I open the format cells window, they re-appear. Any way to get rid of them? They’re unused in the whole spreadsheet.
image

After doing some testing, whenever I copy a text from another document with these formats, even if the text itself is just pasted with “values only” or something like that, the formats are automatically and irreversibly added to the document. I fear that these are corrupted formats that are causing the old document to bug/crash the editor, which is why I wanna get rid of them.

#2

The image uses area, but doesn’t tell me anything.
A very simple example .ods showing your issue would contain the needed information.
= = =
Concept:

  • A new spreadsheet is created with cell style Default. That style can be changed by the user.
  • The user may assign a different cell style to any cell or cell range.
  • Completely independent of the applied cell style the user can hard format the content of cells. Hard formatting overrules attributes based on the cell style.
  • Hard formatting even persists if a different named style is assigned to the cell.
  • To reset a cell to the attributes defined for the cell style you need to Clear Direct Formatting via the cell’s context menu (or Ctrl+M by default).
1 Like
#3

Here, I’ve made a new spreadsheet, and simply copied a single cell over from the old document. I pasted it with “Values only”. Somehow, there are a bunch of “user-defined” formatting entries. The only way I can keep this list clean is to filter all text through something that removes all formatting, such as xed.
Undoing everything possible, the user-defined list remains populated.

image
image1581×917 102 KB

image

I should probably change this thread from a generic issue to the specific issue I have, which is the document suffers from extreme lag, and constantly crashes. Despite it only being used until J200 or so, adding a single cell or row causes the app to freeze for 15 seconds or longer. Excel suffers the same. I’ve tried copying the stuff over to a new sheet, but the new sheet also suffers from the same problem. Considering how the user-defined stuff copies over even if I don’t copy formattings over, that’s why I had the theory that’s the cause on why the spreadsheet is behaving so weirdly.

#4

I will no longer answer to or comment on posts containing useless images but lacking real information.

#5

I’m sorry, I don’t get what you’re asking. Could you explain what you want me to do?

#6

Generally: Different Problem ==> New question!

However, the problems concerning “freezes” and the like, unrelated to the original subject of the question, may occur due to the special situation on your system and will not show for a user on a different system.
Talking about Excel you missed to tell to what file type (.ods or different) you stored your files.

#7

Apologies, I missed that sentence sent above.
Basically, the file originated on windows and excel, from a family member. I told them to get libreoffice and try opening the file with that, but no difference. Despite its small size, it was laggy and kept crashing the app. So, I tried making a new file and transferring the data, but it suffered from the same problem.

I’ve tried windows and excel, windows and libreoffice, linux and libreoffice, and multiple PCs. They all suffer from lag with this one specific file.
This is definitely something I’ll have to move to another topic however.
.

After some more testing, I seem to be able to delete teh user-defined formatting, but the moment I copy another cell over from the old document, they get re-added. Is this intended behavior? If so, is there any way to prevent this from happening?
Untitled 1.ods (10.0 KB)
I’ve attached the newly made ods file, but I doubt you can do much with it since I found the cause of the seemingly un-deletable nature of the formatting - I do delete them, but they just return when I add more information later.

#8

Sorry! I have to give up.

#9

That’s fair. I’ll try making a different thread for the bigger problem I’m experiencing, hope someone would know what is going on.
In the meantime, I guess this is resolved since I found out what was actually happening with user-defined formatting, it wasn’t refusing to be deleted but just kept getting re-added every time I pasted cells from an old document.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.