Max Depth:

Bug 107575 depends on 175 bugs:

view as bug list

•    107575: [META] Number format bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    33962: Add feature that replaces numbers and dates, formatted as text, with real numbers (formerly: Add CT2N Extension) [NEW; assigned to libreoffice-bugs]
  •    37755: FORMAT: formats genering text strings (from cell content) doesn't adhere to text alignment format. [NEW; assigned to libreoffice-bugs]
  •    42607: Help + Docu should explain importance of settings 'Calc-Calculate-Date base setting' for document import and copy dates [NEW; assigned to libreoffice-bugs]
  •    44453: FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned [NEW; assigned to libreoffice-bugs]
  •    45952: Format Cells: Binary and Hex with digit grouping [NEW; assigned to libreoffice-bugs]
  •    46448: Allow custom locale settings for decimal separator, group separator, default date and time formats [NEW; assigned to libreoffice-bugs]
  •    52929: [EDITING] Special number format for complex numbers [NEW; assigned to libreoffice-bugs]
  •    55960: Filling cells with incremental numbers – wrong numbers [NEW; assigned to libreoffice-bugs]
  •    60777: FORMATTING sum of different currencies should not be one of these currencies [NEW; assigned to libreoffice-bugs]
  •    63536: Add Accounting format code to currency list [NEW; assigned to libreoffice-bugs]
  •    63848: Better default formatting after user editing of a cell [NEW; assigned to libreoffice-bugs]
  •    66183: FORMATTING: Save/store User Defined Formats for Future Use [NEW; assigned to libreoffice-bugs]
  •    66319: returned complex numbers use decimal point regardless of locale [NEW; assigned to andreas.heinisch]
  •    68045: User defined date acceptance patterns are used only for default language [NEW; assigned to libreoffice-bugs]
  •    75627: General number format change leads to inconsistent/lost formatting [NEW; assigned to libreoffice-bugs]
  •    76245: Other: Support IEEE 754-2008 (ISO/IEC/IEEE 60559:2011) binary128 quadruple precision [NEW; assigned to libreoffice-bugs]
  •    77834: FORMATTING: Option to keep numeric precision (significant figures) as entered [NEW; assigned to libreoffice-bugs]
  •    77951: FORMATTING: Enhancement Request - Specify number of significant figures, not just decimal places. [NEW; assigned to libreoffice-bugs]
  •    84641: Standard Date Format cannot be permanently changed to dd.mm.yyyy or yyyy-mm.dd [NEW; assigned to libreoffice-bugs]
  •    85410: Remove Decimal Space button causes 10 decimals before it decreases one at a time [NEW; assigned to libreoffice-bugs]
  •    89944: Please unify indication of "[NatNum5]#, ## 0" [NEW; assigned to libreoffice-bugs]
  •    90791: Accounting format broken for Thai Baht (THB) [$฿-41E] [NEW; assigned to libreoffice-bugs]
  •    91038: Importing xls with cell format on money, after changing page layout and saving, formating is changed do decimal values [NEW; assigned to libreoffice-bugs]
  •    91124: Numbers in base other than ten [NEW; assigned to libreoffice-bugs]
  •    96954: setting General number format does not work with selected cells if they are formatted to different number formats [NEW; assigned to libreoffice-bugs]
  •    100593: Add fraction number format option to reduce forced denominator [NEW; assigned to libreoffice-bugs]
  •    101808: no option to set length in settings of cells as TEXT [NEW; assigned to libreoffice-bugs]
  •    103414: Allow decimal place commands to modify additional number formats [NEW; assigned to libreoffice-bugs]
  •    107993: FORMATTING: Free space filling broken with thousands separator [NEW; assigned to libreoffice-bugs]
  •    108373: Conditional formatting changes format of dates and numbers [NEW; assigned to libreoffice-bugs]
  •    112631: [META] Number format content panel of the Properties deck/tab of the sidebar [NEW; assigned to libreoffice-bugs]
    •    95385: Sidebar : category General does not exist and inconsistent with cell formatting dialog (see comment 7, comment 8, comment 21) [NEW; assigned to libreoffice-bugs]
    •    112472: "Number" number format listbox entry should toggle the format as number uno command [NEW; assigned to libreoffice-bugs]
    •    95019: SIDEBAR: Add "Format as number" icon to sidebar [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    114216: Thousands separator check box incorrect after change from scientific to number [RESOLVED FIXED; assigned to raykowj]
    •    114516: Selecting Date in sidebar number format dropdown disables cell input on double click [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    114519: Sidebar Number Format drop down does not update cell contents on number format selection change [RESOLVED FIXED; assigned to raykowj]
  •    113072: [META] Numbering format presets for lists, pages, etc [NEW; assigned to libreoffice-bugs]
    •    36574: [FORMATTING] Can't make default Writer bullet types locale dependent (french bullets / dash bullets) [NEW; assigned to libreoffice-bugs]
    •    37610: More bullet sizes would be helpful [NEW; assigned to libreoffice-bugs]
    •    52048: FORMATTING: Support user-defined identifier sequences (numbering) for ordered lists (refer comment 4) [NEW; assigned to libreoffice-bugs]
    •    98086: FORMATTING: Support reduced Latin numbering style for lists, without q, w, y [NEW; assigned to libreoffice-bugs]
    •    124608: Add a spellout outline numbering style [NEW; assigned to libreoffice-bugs]
    •    128640: Numbering List Presets in Bulgarian (4x), Russian (4x), Serbian (4x) [NEW; assigned to libreoffice-bugs]
    •    138462: Adding bullet/footnote/endnote/page number in Bengali language [NEW; assigned to libreoffice-bugs]
    •    160042: numbering style bugs [NEW; assigned to libreoffice-bugs]
    •    42558: FORMATTING: Missing Arabic Abjad numerals for page numbers [RESOLVED FIXED; assigned to erack]
    •    57337: FORMATTING: Impossible to configure the default bullet styles [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    66212: Hebrew Numbering incorrect above value ten (seeing Kaf instead of Yod Aleph) [RESOLVED FIXED; assigned to yossizahn]
    •    77803: Implement separate numbering styles for Chinese and Japanese (they're similar, but not the same) [RESOLVED FIXED; assigned to suokunlong]
    •    103345: FILEOPEN: Non-English numbering characters "①, ②, ③", "α, β, γ" are converted to digits (1,2,3) [VERIFIED FIXED; assigned to samuel.mehrbrodt]
    •    106507: Add 4 more default bullet types to toolbar split button and dialog [RESOLVED WONTFIX; assigned to libreoffice-bugs]
    •    113356: Numbering formats appearing as blank entries [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    114078: Numbering format strings no longer found in pootle [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    114622: add static list of available Native Numbering entries, for example Persian / Arabic-Indic / Hindi numbers [RESOLVED FIXED; assigned to xsoh.k7]
    •    115679: FORMATTING: can not make a zero-padded numbered list format [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    115951: Arabic alphabet page number format is not showing correctly [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    120214: Grammatical gender concordance for "spell out" numbering feature [RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
    •    120629: FILESAVE DOC: Hebrew numbering sequence choice reverted to 1,2,3... when saving as .doc [RESOLVED FIXED; assigned to jluth]
    •    143433: When inserting a FOOTNOTE or ENDNOTE, allow user to chose an alternative anchor character style [RESOLVED WONTFIX; assigned to libreoffice-bugs]
    •    145239: Customize footnote symbols [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    113307: Conditional formatting: false cell number format displayed that's defined by a cell style [NEW; assigned to libreoffice-bugs]
  •    115078: Automatically insert a decimal point like in Excel [NEW; assigned to libreoffice-bugs]
  •    115335: Formatted cell text is not exposed to assistive technologies [NEW; assigned to libreoffice-bugs]
  •    116106: FORMATTING: LO Calc Date as Number lost in saving [NEW; assigned to libreoffice-bugs]
  •    117365: Decimal separator is not updated on language change [NEW; assigned to libreoffice-bugs]
  •    118337: Evenly fill space between repeated character-fill in number formats [NEW; assigned to libreoffice-bugs]
  •    118345: FILESAVE: Decimal part of scientific numbers not correctly saved in ODF with '?' [NEW; assigned to libreoffice-bugs]
  •    119509: FORMATTING: cells with a General format are formatted to the result type and calculation not as desired in ODS (OK in XLSX) [NEW; assigned to libreoffice-bugs]
  •    121851: Calc loses time zone information for datetime cells [NEW; assigned to libreoffice-bugs]
  •    122756: Unable to clone currency and other cell Number format in a Writer table [NEW; assigned to libreoffice-bugs]
  •    123113: type french date with field correctly (first day = "1ER") [NEW; assigned to libreoffice-bugs]
  •    124807: Cell formatting and calculations of Sexagesimal (base 60) angular measurement, aka DMS [NEW; assigned to libreoffice-bugs]
  •    127473: Regression: Formatting error using format "TT.MM.JJJJ HH:MM:SS,000000000000000000" [NEW; assigned to libreoffice-bugs]
    •    127170: Clarify clock time (HH:MM, MM:SS, ...) and duration time ([HH]:MM, [MM]:SS, ...) formatting in help; (ignore the MM month vs minute discussion) [NEW; assigned to libreoffice-bugs]
  •    128273: FORMATTING Calc changes a number format [NEW; assigned to libreoffice-bugs]
  •    129826: Storing language based user defined format codes of cells does not work for color code based entries. [NEW; assigned to libreoffice-bugs]
  •    132111: Initial cell's number format in Writer table is reported wrong [NEW; assigned to libreoffice-bugs]
  •    132244: Support ‰ (per mille) number format [NEW; assigned to libreoffice-bugs]
  •    135541: Dates are entered inconsistently, switching between day and month. [NEW; assigned to libreoffice-bugs]
  •    135826: EDITING: Copy and paste a cell changes the content from '27-Jul-93' to '27-Jul-89' (1904 vs 1900 epoch nulldate) [NEW; assigned to libreoffice-bugs]
  •    139517: Calc: Date values toggle between date and text when changed [NEW; assigned to libreoffice-bugs]
  •    141303: Style of page numbering isn't applied on PDF page number display on PDF viewer [NEW; assigned to libreoffice-bugs]
  •    141870: Fractional formatting: Sequence of preferred denominators (Base 2 mainly); also Writer TextFields [UNCONFIRMED; assigned to libreoffice-bugs]
  •    142093: EDITING: Paste Special Date&Time inconsistent for no option, transpose and as link [NEW; assigned to libreoffice-bugs]
  •    146404: Number Format Code: Not all color codes are saved [NEW; assigned to libreoffice-bugs]
  •    149898: Calculating datetime differences - different results depending on number format [NEW; assigned to libreoffice-bugs]
  •    150264: FORMATTING: UI improvements to add automatic data validation of dates [NEW; assigned to libreoffice-bugs]
  •    153010: Inconsistency and confusing strings when numeric field's numbering format is not available for a language [NEW; assigned to libreoffice-bugs]
  •    153213: [NatNum12] does not handle fractions properly [NEW; assigned to libreoffice-bugs]
  •    153495: Make an easier workflow for Calc cell user-defined formats cleanup [NEW; assigned to libreoffice-bugs]
  •    154131: Add option to not detect numbers in scientific notations (like 1E1 or 5E2) at text paste / import [ASSIGNED; assigned to jumbo4444]
  •    157612: Calc blank digit ('?') format have the wrong width [NEW; assigned to libreoffice-bugs]
  •    159930: Minus sign mis-placed with format ".00" until save/reload [NEW; assigned to libreoffice-bugs]
  •    33689: Date format problem using the Dutch (NL) localization [CLOSED FIXED; assigned to jumbo4444]
  •    42518: No warning when wrong decimal separators are used, resulting in bad outcome for formulas in tables [RESOLVED FIXED; assigned to erack]
  •    46452: Default formatting can not be changed [CLOSED DUPLICATE; assigned to libreoffice-bugs]
  •    49540: Writer tables loosing numbers when switching the language in the number format [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    51059: Formatting: Allow Thin Space as alternative thousands separator for all languages [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    62128: FORMATTING: Allow replacing comma with anything else in number format #,##0 [CLOSED DUPLICATE; assigned to libreoffice-bugs]
  •    66089: FORMATTING: Wrong currency (and number) format from file created with Excel (see comment #17 for instructions to reproduce!) [VERIFIED FIXED; assigned to aron.budea]
  •    66584: EDITING: Format cell.. [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    67822: Digits in number formatting are lost [CLOSED FIXED; assigned to libreoffice-bugs]
  •    69356: FORMATTING: DDDDD ordinal day date format not yet available [CLOSED FIXED; assigned to libreoffice-bugs]
  •    73713: FILESAVE: when saving as .XLS cell formatting of blank cells is not remembered [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    76441: FORMATTING: MM:SS time input if formatted as such [RESOLVED FIXED; assigned to erack]
  •    83301: Allow more than 3 conditional format codes [CLOSED WONTFIX; assigned to libreoffice-bugs]
  •    84964: Number Format: Currency does not follow System Preferences (OSX 10.9.5) [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    86119: TOOLBAR: Number Format Decimal and Standard doesnt show toggle correctly [RESOLVED FIXED; assigned to gulsah.1004]
  •    86132: TOOLBAR: Improvement to number format tooltips [RESOLVED FIXED; assigned to philipz85]
  •    86700: Add more Number Formats [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    90684: Hide decimal separator if number has no decimal part and no trailing zeroes are to be shown [CLOSED WONTFIX; assigned to libreoffice-bugs]
  •    90826: number format with text gives sign at wrong position [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    91405: calc does not save explicitly defined cell formatting for date functions [CLOSED WORKSFORME; assigned to libreoffice-bugs]
  •    93469: FILESAVE: ODS - User defined number formats with question marks not retained [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    96578: EDITING and FILESAVE xlsx file shows wrong number/format (with Polish locale..?) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    96711: Add russian rouble new format to money formats [CLOSED FIXED; assigned to erack]
  •    96723: FILESAVE: custom cell number format with embedded text in decimal part not saved in ods [VERIFIED FIXED; assigned to jumbo4444]
  •    98362: Behavior interpreting input: 1-, 1+ are treated as number, not as text [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    98590: Confusing behavior when cell with number is changed to format Text: no indication if cell value type is number or text [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    100822: FILEOPEN: xlsx file: imported DateTime cells are empty with certain non-en_US locales (Excel 2010 compatible) [RESOLVED FIXED; assigned to erack]
  •    102075: FILEOPEN: XLSX - Date shown as "[$-F400]H:MM:SS AM/PM" instead of according to locale [RESOLVED FIXED; assigned to erack]
  •    103173: FILESAVE: XLSX - Calc doesn't save/load cell's Number Format language/locale [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    104158: Crash upon opening Table -> Number Format... in Writer [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    105720: Left-aligned currency symbols in currency fields are displayed in the middle of the preceding cell (in some builds) [VERIFIED FIXED; assigned to mrcekets]
  •    106322: Applying a number format changes textual content to 0 (happens also when applying a table style) [RESOLVED FIXED; assigned to erack]
    •    131025: Writer document with tables lost data in cells (apparently) replacing with 0 [VERIFIED FIXED; assigned to jluth]
  •    108338: Numeric formatting using the _ does not work [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    108588: FILEOPEN: XLSX - Incorrect cell date formatting when locale is en-GB [CLOSED NOTABUG; assigned to libreoffice-bugs]
  •    112844: FORMATTING Decimal places should be reset when value is 0 [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    114927: In the Austrian localization of Calc the German word "Januar" isn't recognized as a date. [VERIFIED FIXED; assigned to erack]
  •    115093: FORMATTING: Copying date formats in cells changes date for all cells in column [VERIFIED FIXED; assigned to dennisfrancis.in]
  •    115528: Datetime2 extension gives error in LO 6.0.0.3 (locale-dependent) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    116450: CONVERSION FORMAT DATE [CLOSED WONTFIX; assigned to libreoffice-bugs]
  •    116579: Date format setting not recognised [RESOLVED FIXED; assigned to erack]
  •    117575: Number formats: Thousands separator should be space if not preceded by a digit. [RESOLVED FIXED; assigned to jumbo4444]
  •    118324: Blank digit ('?') in integer not saved correctly in ODF spreadsheets (works in .xlsx) [RESOLVED FIXED; assigned to jumbo4444]
  •    118338: Character-fill doesn't work with space thousand separators [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    118682: FILESAVE DOCX formula field exported as plain text, losing the formula [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    133647: The docx equation does not convert properly in newest LO [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    119586: FORMATTING: Changing the thousands separator in number format loses separators for digit grouping in numbers from million and above [CLOSED NOTABUG; assigned to libreoffice-bugs]
  •    120648: Character format not preserved in Writer table when saved. TABLE [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    121499: Wish: Add Number format for representation of school grades (Calc) [CLOSED WONTFIX; assigned to libreoffice-bugs]
  •    123752: EDITING: Regression in handling of the group separator in formula context [VERIFIED FIXED; assigned to erack]
  •    124209: AM/PM time notation in CALC [CLOSED NOTABUG; assigned to libreoffice-bugs]
  •    124994: Cell Formatting for URL websites, or other URI schemes [RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
  •    127363: Add Sept as an abbreviation of September [VERIFIED FIXED; assigned to erack]
  •    128314: Obscure and unmanageable long month name capitalization rules in date formats (ru-RU) [RESOLVED FIXED; assigned to erack]
  •    129613: NEW FORMAT:Some characters with the any symbol [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    131312: calc: funny / odd / wrong display of value in scientific format [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    133342: FORMATTING Preserve space in French percentage when Add/Delete decimal places [RESOLVED FIXED; assigned to jumbo4444]
  •    135103: Decimal precision fail in addition [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    136050: Calc changes the cell type from time to date when the format-code is changed [CLOSED NOTABUG; assigned to libreoffice-bugs]
  •    138288: Formatting numbers to currency (ZAR) not functional [RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
  •    140052: FORMATTING, FILEOPEN, FILESAVE: Custom number cell format changed after save/open file [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    142186: Cell formatting code #,##0"." receives input field 123.45 as 12345 [VERIFIED FIXED; assigned to erack]
  •    142216: FILEOPEN XLSX Excel default time formats don’t match in Calc with Hungarian locale [VERIFIED FIXED; assigned to erack]
  •    143526: Korean NumberFormats are missing and wrong on the Code [RESOLVED FIXED; assigned to sungdh86]
  •    145827: 'Standard' cell format turns to Date if it's the first cell in a column [CLOSED DUPLICATE; assigned to libreoffice-bugs]
  •    146367: SUM() does not use approx summation anymore since Kahan summation is used [RESOLVED FIXED; assigned to erack]
  •    148184: FORMATTING create a means to represent an integer as an IP Address [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    148434: LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly [CLOSED INVALID; assigned to libreoffice-bugs]
  •    148792: Add currency from Mozambique - MZN [VERIFIED FIXED; assigned to erack]
  •    149428: Formatting of number AFTER the decimal point not saved in .ods [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    150028: Err:502 on formats with absolute seconds and millis [VERIFIED FIXED; assigned to jumbo4444]
  •    152724: FILESAVE FORMATTING Cell custom Format Code with _- (UI visible space width) is not saved correctly [RESOLVED FIXED; assigned to jumbo4444]
  •    153023: NatNum12 number format (spell out): thousand separator should be disabled [RESOLVED FIXED; assigned to jumbo4444]
  •    153993: FORMATTING: ODF do not preserve embedded text and lowercase in scientific format [RESOLVED FIXED; assigned to jumbo4444]
  •    154218: variable and user field input field mishandles datetime when locale uses decimal commas [VERIFIED FIXED; assigned to erack]
  •    154286: Changing value of date fields fails as MM/DD/YYYY format is not recognized as date after last LibreOffice update [CLOSED NOTABUG; assigned to libreoffice-bugs]
  •    156449: Number format: scientific notation do not respect '?' (blank) in exponent [RESOLVED FIXED; assigned to jumbo4444]
  •    158265: Cell Format Date changes cell value in case of high resolution date/time values [RESOLVED FIXED; assigned to erack]
  •    158890: FORMATTING: Custom number format trailing 0 replaced with figure space [RESOLVED FIXED; assigned to jumbo4444]
  •    159621: Highlighting Positve Numbers Libre Office Calc [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    160319: Calc: add constraints on Format Cells - Format Code [RESOLVED WONTFIX; assigned to libreoffice-bugs]

Bug 107575 blocks 4 bugs:

view as bug list

•    107575: [META] Number format bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    103100: [META] Writer table bugs [NEW; assigned to libreoffice-bugs]
    •    113087: [META] Table bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    108252: [META] Cell-related bugs and enhancements (including formatting) [NEW; assigned to libreoffice-bugs]
    •    127204: [META] Formatting bugs and Improvements [NEW; assigned to libreoffice-bugs]

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]