https://bugs.documentfoundation.org/show_bug.cgi?id=106832
Bug ID: 106832
Summary: FORMATTING - Pasting plain text changes cell values
that can be reformatted (numbers, dates, etc), no way
to paste plain raw text
Product: LibreOffice
Version: 5.3.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This is similar to bug 103000.
Whenever you paste a block of plain text (such as tab-separated values),
Libreoffice will always clear the formatting of the destination cells and
reformat the text pasted in as General formatting, so anything that looks like
a number, time, or date gets rewritten. This includes misidentifying exponent
signs, so if you pasted in hex values like 0E00, it treats it as 0.
In Microsoft Excel, you can set the formatting of cells to Text before pasting,
and it will not modify the cells. But you can't do that in Libreoffice.
If Libreoffice were to honor the previous formatting of cells to Text, it could
avoid the issue with cells changing.
Steps to Reproduce:
1. Copy some tabular plain text onto the clipboard
2. Set the destination cell range to be formatted as Text
2. Paste into LibreOffice Calc
Actual Results:
Text is rewritten using General formatting rules (things that look like
numbers, times, and dates are changed), and existing formatting within cells
that specifies Text is overwritten.
Expected Results:
It should preserve formatting, including Text format.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
