Summary: | Calc 24.2.1.2 on LEAP 15.5 won't put data in cells | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Ron Widell <rrwidell> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | miguelangelrv, rrwidell |
Priority: | medium | ||
Version: | 24.2.1.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=159595 https://bugs.documentfoundation.org/show_bug.cgi?id=160096 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | multiple sheet Excel spreadsheet |
Description
Ron Widell
2024-04-21 16:47:48 UTC
Created attachment 193787 [details]
multiple sheet Excel spreadsheet
Data isn't retained in cells C6:E44, F6:H44, M6:O51, P6:R51 of (at least) the Apr sheet. the earlier shhets seem to work.
Also not that the dollar signs in rows 54-65 are aligned so far left that they are on the border of the left adjacent cell.
The "problem" is in Data Validity. The reason is the (incorrect IMNSHO) patch (and users will keep rejecting it) in tdf#159595. The patch in tdf#159595 now limits the available alternative behaviors of Data Validity (that have been present for decades). There is a request in tdf#160096 (to at least revert it and) to use a different approach (for example, to modify the wording), instead of limiting the alternative behaviors. This is probably another example/dupe of tdf#160096. Maybe better to mark as dup, to get it solved. *** This bug has been marked as a duplicate of bug 160096 *** I agree that the data entry problem described is a duplicate of tdf#160096 however, that doesn't cover the other (less critical) issue of incorrect formatting in rows 54-65. Thanks, ron (In reply to Ron Widell from comment #5) > that doesn't cover the other (less critical) issue of incorrect > formatting in rows 54-65. That would be a different bug (if indeed there is a bug), and so we need a different separate independent report. I would recommend preparing a simpler basic file, containing a cell with the same format. Additionally, a screenshot of that cell containing some numeric value that would show how it is expected to be displayed. If possible, a second screenshot of the same cell with the same content but on a version that shows the unexpected displayed result. The reason to ask for screenshots in addition to a simple basic spreadsheet file is because with attachment 193787 [details] (which is too-complex for the newly-described behavior), I am not noticing the difference between versions. Having screenshots of what should be seen and what is actually seen would help other users to identify and replicate the problem. With such (simple) file, please open a new report, focusing the initial description on that (other) issue. TIA. |