Description: Clone and apply to multiple empty cells works if all are to follow are same sign. Converting an existing long column of temperature values results in #°C becoming # (where # is just a number) or #oC (degree symbol is not superscript), justification is either to the left or right when original is centered. If original has a different way of entry then ouutput of conversion can be in error as attachment shows. Steps to Reproduce: 1. 2. 3.in attachment Actual Results: in attachment Expected Results: in attachment Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: StartModule [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 178466 [details] example and system data and text explanation Research on presenting Degree(s) in CALC Temperature 01 Raw Data typed daily using various means to format as Degree Centigrade. Temperature 02 Copy to use in next column to preserve original. Temperature 03 Remove degrees C using alt0176 to define degrees C. Errors a result of how I defined degree symbol Temperature 04 All now as decimal number Temperature 05 As Decimal Number Temperature 06 Shows what I wanted to see without hard work! That is without having to enter number, then enter zero (0) then C then reverse back to hover over zero (0) and make it superscript. Temperature 07 Having corrected cell format expected it follow on into next cells - DON'T ASSUME. Temperature 08 and Temperature 09 Accept that need two values to increment/decrement Temperature 10 Being really lazy why do I have to add colour? Temperature 11 Clone an existing negative and apply on a cell by cell basis. Temperature 12°C Clone and apply to multiple empty cells works if all are to follow are same sign. Included on the spreadsheet are two screen shots addressing how I added to User-defined the correct formats for the cells to be default for positive and red for negative values. Is the result of the research "a bug" or just an example of someone being lazy? A kinder thought "Entering a positive value 'Default' acceptable. Entering a negative 'Defaults to Red' would be nice." Thinking I had solved problem returned to source document and discovered my solution does not work on the existing data base. Refer to CALC Columns Y and Z Row 347 through to Row 369 of DegreesEnhance.ods. Entering the values given in Column Y results in various values in Column Z. The only correct values in Column Z are Z348 & Z369. Note neither of these occur in prior cells. Why Z355 through 361 are correctly formatted in the centre of the column while Z348 & Z369 are formatted to the right and the remainder are formatted to the left I am at a loss. It would appear the only solution I have is to return to my data base format the cells in a new column correctly and then transpose 365 values. Unless of course you know of a better way.
Your cell formatting in Z345 is wrong. It should be #"°C";[RED]-#"°C". Compare with currency formatting. This bug tracker is not an help desk. Please ask for help on https://ask.libreoffice.org Closing as INVALID. Best regards. JBF