Summary: | Applying styles and formatting to tables causes data loss and clear direct formatting inconsistent | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Cyp <cyp561> |
Component: | Writer | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | dgp-mail, telesto |
Priority: | medium | Keywords: | dataLoss |
Version: | 6.1.5.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 103100, 107553 | ||
Attachments: | testcase |
Description
Cyp
2019-05-02 08:13:48 UTC
Also, note that the table is permanently destroyed, unless right-clicking on individual cells one by one and selecting Number Format and changing to Text (and fixing the data in each cell). If selecting the whole table and changing the Number Format to Text, it doesn't have any effect, and the Number Format for all cells remains Currency, and the dollar signs still can't be removed manually. (In reply to Cyp from comment #0) > Steps to Reproduce: > 1. Create a table where some cells contain numbers, using custom paragraph > styles in some cells. In particular, choose a pink and bold paragraph style > for the cell in the 2nd row and column. Thank you for reporting the bug. Please attach such a document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it) Created attachment 151147 [details]
testcase
0. Load testcase.
Wrong number format:
1. Open Styles and Formatting / Table Styles
2. Double-click Currency 3D, then change back to Test Table.
3. See that most cells have changed, and the original data is lost.
4. Select all cells, right-click, choose Number Format, see it's already Text.
5. Try entering 1.000 in a cell, and see it change to $1.00.
0. Then reload testcase to get the data back.
Really weird formatting:
1. Select the 15 cells starting with the "SELECT THIS CELL" cell.
2. Press Ctrl+M to Clear Direct Formatting.
3. Notice 1 bold centred cell and 2 random pink cells.
4. Click on the word "SELECT" (without actually selecting anything).
5. Press Ctrl+M to Clear Direct Formatting again.
6. Notice every second row has a pink cell. The pink cells from before are no longer pink. The "SELECT THESE CELLS" is now bold, with the word "SELECT" pink.
7. Select random cells and Clear Direct Formatting a few times, trying to figure out the pattern.
8. Be really confused.
(In reply to Cyp from comment #3) > Created attachment 151147 [details] > testcase > > 0. Load testcase. > > Wrong number format: > 1. Open Styles and Formatting / Table Styles > 2. Double-click Currency 3D, then change back to Test Table. I can't reproduce it, because I don't have style "Currency 3D" If not Currency 3D, then any other table style except Default Style. It's just more noticeable if it's one of the ones that have Currency in the name, since then it also adds dollar-signs everywhere. (In reply to Cyp from comment #3) > Created attachment 151147 [details] > testcase > > 0. Load testcase. > > Wrong number format: > 1. Open Styles and Formatting / Table Styles > 2. Double-click Currency 3D, then change back to Test Table. > 3. See that most cells have changed, and the original data is lost. > 4. Select all cells, right-click, choose Number Format, see it's already > Text. > 5. Try entering 1.000 in a cell, and see it change to $1.00. > > 0. Then reload testcase to get the data back. > > Really weird formatting: > 1. Select the 15 cells starting with the "SELECT THIS CELL" cell. > 2. Press Ctrl+M to Clear Direct Formatting. > 3. Notice 1 bold centred cell and 2 random pink cells. > 4. Click on the word "SELECT" (without actually selecting anything). > 5. Press Ctrl+M to Clear Direct Formatting again. > 6. Notice every second row has a pink cell. The pink cells from before are > no longer pink. The "SELECT THESE CELLS" is now bold, with the word "SELECT" > pink. > 7. Select random cells and Clear Direct Formatting a few times, trying to > figure out the pattern. > 8. Be really confused. I tried to confirm it: ... 4. (I can confirm) 5. (I can't confirm => 1.000 doesn't change) 3. (I can confirm) 6.(Almoste every cell is pink) 7. (No further changes, if I Clear direct Formatting) So in sum I would say that I can confirm, that something strange is going on => NEW > Really weird formatting:
> 1. Select the 15 cells starting with the "SELECT THIS CELL" cell.
> 2. Press Ctrl+M to Clear Direct Formatting.
> 3. Notice 1 bold centred cell and 2 random pink cells.
> 4. Click on the word "SELECT" (without actually selecting anything).
> 5. Press Ctrl+M to Clear Direct Formatting again.
> 6. Notice every second row has a pink cell. The pink cells from before are
> no longer pink. The "SELECT THESE CELLS" is now bold, with the word "SELECT"
> pink.
> 7. Select random cells and Clear Direct Formatting a few times, trying to
> figure out the pattern.
> 8. Be really confused.
-> Is a regression from 5.3
1. Open Styles and Formatting / Table Styles
2. Double-click Currency 3D, then change back to Test Table.
3. See that most cells have changed, and the original data is lost.
4. Select all cells, right-click, choose Number Format, see it's already Text.
5. Try entering 1.000 in a cell, and see it change to $1.00.
-> Never worked perfectly, but no text replacement in 4.1 (started with 4.2)
@Cyo would you mind to create two new bug reports; as replacement for this one?
Split to bug 133659 and bug 133660. *** This bug has been marked as a duplicate of bug 133659 *** |