https://bugs.documentfoundation.org/show_bug.cgi?id=140580
Colin <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|1 |0 Status|NEEDINFO |UNCONFIRMED --- Comment #10 from Colin <[email protected]> --- (In reply to Buovjaga from comment #9) > Can you explain what is the core issue that you are concerned about here? > That 17:21 changes to a decimal number when pasted to a cell with the > generic number format? > No, I think the original issue was that it changed to a decimal when pasted into what was perceived as a text cell in the middle of a column of cells where that column was specifically formatted as text. My original procedure was to "insert" blank rows into the array and assume that the formats would default to the row preceding those being displaced - although I would have expected the same had it taken format from the first displaced row. I was inserting blanks merely to ensure all range IDs expanded appropriately. Also, I have now moved on to; Version: 7.2.5.2 (x64) / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded and it now produces the text "17:21" as opposed to the decimal. I am (now) also aware that pasting formulaic result "17:21:00" into a "Date" cell doesn't produce a date but a text preceded with an apostrophe "'" and that this is remediated with a regular expression to remove the first character in a CTRL+H operation. Is there a Status "RED HERRING"?🤷♂️ -- You are receiving this mail because: You are the assignee for the bug.
