No examples as I did not prepare to make a submission: I came to this site for another reason and decided to make this contribution. From memory since around the start of version 7: Sometimes, and I think more often with many existing characters in a cell, creating cell content and especially editing the existing cell content produces odd results from fragmenting paragraphs*, merging paragraphs, re-arranging pasted paragraphs, losing existing text, to placing my added text in the middle of existing text, and I don't think that is finger trouble! * creating paragraphs when none previously existed, using the existing text, by splitting it into random sections on new lines within the cell, and not necessarily in the sequence it was originally typed, often with bits missing. The above usually occurs when exiting the cell. It does not happen often, but it does mean I need to remember the content of cells, or save frequently, and resort to not saving the current state of the Calc in RAM, but closing it and starting again. Result: sometimes I have lost significant content as I can have many paragraphs in a cell. Mac OS Catalina and Big Sur on a MacBook Pro mid 2015 Retina display model.
Created attachment 174994 [details] Pasted bullet Points I typed a phrase then pasted what was originally bullet points taken from a web page. It arrived (was pasted) as a continuous line of text, the bullets bing replaced by space. I separated the bulleted items by inserting a comma, leaving as a continuous line of text. When I left the cell, it appeared to not respond to left justification, so on entering the cell I found it had re-arranged the text into bulleted formation, without bullet symbols. Examples of other behaviour will be added when I encounter them and remember that I have made this so called error report.
Created attachment 175871 [details] 3 combined screenshots showing odd copy-past behaviour Current Calc build: a529a4f Version 7.1.4.2 Anomalous behaviour has occurred for the last calendar year at least, say 3 to 4 versions of LibreOffice. Today, 22 Oct 2021, I suspect an Intel MacBook Big Sur copy issue: see marked-up screenshots regarding fire safety text I am working with. Quiting, then shutting down my Mac, did not solve the problem, and hand typing also failed!
About two years ago I was unable to save a file using the conventional save to Desktop function on my MacBook, now resolved. Since then I have been unable to copy text from Calc to Apple Mail emails. I can copy from Calc to TextEdit and then copy from Text Edit to an email as a work-around. This re-enforces my idea that some of my copy issues are related to the LibreOffice - macOS interface.
Could you create an example Calc document, attach it to this report and give clear steps on how we could reproduce the problem? In one of the screenshots you talk about pasting to a PDF. Were you pasting into a PDF form. Also, can you still reproduce the problem with LibreOffice 7.4?
MacBook Air 2022 macOS 13.00 with LibreOffice 7.4.2.3 on Silicon Mac: re-experienced this issue of text re-arranging itself in a cell. I did not record this as it happened. I undid my changes and recorded the sequence of changes I made in file "1. Weight - Body Fat Blood Pressure – John". You will see the cell change between my 2 steps. Screen shots highlight the cell in question. The original file was going to be attached for you to work with, forgetting that you don't get it, you only get a copy! When I put the same data in a copy I made, the data was added fault free. Sadly, despite the Edit menu stating I could repeat the undo and redo actions after making the video, I could not. I used the video to retrieve the lost data. This link will give you access, as the video files were too big to upload: https://www.icloud.com/iclouddrive/09ajtIMUsUfxwsO8BeDlR1NHA#Text_re-arranging_demo I hope you can use the original in the cloud link, or possibly download it. In my ignorance, a download will be a copy, and the copy may not be identical to what is in the cloud, so what you download may not be of use. The link is set to view only, not to change. I hope that is good enough. If not, contact me to change the link so that you can change the content of the folder.
(In reply to John from comment #5) > The original file was going to be attached for you to work with, forgetting > that you don't get it, you only get a copy! When I put the same data in a > copy I made, the data was added fault free. I don't understand what you mean by this. Can you just attach the document to Bugzilla? I can't access iCloud Drive as it wants me to sign in.
Created attachment 183385 [details] File that experienced automatic text reshuffling This file has not experienced this problem before to my knowledge. See "weight chart" sheet cell K345. Next upload will be two screenshot to help identify the cell change.
Created attachment 183386 [details] Screenshots of the start of editing Two sets of screenshots are provided, taken from the video I took by undoing my changes and then videoing the changes remembered by the computer of me entering data. This is the first set. The video is too big to upload.
Created attachment 183387 [details] Screenshots of the text re-arranging itself and adding new text This is the second set of screenshots, taken from the video I took by undoing my changes and then videoing the changes remembered by the computer of me entering data. This set shows the self induced changes I was not wanting, and to my surprise adding new text that I did not type on this day. That new text does not exist anymore, possibly because I tried to undo and redo the changes after making the video and it disappeared during that last attempt to recover my data. The Undo / Redo facility lost my data. If it were not for me having the video, the data would have been lost.
(In reply to Buovjaga from comment #6) > (In reply to John from comment #5) > > The original file was going to be attached for you to work with, forgetting > > that you don't get it, you only get a copy! When I put the same data in a > > copy I made, the data was added fault free. > > I don't understand what you mean by this. Can you just attach the document > to Bugzilla? I can't access iCloud Drive as it wants me to sign in. Not knowing exactly how a copy is made, i.e. a perfect bit by bit copy or not, I was not sure that sending a copy to you would in fact be a perfect copy of the original file. The original file has been submitted together with screenshots of the the steps I supposedly did during the editing as recorded by the computer. I sometimes wonder if these rare changes occur due to a 'gremlin' piece of software built deep into the application, and not built into the files created by it, activated at random. The other possibility is due to the age of the file, but this file is less than four years old, and this is the first occurrence of this issue in this file. My other Calc sheets are up to 15 years old, and they suffer more frequently from this and the auto conversion of any "@ text" to a link. Usually the whole paragraph is changed to a link requiring me to do a cut and paste special without formatting. In the previously attached Calc sample the @ text conversion was limited to the adjoining characters.
[Automated Action] NeedInfo-To-Unconfirmed
I forgot to say that in the video the re-arrangement of the text occurred in less than 0.01 seconds after data entry into that cell.
It is possible that typing in the wrong place can occur due to accidental wrist touching of the trackpad. However, my submission clearly indicates new text being added, and in the past I have seen the changes taking place in front of me with no hands touching the computer.
Created attachment 183400 [details] Paragraph Link Creation Example As I mentioned this issue this week, I thought I would give you an example of what occasionally happens. It still does: entering text with an @ symbol can convert the adjacent text or whole paragraph into what appears to be a link that is not text wrapped as intended. This example is from an extensive address list of 100s of entries on each of five sheets within a single Calc file. I think I supplied a cut-down version of this file years ago as I did not want to release the full content for confidentiality reasons.
(In reply to John from comment #14) > Created attachment 183400 [details] > Paragraph Link Creation Example > > As I mentioned this issue this week, I thought I would give you an example > of what occasionally happens. It still does: entering text with an @ symbol > can convert the adjacent text or whole paragraph into what appears to be a > link that is not text wrapped as intended. Thanks. I tried to reproduce the problem by typing into a cell what is shown in the formula row of the screenshot. It only linkified the parts that look like email addresses and not the whole cell contents. Arch Linux 64-bit Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 7.4.3-3 Calc: threaded
This comment occurred on the 31.12.22: Thanks for attempting to reproduce this random issue. Do remember I wrote, "can convert the adjacent text or whole paragraph”. This appears to be pseudo random, in that when it occurs, it repeatedly occurs in that particular cell, so I have to select all the text, and re-past as plain text to get the text not to appear as a link, and hence will wrap within the cell. All-most all my notes are in cells set to wrap the text. That is, when a paragraph appears as a link, it is not wrapped. Pasting plain text over it appears wrapped. This occurred on the 31.12.22: Just went to ’strikethrough’ an email address and the whole cell converted to a single non-wrapped link that cannot be undone. The work-around is to select all text (this makes it non-visible in the ‘input line' while still visible in the cell), cut (brings it back into the input line) and past special as unformatted text. This occurred today, 4.2.23: it behaved! I was able to create text, add two links either side of the word 'and'. The first converted itself to a link. When I added the second link, it converted to a link, and the previously added link converted to text! At least the whole paragraph did not convert to being all highlighted in a non-wrapped form as if it were a single link. The two previous comments were made and emailed in error. Just catching up on my emails resulted in this submission: sorry for the delay.
Just discovered the conversion to plain text was an illusion: What I described occurred again today in the input line. When I leave the cell, both emails appear as links in the cell view. When I return to the cell, the background grey that indicates it is a link disappears, in both the cell and input line, but placing the cursor over the email registers it as a link (click command key to open hyperlink pop-up). They no longer are highlighted as links.