Created attachment 147457 [details] pic of misaligned numbers Issue: UI, FORMATTING In certain cells formatted for Numbers, [Aligned to right], and [Incresed indent] once, the numbers refuse to retain their Increased indentation. This does not apply to all cells. Only some, which seems to happen at random. There's no way in which I've been able to remedy it. I've tried to delete lines, copy other cells, re-format, reapply Alignment and Indentation, but to no avail. This bug appears both in the LibreOffice found in my distro repo (kUbuntu) and the AppImage (LibreOffice-fresh.standard-x86_64.AppImage). ______ Libreoffice, from AppImage: Version: 6.1.3.2 Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk2; Locale: en-GB (en_US.UTF-8); Calc: group threaded ______ Libreoffice, from repo: Version: 6.1.2.1 Build ID: 1:6.1.2-0ubuntu1.1 CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; Locale: en-GB (en_US.UTF-8); Calc: group threaded ______ System info: Operating System: Kubuntu 18.10 KDE Plasma Version: 5.14.4 Qt Version: 5.11.1 KDE Frameworks Version: 5.52.0 Kernel Version: 4.18.0-12-generic OS Type: 64-bit
Thanks for reporting the bug Can you please attach a example of the spreadsheet with the problem Best regards
Created attachment 147511 [details] Spreadsheet affected by bug issue
(In reply to Xavier Van Wijmeersch from comment #1) > Thanks for reporting the bug > Can you please attach a example of the spreadsheet with the problem > > Best regards Attached (though I did delete some text data, but the issue is still there). Notice that the issued doesn't start until Row 595 Column C.
The problem goes a way when uncheck freeze column/rows The original workbook is from excel i think, did have a look in the formatting styles. Maybe some one else can pinpoint the real problem??? this is just info: In your sheet plan_text cell A63 have a #name error (b63b165) ++> B63, and the conditional format from your run_log sheet there are to many entree,s. You can just reduce to 3 entree's
Yes, I believe I did originally start the workbook in Excel (some years back), but since converted to Libreoffice/.ods via Save as > .ods > this is just info: > In your sheet plan_text cell A63 have a #name error (b63b165) ++> B63, and > the conditional format from your run_log sheet there are to many entree,s. > You can just reduce to 3 entree's Thanks! I'll get that fixed, and have clean-up of my conditionals:)
(In reply to mirknorm from comment #5) > Yes, I believe I did originally start the workbook in Excel (some years > back), but since converted to Libreoffice/.ods via Save as > .ods > > > > this is just info: > > In your sheet plan_text cell A63 have a #name error (b63b165) ++> B63, and > > the conditional format from your run_log sheet there are to many entree,s. > > You can just reduce to 3 entree's > > Thanks! I'll get that fixed, and have clean-up of my conditionals:) Closing as RESOLVED NOTABUG then...