https://bugs.documentfoundation.org/show_bug.cgi?id=152984
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW Blocks| |102593 Version|7.4.1.2 release |6.1.0.3 release --- Comment #3 from Stéphane Guillou (stragu) <[email protected]> --- I can reproduce in LO 7.6 for the formatting, but not the merged cells (can you be more specific about which merged cells are lost?) Steps: 1. Open this public Google Sheets template: https://docs.google.com/spreadsheets/d/1R-JMH4PqpbDmTbZqq6qKtMU69P-v1xa94pvD2v5spnc/edit 2. Ctrl + A, Ctrl + C to copy all cells 3. In LO Calc, paste Results: No cell formatting at all makes it across, as it is plain text that is pasted. Formulas and sparklines are also lost. More info: Pasting into Gnumeric 1.12.46 does the same: only plain text. (Note that it _looks_ like it keeps the formatting of negative numbers in F26 and F30, but that's just Gnumeric's default negative number formatting.) Two workarounds: 1) save the Google Sheet as ODS or XLSX, open in LO to copy from there. Main remaining issue would be sparklines (I haven't checked the formulas' validity). 2) paste into Writer, then from Writer into Calc. From: https://ask.libreoffice.org/t/support-formatted-paste-from-google-sheets/86358/8 Tested with: Firefox 108.0.2 (64-bit) and Chromium 109.0.5414.74 (Official Build) snap (64-bit) Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 197e5f81213d14fdcbff40edf73385ecd4cd9815 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Same in: Version: 6.1.0.3 Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; Locale: en-AU (en_AU.UTF-8); Calc: group threaded Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=102593 [Bug 102593] [META] Paste bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
