Apache OpenOffice (AOO) Bugzilla – Issue 98998
Applied Styles List Should Be Updated After Deleting Cells/Columns/Rows
Last modified: 2021-10-02 09:24:52 UTC
If you apply an AutoFormat style to the sheet or an area, the style should be re-applied after the deletion of rows and columns, because some styles have rows or columns with alternating properties (e.g. colour). Expected behavior after deleting one (or more) rows or columns in an autoformatted area: the style is applied again to the area resulting from the deletion of the rows or columns to keep the alternating properties (MS Excel 07 behavior)
I am not sure if this is the same thing as the problem I have had for years. I don’t want to make a duplicate if this is the same thing. If you delete a row, column or sheet, the Applied Styles box on the toolbar is reset to the defaults. The only way to get it back is to save and close the spreadsheet and then re-open it. This has gotten old over the years and it seems that it should be simple to fix. I don’t know about re-applying the style. If you delete anything and the style is still in use, it should not reset the list in the Applied Styles box anymore than it does in the Applied Styles list in the Styles window. Only if a style is no longer in use should the list change, and then only that one style should be removed.
Uncheck Formats in Delete Contents dialog to preserve formatting.
OK so my problem was not the same. It should go to another open bug report on the same problem or a new one created. One way to create my problem is to: 1. Delete a row or column. 2. Click on the Apply Formatting box and all formats used for that spreadsheet will be listed. 3. Click on another tab to view a different sheet. 4. Click on the Apply Formatting box and only the default formats will be listed. 5. In order to return the format list, you must save and close the file. When you re-open the file the row/column will be deleted, but the format list is restored to the Apply Formatting box. It seems to me that the formatting list should not be affected by any change of the spreadsheet except when a format has been removed from use. In which case it should only have that one format removed from the list.
Can not reproduce comment 3 Please attach example.
Created attachment 82215 [details] First step: check format list box
Created attachment 82216 [details] step 2: added column - no problem
Created attachment 82217 [details] step 3: deleted column - still no problem
Created attachment 82218 [details] step 5: selected column, box goes blank. If you abort box returns to normal
Created attachment 82219 [details] step 6: format list box still showing only defaults. Custom formats missing.
Created attachment 82220 [details] THIS is step 4: column selected. step 5 is when you delete and the box is still blank.
I couldn't just send you an example, but I attached screenshots. As I was creating the errors to get the screenshots, I did realize that I left out that I have custom formats which might be the reason they keep disappearing. Also as you can see in the screenshots, if you don't highlight the column (or row) it's fine. But when you highlight (or select a section) the format list box goes blank. After the operation (this happens when you move a selection as well) the formatting list box is still blank. When you click to see the list only the defaults are listed. The list does not come back after you undo.
Thank you. This is expected behavior when selection has multiple formats.
Not to me. It can be avoided when deleting rows/column simply by not selecting them. However, you need to select the rows/columns/cells when you are going to move them. It certainly isn't necessary if you are moving and inserting instead of moving and replacing, since no formats are being removed from the file. Usually when I do replace or even delete the formats are still being used somewhere else in the file. Wouldn't it make more sense to just remove the formats no longer being used instead of having to close the file and re-open it to restore the list?
Such format removal must be manual.
What about when no formats are being removed from the file? Why would the list revert to default if no custom formats were dropped?
Apache OpenOffice @ApacheOO · 4h @WhitePhoenixUS What is "expected" is judged from the perspective of users like you. There is always room for improvement. There should be a way for the Applied Styles list to be refreshed without closing and re-opening the file.
This issue has NOT been resolved. This is still an issue. Dismissing it is not solving it.
The history of this issue does not indicate when it was closed as NOT_AN_ISSUE. I won't dispute that. It is clearly an issue for the reporter. However, the attachments do not demonstrate any incorrect behavior. There is apparently a request for enhancement that was originally 7 years ago and then taken up again (not clear if same issue) in 2012-2014. The combination of that and it being about an old version of OpenOffice, with silence until today, suggests that this should be treated as resolved in some manner. Nothing in the screen captures demonstrates anything that is not clearly by design. Without an actual spread sheet we cannot determine if there is simply an user misunderstanding or some other situation. I am changing this to WONT_FIX (although OBSOLETE or IRREPRODUCIBLE are candidates as well). If a document and specific instructions on what to do that cause the problem and what the expected behavior is can be provided, we can look again. Even then, there might not be a foreseeable opportunity to do anything about it.
Created attachment 85487 [details] Current version of AOO Here are screenshots from two different spreadsheets. This happens with every spreadsheet I have ever created. The first screen shot shows the version of AOO that is being used. As you can see. When a column that has data in it is deleted the Apply Styles drop down menu is reset to defaults. The only way to get it filled again is to close the spread sheet and reopen it. Your reasoning for not fixing this is completely illogical. This may be the way it was designed, but how is it acceptable behavior? Does Excel do this? Does any other spreadsheet program do this? This happens with the Linux version as well.
Created attachment 85488 [details] Open spreadsheet 1
Created attachment 85489 [details] Apply formats box has various formats used in spreadsheet listed.
Created attachment 85490 [details] Formatted column deleted.
Created attachment 85491 [details] Apply styles box reset to defaults. Only way to restore the list is to close and re-open file.
Created attachment 85492 [details] 2nd spreadsheet.
Created attachment 85493 [details] Format listing in Apply Styles box.
Created attachment 85494 [details] Formatted column in 2nd spreadsheet deleted.
Created attachment 85495 [details] Apply styles box in 2nd spreadsheet also cleared.
(In reply to White Phoenix from comment #19) > Created attachment 85487 [details] > Current version of AOO > > [ ... ]Your reasoning for not fixing this is completely illogical. This may be > the way it was designed, but how is it acceptable behavior? Does Excel do > this? Does any other spreadsheet program do this? > > This happens with the Linux version as well. My reasoning is not that is unworthy, although there does need to be better demonstration of the problem. My reasoning is that no one has stepped up to fix it and I wanted to make it clear that no action is foreseeable at this time. Thank you for your additional analysis and explanation.
(In reply to andreaippo from comment #0) > If you apply an AutoFormat style to the sheet or an area, the style should be > re-applied after the deletion of rows and columns, because some styles have > rows > or columns with alternating properties (e.g. colour). > > Expected behavior after deleting one (or more) rows or columns in an > autoformatted area: the style is applied again to the area resulting from the > deletion of the rows or columns to keep the alternating properties (MS Excel > 07 > behavior) By now, is their recognition that the above request (the original 2009 report) is different than the problem described starting in 2012 and continuing to this point? What would be a better title for the issue in order to focus it on the 2012-reported problem?
(In reply to orcmid from comment #29) > By now, is their recognition that the above request (the original 2009 > report) is different than the problem described starting in 2012 and > continuing to this point? > > What would be a better title for the issue in order to focus it on the > 2012-reported problem? PS: Normally the issue would be split into two, but since the 2012 one has taken over and the original one received no discussion, I propose to take over the original issue as the one that all comments apply to.
(In reply to orcmid from comment #30) I propose to take > over the original issue as the one that all comments apply to. To be clear, I mean forget the 2009 original report and treat this as the 2012-reported issue, with an appropriate new title. We will still have to find others able to reproduce it absent a sample document to manipulate.
Created attachment 85498 [details] sample I can confirm the bug mentioned by White Phoenix in 2012 with the attached file. Steps: 1) Open attached file 2) Make sure the 'Apply Style' drop down menu is visible in the formatting toolbar 3) Notice the two custom styles 'Test' and 'Test 2' are listed in the drop down 4) Select and delete column D 5) Select column B 6) Notice that the 'Apply Style' drop down has now been reset and both custom styles are missing AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:51 - Linux x86_64
So White Phoenix has created a new bug for this issue 126939.
Change title for this to be the original for 126939. That one will be a duplicate.
Flag confirmation in version 4.1.2.
*** Issue 126939 has been marked as a duplicate of this issue. ***
I see the actual behaviour not as a defect. The program doesn't know what was the intention for a(n auto)formatting. And what is with other (hard or soft) formattings (bold, styles, conditional formatting …) that were applied after the AutoFormat? Will they stay preserved?
*** Issue 25213 has been marked as a duplicate of this issue. ***
AutoFormat should react like "Format as table" from MS-Excel. If you add a new row at the end, the format still continue and make also a copy for previous formulas.
I don't understand the duplicate. It has nothing to do with this issue. Which is more about styles. Plus there is a link to an extension that filles the gap on thew request. Why the duplicate lkinking then? I dont get it? oooForum can you maybe explain? I would like to understand. For the Issue that White Phoenix rose. I try to rewrap the issue from my point of view: After creation of a custom Style, the style is applied to one Cell. If this Cell becomes deleted, it becomes removed from styles list. In my opinion this is odd at best. Why does the drop down list first show all attributed styles and then remove some while keep others? So lets look further. On the side bar, when we load the nice sample from White Phoenix we can select in Styles and Formatting applied Styles. The list consists of Default, test and test 2 if you look at the sample file. Now when we remove the Column and click somewhere, please notice that the applied Styles go blank. -> This is a bug and In my opinion should not happen. I assume that this has an effect on the styles drop down which White Phoenix talks about. Now I add the latest confirmation. But can anyone confirm my observation? I tested on Linux. thx!
(In reply to Peter from comment #40) > I don't understand the duplicate. It has nothing to do with this issue. For me, this is an enhancement. Both users would have same function like "Format as table".