https://bugs.documentfoundation.org/show_bug.cgi?id=151211
Bug ID: 151211
Summary: EDITING paste unformatted text, puts everything after
column N in N
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The data was received with Google forms and stored automatically in google
sheets. I downloaded the sheets and try to paste unformatted into Libre.
Everything after Column N gets added to N. This only happens for specific
entries (not sure which/why).
This doesn't happen in either Excel or Google sheets. This is unique to
libreoffice calc.
I can copy the row directly from google sheets or excel and paste it (not
unformatted, just regular ctrl+v) into libre fine.
It has nothing to do with libre's interpretation of "paste unformatted". IE: I
can paste the data into Notepad to remove formatting, then copy and paste
(normal ctrl+v) into libre and the same thing happens.
Here's an example of the problematic text. Simply copy and paste this into
libre calc. It should end at CT, but ends at N. I've anonymized the data, it's
not private/identifying.
7/19/2022 11:31:09 I certify that the foregoing is true, correct,
and complete. And if I am selected I could be asked for medical reports to
confirm my statements. I understand that the accuracy, truthfulness, and
completeness of my answers is important for patient safety. Michael Peter
[email protected] TikTok Student Type 2, Type 3 18-25 USA
Ohio Male 5'9" 170 Not applicable (skip to next question) Around
15% I have taken antibiotics more than 1 year ago I've only taken
antibiotics a few times in my whole life Almost always the same type
Once per day I run and do bodyweight exercises daily. In highschool I ran
XC, Swam and played Lacrosse. I Played D3 2 years ago but quit last year
because it was to much of a time requirement and interfered with school. I
still stay active and like to go on 8 mile runs every week to stay fit.
College Daily or close to daily Excellent Vaginal birth Not sure
Rarely or never Rarely or never Rarely or never No problems I eat lots of
vegetables, fruits, and chicken. I eat sweets such as cake or candy maybe once
a month. Never eat fast food and cook everything myself. I only drink water and
average between half a gallon and a gallon a day (have been doing this for ~4-5
years from highschool). No No No No Yes
Gates Mills 46640 No No No No No No
No No No No No No No No No No
No No Yes No No No None 5-10 Never or very
rarely N/A Under 30 minutes Excellent Rarely No No
No No No No No No Never No No Less
than once a year Never Braces, No issues or work done, Took off braces ~3
years ago. Never any cavities or anything. No problems Excellent
Average Excellent Sometimes No No No No All
healthy White/Caucasian 12/18/2012 I understand.
--
You are receiving this mail because:
You are the assignee for the bug.
