https://bugs.freedesktop.org/show_bug.cgi?id=70074
Priority: medium
Bug ID: 70074
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: number formatting does not work
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: matswolp...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.5.2 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
