https://bugs.freedesktop.org/show_bug.cgi?id=68441
--- Comment #10 from Owen Genat <owen.ge...@gmail.com> --- (In reply to comment #0) > Consider the following cell format : [<0.05][BLUE]"small";[<0]"negative";@ > it should print "small" for numbers between 0 and 0.05, "negative" for > negative numbers and treat all other data as text. I am not convinced that "treat all other data as text" is an accurate representation. Formats should be respected. LO Calc Number Format Codes page: https://help.libreoffice.org/Common/Number_Format_Codes#Including_Text_in_Number_Format_Codes > To include text in a number format that is applied to a cell that might > contain text, enclose the text by double quotation marks (" "), and then > add an at sign (@). For example, enter "Total for "@ to display "Total > for December". MS Excel Number Format Codes page: http://office.microsoft.com/en-001/excel-help/number-format-codes-HP005198679.aspx > If included, a text section is always the last section in the number format. > Include an at sign (@) in the section where you want to display any text > entered in the cell. If the @ character is omitted from the text section, > text you enter will not be displayed. If you want to always display specific > text characters with the entered text, enclose the additional text in double > quotation marks (" "). For example, "gross receipts for "@ Sounds to me like @ should only be displaying content under either Calc or Excel if it is text. For numbers (e.g., the 42 in the example) either # or 0 would appear to be required. This is going to need a developer to determine. -- 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