Description: A macro is needed to add formatting to cells copied within Calc (because formuli cannot transfer formatting). Usually such a cell can be copied from Calc to Writer. However, if there is a chr(10) or chr(13) line break in the cell the formatting is not copied into Writer. Steps to Reproduce: 1.Run macro in uploaded Calc file. 2.Copy result and paste into Writer table or page. 3. Actual Results: All formatting in pasted cells is lost Expected Results: Formatting should have been copied. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 153777 [details] Calc spreadsheet with macro Demo of chr(10) and chr(13) bug preventing transfer of formatting from Calc to Writer.
Please be more specific what needs to be done to reproduce. Currently I am unable to reproduce using Version: 6.3.1.1 (x64) Build ID: e979878b49a48dab15ebe528f238b88125e32c65 CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded like this: 1. Opened the attachment 153777 [details], accepted macros 2. Switched to sheet "Digest Output" 3. Made sure that Tools->Forms->Design Mode is disabled; clicked "Bold Names and Places" buton; waited and closed final message box. 4. Single-clicked A3 having the following text: > 003 Antiques and Collectables > St Johns Church Hall, Boxmoor, HH where whole first line, "Boxmoor", and "HH" are bold 5. Ctrl+C 6. Switched to Writer; pasted as RTF. It transferred the bold fine.
I'll update LO and report back.
I still have the problem with the file I sent in, when using 6.3.1.1. (I accidentally sent the wrong one.) However, with 6.3.1.1 the simple second attachment works perfectly when pasted as RTF.
Created attachment 153781 [details] Simple macro that shows correct working with 6.3.1.1 This one works on my PC, with 6.3.1.1, so I'll try changing a few things in my working file.
I did the same test as Mike and obtained the same result. Some thing is weird: in Writer the font for the bold part of the second line is Lohit Devanagari instead of Liberation. Version : 7.0.0.0.alpha0+ Build ID : 90c807bfd1fe65e3c94199fd1cd47df711a47d42 Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; Ubuntu_18.04_x86-64 Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Best regards. JBF
tested with Version: 7.0.0.0.alpha0+ Build ID: 95dbfd517240666e5b9a9fd7ac1d47d799235a62 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Tested ctrl+c, ctrl+v and paste as RTF. Formatting is correct, only font of words "Boxmoor, HH" is Lohit Devanagari
Hello Mike, A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
It works in 6.4.3. The cut and paste operations are now very good.