Summary: |
If different format in cells, Standard format not applied to all of them in 1 action |
Product: |
LibreOffice
|
Reporter: |
Timon <kaktebyavirubit> |
Component: |
Spreadsheet | Assignee: |
Not Assigned <libreoffice-bugs> |
Status: |
NEW
---
|
QA Contact: |
|
Severity: |
normal
|
|
|
Priority: |
medium
|
CC: |
bfo.bugmail
|
Version: |
3.5.4 release | |
|
Hardware: |
x86 (IA32) | |
|
OS: |
Windows (All) | |
|
Whiteboard: |
|
i915 platform:
|
|
i915 features:
|
|
Attachments: |
Example file with different cell formats
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 62629 [details] Example file with different cell formats there is an xls file with 4 cells of the following format cell A1, category Number, format -1234.12 cell A2, category Number, format Standard cell A3, category Number, format Standard cell A4, category Number, format -1234.12 Standard format options: fractional part - 0 leading zeros - 1 Format code - Standard -1234.12 format options: fractional part - 2 leading zeros - 1 Format code - 0,00 If we select all four cells and try to apply Standard format to all them, everything will remain in original places. Cells A1 and A4 have -1234.12 format. But if we change format to any other, and then to Standard, then all will be applicable.