Created attachment 117010 [details] screenshot I already posted the question to Q&A but no replies. The help (https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables/it) says: Per applicare una formattazione automatica a un foglio o a un'area di celle selezionata 1. Selezionate le celle da formattare, incluse le intestazioni di righe e colonne. (nota: almeno 3x3) 2. Scegliete Formato - Formattazione automatica. 3. Per selezionare le proprietà da includere nella formattazione automatica, fate clic su Extra. 4. Fate clic su OK. Il formato viene applicato all'area di celle selezionata. (EN version: Select the cells, including the column and row headers, that you want to format. Choose Format - AutoFormat. To select which properties to include in an AutoFormat, click More. Click OK. The format is applied to the selected range of cells.) I observe: - at item 1 "including the column and row headers" is superfluous being implicit; you should point out to select at least 3x3 cells, otherwise the option is inhibited. - at item 3 "fate clic su Extra" (click More) but I don't see any of that (look at the attachment). Then over in the help: Per definire una formattazione automatica per fogli elettronici Potete definire una nuova formattazione automatica che sia disponibile a tutti i fogli elettronici. 1. Formattate un foglio. 2. Scegliete Modifica - Seleziona tutto. 3. Scegliete Formato - Formattazione automatica. 4. Fate clic su Aggiungi. 5. Nella casella Nome della finestra di dialogo Aggiungi formattazione automatica, inserite un nome per il formato. 6. Fate clic su OK. (EN version: Format a sheet. Choose Edit - Select All. Choose Format - AutoFormat. Click Add. In the Name box of the Add AutoFormat dialog, enter a name for the format. Click OK.) I observed that "Choosing Edit-Selecting All" LO crashes("does not reply" on the top line). No crash if I select a block of cells (but almost 4x4) instead of "all sheet". Can you verify? Thanks
(In reply to gmarco from comment #0) > > (EN version: Format a sheet. Choose Edit - Select All. Choose Format - > AutoFormat. Click Add. In the Name box of the Add AutoFormat dialog, enter a > name for the format. Click OK.) > > I observed that "Choosing Edit-Selecting All" LO crashes("does not reply" on > the top line). > No crash if I select a block of cells (but almost 4x4) instead of "all > sheet". > > Can you verify? Thanks No crash with Verze: 5.0.0.1 (x64) ID sestavení: 9a0b23dd0ab9652e0965484934309f2d49a7758e Win7
After installing 4.4.4.3 I confirm what said
Hi Gmarco - I'm sorry but it's a little unclear exactly what you are reporting here. It seems to me to be partly a UX issue (suggestion pertaining to the headers being superflous) and partly a crash (doing different steps). Is this the case? If so, this bug needs to be closed as INVALID and the issue needs to be reported separately as we need one bug report per issue. If this isn't the case, can you better explain what the *single* issue is. If possible, English only :) Thanks! Mark as UNCONFIRMED after clarifying. Thanks again
Also, with 4.4 you see the issue also? If so, please update the version field (version is oldest version that the problem is seen, not the latest). Thanks one more time
(In reply to Joel Madero from comment #4) > Also, with 4.4 you see the issue also? If so, please update the version > field (version is oldest version that the problem is seen, not the latest). > Thanks one more time Hi Joel, I am using now 4.4.5.2 and nothing has changed LO update check says "LibreOffice 4.4 is updated").
Please try with 5.0.0.2 & with a fresh profile: https://wiki.documentfoundation.org/UserProfile Thanks
Created attachment 119753 [details] autof-sample-ods1 (sample ods sheet) (In reply to Joel Madero from comment #3) OK I have now subdivided the questions and will post two other reports. Sorry, but my LO is in Italian language, so I cannot show all in English (attachments are in Italian). Referring to help (https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables/it and attach. "autoformat1" mark2), it says: To Define an AutoFormat for Spreadsheets You can define a new AutoFormat that is available to all spreadsheets. 1.Format a sheet. 2.Choose Edit - Select All. 3.Choose Format - AutoFormat. 4.Click Add. 5.In the Name box of the Add AutoFormat dialog, enter a name for the format. 6.Click OK. Well, after step 6, if I click OK LOC hangs (see attach. "autof-app3" and "autof-app4" where "Non risponde" means "Not responding"). I have to click Chiudi (in IT), I think Close in EN. But ... clicking OK (even if it would be a mistake), it is not good to get a crash.
Created attachment 119754 [details] autoformat1 (screenshot)
Created attachment 119755 [details] autof-app3 (screenshot)
Created attachment 119756 [details] autof-add1 (screenshot)
Created attachment 119757 [details] autof-add3 (screenshot)
errata-corrige, please correct: Well, after step 6, if I click OK LOC hangs (see attach. "autof-add1", "autof-app3" and "autof-add3" where "Non risponde" means "Not responding"). I have to click Chiudi (in IT), I think Close in EN. But ... clicking OK (even if it would be a mistake), it is not good to get a crash.
I further verified as follows. Given that the CLOSE button is visible only after having opened an Add or Delete or Rename dialog, but the OK button also is simultaneously visible and clickable, then, clicking OK, LO hangs.
Using now LO 5.0.3.2 nothing has changed, following instructions as in comment 7 and 12, LO still hangs. Can someone reproduce it?
Created attachment 124425 [details] Backtrace from the hanged process I can confirm this on 5.1.2.1 So steps to reproduce: 1. Open the attached .ods document (copying the table to a new document WITH formatting also works, copying without formatting does not work, so it has something to do with the formatting). 2. Select all cells (selecting just the data does not work) 3. Format → Autoformat styles → Add, type in a name 4. OK, OK After the last OK the dialog disappears and LibO will hang. If all the alternating background colors are removed before running these steps, it will not hang.
Hangs deserve major. Because of the specificity of the bug ("with certain formatting pattern") I'm leaving as medium. If it's a regression please let us know and we'll bump to high.
Retesting the question in LO 5.2.3.3 I get no more the hang problem, so I edit the status as RESOLVED-FIXED, edit yourself it as you like.
thanks for testing again - great that it works now.