https://bugs.documentfoundation.org/show_bug.cgi?id=155886
Bug ID: 155886 Summary: Hash marks that indicate "cell too narrow" should expand according to the cell width Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: hoss...@libreoffice.org Created attachment 187951 --> https://bugs.documentfoundation.org/attachment.cgi?id=187951&action=edit XLSX file containing text and number with different cell widths Description: In both LibreOffice and MS Excel, hash marks are used as a replacement, when the area for showing a number is not large enough to contain the number as it should be shown. But LibreOffice always shows 3 hash marks (###) for this purpose. This has a major drawback: no matter how much the needed width is, the placeholder remains the same. Even by implementing tdf#129847, it is not meaningful to place arrows on left, right, or both sides because the use case is different compared to a text, which part of it is visible, and the arrow shows where the extra part of the text is hidden. When there is no visible text, the arrows will be meaningless. On the other hand, increasing the number of hash marks until it fills the cell width is a more meaningful approach to show the cell area, and its lack of enough space. Steps to Reproduce: 1. Open the attachment in LibreOffice Actual Results: LibreOffice always shows 3 hash marks (###). If the area is smaller, Expected Results: Hash marks should expand fill the cell width. For a comparison, you can open the same file in MS Excel. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f1ee5c77fbdc2aa2b6448d056db2929423aa9bc4 CPU threads: 20; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_DE); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.