| Summary: | FORMATTING: number formatting changed by inserting or deleting sheets | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | matthias wolpers <MatsWolpers> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | barta |
| Priority: | medium | ||
| Version: | 4.0.5.2 release | ||
| Hardware: | Other | ||
| OS: | macOS (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | a demo file that shows the screwed up number formatting problem | ||
Created attachment 87152 [details]
a demo file that shows the screwed up number formatting problem
to see the issue:
1. open the file
2. observe number formatting in col J
3. insert one more sheet.
4. go back to initial sheet and re-observe number formatting.
the obs in step 4 is what i should expect to see all along. something masks this, and this something gets pushed aside by inserting or deleting sheets.
the original description is too foggy now that a repro scenario is available. if you read this, pelase begin with the attachment and its comment. apologies. mats tested with 4.0.5 and 4.1.2 final releases under Win7 64bit I see no formatting change after adding a new sheet. maybe Mac specific issue? do you still see this with 4.1.2 release? i found a version 4.1.2 for mac os x. with that, the problem has mystically disappeared: i open the sample file, and the correct formatting appears immediately. i'm setting this to resolved/fixed, then. thanks for the hint, as well. correct status is RESOLVED WORKSFORME since we don't know exactly which commit fixed it. |
Problem description: formatting appears to not happen. Steps to reproduce: 1. in a spreadsheet with rows polulated from A through O by various numbers, i have one col that is all money amounts. the values are however computed from the other numbers in the other columns. computed numbers are printed up to 6 decimals deep, in bold italics. 2. i select some figures in the column with the money amounts, right-click and select format cells. The cell formatting dialog opens and in tab "Numbers" shows 0 decimal places, 1 leading zero, unticked boxes "negative numbers red" and "thousands separator", category= standard, language = Default (German (Germany) 3. i change settings to 2 decimals, and neg numbers red and confirm with OK. The format cell dialog disappears, the spreadsheet is unchanged. 4. i repeat the experiment with a different set of cells: same result. another repeat, preceded by "clear direct formatting" for the selected cell group: this also has no visible effect. 5. i made a copy spreadsheet to a new file, and in the new file the formatting is as i would expect. i made a copy of the whole file with maybe 30 or so sheets and the new copy showed the same broken behaviour. As soon as i deleted any one sheet to make a minimal demo for this ticket, the broken formatting gets repaired behind the scenes. This means i cannot give you an example file with fake data. and since the data in question are confidential, i cannot provide the broken file either. Current behavior: see 3. above, formatting changes do not make it through to displayed spreadsheet. Expected behavior: formatting changes should become visible without first deleting other sheets -- remarks: The observations in 5. mean (at least to me) that i have a workaround: insert then delete another sheet. In fact insert is enough. They also mean that i cannot give you an example file with fake data. since the real data in question are confidential, i cannot provide the broken file either. if this means you cannot analyse, then do feel free to close this issue and i won't say a harsh word about it. OTOH, i can and will give you a sample file that does not show the error but at least gives you the basic structure of the file. the offending column in the other file is K. The sheet in real has ca 50 lines, and the other 29 or so sheets are similar in structure but with different numbers. Operating System: Mac OS X Version: 4.0.5.2 release