[Libreoffice-ux-advise] [Bug 141668] Unexpected view change after clicking last line of text visible
https://bugs.documentfoundation.org/show_bug.cgi?id=141668 --- Comment #3 from Telesto --- (In reply to Heiko Tietze from comment #2) > If we do what you recommend nothing would hinder users to select text out of > sight, which makes no sense. > > Me would rather expect a smooth scrolling. Could be attached to the "Smooth > Scrolling" option. It has a meta ticket on its own in bug 98754 and perhaps > this ticket is a duplicate of some other. Would improve the situation a lot.. this likely also connected with bug 81829 -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 81829] Viewport calculations for .uno:PageUp .uno:PageDown scroll movements are not accurate (comment 28)
https://bugs.documentfoundation.org/show_bug.cgi?id=81829 Telesto changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||1668 -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141668] Unexpected view change after clicking last line of text visible
https://bugs.documentfoundation.org/show_bug.cgi?id=141668 Telesto changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=81 ||829 -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 81829] Viewport calculations for .uno:PageUp .uno:PageDown scroll movements are not accurate (comment 28)
https://bugs.documentfoundation.org/show_bug.cgi?id=81829 Telesto changed: What|Removed |Added CC||al20...@gmail.com --- Comment #34 from Telesto --- Adding al20...@gmail.com from bug 105776 too -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 81829] Viewport calculations for .uno:PageUp .uno:PageDown scroll movements are not accurate (comment 28)
https://bugs.documentfoundation.org/show_bug.cgi?id=81829 Telesto changed: What|Removed |Added Status|VERIFIED|UNCONFIRMED Resolution|WONTFIX |--- Ever confirmed|1 |0 --- Comment #33 from Telesto --- I assume VERIFIED WONTFIX being accident? Putting it to UNCONFIRMED (as my bug landed here as duplicate; without the impression this being totally OK) Hope UX taking a look again -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141668] Unexpected view change after clicking last line of text visible
https://bugs.documentfoundation.org/show_bug.cgi?id=141668 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 Blocks||98754 --- Comment #2 from Heiko Tietze --- If we do what you recommend nothing would hinder users to select text out of sight, which makes no sense. Me would rather expect a smooth scrolling. Could be attached to the "Smooth Scrolling" option. It has a meta ticket on its own in bug 98754 and perhaps this ticket is a duplicate of some other. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=98754 [Bug 98754] [META] Smooth scroll in whole LibreOffice suite -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 81829] Viewport calculations for .uno:PageUp .uno:PageDown scroll movements are not accurate (comment 28)
https://bugs.documentfoundation.org/show_bug.cgi?id=81829 V Stuart Foote changed: What|Removed |Added CC||tele...@surfxs.nl --- Comment #32 from V Stuart Foote --- *** Bug 141666 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141666] The page up/page down steps are oddly chosen in Writer
https://bugs.documentfoundation.org/show_bug.cgi?id=141666 V Stuart Foote changed: What|Removed |Added Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED CC||vstuart.fo...@utsa.edu See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||5776 --- Comment #4 from V Stuart Foote --- as in dupe, the pgUp / pgDn movements supplement the cursor Up / Down for scrolling. The .uno:PageUp, .uno:PageDown Viewshell movement of the viewport can't be set fixed at full page increments as it needs to vary by the zoom level of the view--or it is no longer a scrolling action. (bug 105576) So for bug 101211 we've implemented the .uno:GoToStartOfNextPage and .uno:GoToStartOfPrevPage and assigned +/+. The viewport scroll (or with selection) complmenting the Up/Down keys is the greater demand of consistent UI. There is probably some adjustment that could be done to the current .uno:PageUp, .uno:PageDown to viewport positioning glitches like aoo#88716, or bug 141249, or even as here. *** This bug has been marked as a duplicate of bug 81829 *** -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 81829] Viewport calculations for .uno:PageUp .uno:PageDown scroll movements are not accurate (comment 28)
https://bugs.documentfoundation.org/show_bug.cgi?id=81829 V Stuart Foote changed: What|Removed |Added Summary|VIEWING: Can't page down|Viewport calculations for |accurately in "Entire Page" |.uno:PageUp .uno:PageDown |view|scroll movements are not ||accurate (comment 28) -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".
https://bugs.documentfoundation.org/show_bug.cgi?id=141292 --- Comment #30 from steffan.steff...@gmx.net --- (In reply to Mike Kaganski from comment #29) > > The proper way when filling "invoices" is not relying on implicit > general-purpose software rounding rules, but to explicitly define proper > rounding in proper places (=ROUND(A1/B2;2)), or use pre-made templates from > your accountants, with such thigs prepared. And no, trying to implement what > you suggest to make this "special case but not a rare case" is just > misguided. I'd agree that probably the "correct" solution is to use the "ROUND" switch for every cell in the invoice. I can tell you that I use Calc for sending invoices to my customers, and if they check if everything is correct, they would probably just get out the calculator and type in what they see. Not that they would contact me because of 1 Eurocent difference, they might just think that my work is sloppy overall. So actually, for me to make spreadsheets for my invoices without the option "precision as shown" will make the task much more tedious, because instead of setting one option, I'll have to go into the details for every single cell. > > (In reply to steffan.steffner from comment #24) > > And I would agree with comment #23 that > > in order to achieve this (=only show if it makes a difference) there is a > > performance penalty in that you have to do the calculation twice, one time > > with the normal precision (which is about 15 digits) and a second time with > > the decimal accuracy as shown. My best bet would be that this could take > > like 50 milliseconds on an average computer. > > I laughed when read that. You obviously do not realize what tasks > spreadsheets are used for. It's common to have hundreds of thousands of > formulas in a document. Some recalculations may take minutes. What you > suggest is "dear heavy Calc users, please rest more, waiting while your > spreadsheet is recalculating". Before you start thinking to proceed by taking out altogether the option "precision as shown" from Calc, I would like to mention the following: I haven’t seen any post about people being in trouble because they activated “precision as shown”, and then forgot about. As I just tested, for every new document you create, the default setting for this option, which is “precision as shown” *off*, is set again. So, for being in trouble with this option, you would need to make a template, set this option, and then forget about it when you use this template. So, as you can see, I am really defensive now, and as I said, I don’t really need this tooltip anymore, since I am now an expert, at least for this very option, and I do agree that the “double calculation” penalty would matter for heavy users. So, I’d now make the call to make this bug a “WONTFIX” (before other bad things happen). -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".
https://bugs.documentfoundation.org/show_bug.cgi?id=141292 --- Comment #29 from Mike Kaganski --- (In reply to steffan.steffner from comment #27 and comment #28) Your issue is clearly understood, don't worry. But note that using "precision as shown" is generally *not* a correct option. You assume that it would be what your accountants would expect, but this is not necessarily the case: the specific legislation may (and actually does) regulate what to do when imprecise numbers appear in calculations; some may ask usual rounding; some may require rounding to even; some may require truncation. It *actually* happens in practice; and misusing the dangerous and simplistic "precision as shown" as substitute for knowingly following rules that are set at your place at this time is a bad option. I would agree that hiding that option better, and not advertising it in help, or at least adding disclaimers, would be good. The proper way when filling "invoices" is not relying on implicit general-purpose software rounding rules, but to explicitly define proper rounding in proper places (=ROUND(A1/B2;2)), or use pre-made templates from your accountants, with such thigs prepared. And no, trying to implement what you suggest to make this "special case but not a rare case" is just misguided. (In reply to steffan.steffner from comment #24) > And I would agree with comment #23 that > in order to achieve this (=only show if it makes a difference) there is a > performance penalty in that you have to do the calculation twice, one time > with the normal precision (which is about 15 digits) and a second time with > the decimal accuracy as shown. My best bet would be that this could take > like 50 milliseconds on an average computer. I laughed when read that. You obviously do not realize what tasks spreadsheets are used for. It's common to have hundreds of thousands of formulas in a document. Some recalculations may take minutes. What you suggest is "dear heavy Calc users, please rest more, waiting while your spreadsheet is recalculating". -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".
https://bugs.documentfoundation.org/show_bug.cgi?id=141292 --- Comment #28 from steffan.steff...@gmx.net --- I should have given the exact details right from the beginning – so my fault: [calculation below: precision as shown is *off*] SUMME 1 (2020)469,08 € +SUMME 2 (2021) 1.946,96 € +16% Mwst. (von Summe 1) 75,05 € +19% Mwst. (von Summe 2) 369,92 € = Gesamtbetrag 2.861,02 € This is the result when precision as shown is off (default). But the result is not wrong, it is **mathematically more exact**, because in reality the numbers are: in Euro: 469,08 + 1946,96 + 75,0528 + 369,9224 = 2861,0152 Thus, 2861,02 is only 0,0048 away from the exact result, whereas 2861,01 is 0,0052 away from the exact result. The problem thus comes down to: In an invoice, you don’t want the mathematically more exact result, you want results that add up with what is shown ‘on paper’. And if you take out your calculator, and you add up what is shown on paper, you get the result 2861,01. Hope that made it clear. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".
https://bugs.documentfoundation.org/show_bug.cgi?id=141292 --- Comment #27 from steffan.steff...@gmx.net --- (In reply to Heiko Tietze from comment #26) > Eike, what do you think? > > * Highlight/Mark calculated cells with imprecise results (why not show the > correct result in this case?) > * Remove/Hide/Warn for "Precision as shown" > * Small feedback at the statusbar if this option is on > * WF Sorry to be so blunt, you seem not to get it: - The option "Precision as shown" is **off** by default; - My problem was caused by "Precision as shown" being off, which is the default - there are no "incorrect results": there are results that are calculated with a bigger or smaller number of digits; - "precision as shown" thus causes a smaller number of digits to be used, since the usual internally used 15 (?) decimal places are deliberately cut off according to how many decimal places you choose to display in your respective cell of the spreadsheet; - my case (invoice) is a special case, which is nevertheless not a rare case, obviously; - in invoices, you want that the numbers "as displayed" or "on paper" add up, even if the result is mathematically less exact, and this is achieved by deliberately cutting off the decimal places that are usually internally used, but are not shown in the display according to the respective cell formatting you chose; - Removing the option "precision as shown" would cause that Calc is then unusable for invoices; If you read here: https://help.libreoffice.org/7.1/en-US/text/scalc/guide/rounding_numbers.html (at the bottom): To calculate with the rounded off numbers instead of the internal exact values Choose Tools - Options - LibreOffice Calc. Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK. “rounded off numbers” in the above paragraph means: Rounded off according to the formatting of the respective cell (which, obviously, in an invoice is usually 2 decimal places or https://help.libreoffice.org/7.1/de/text/scalc/guide/rounding_numbers.html Mit den angezeigten gerundeten Werten rechnen anstatt mit den internen genauen Werten Wählen Sie Extras - Optionen... - LibreOffice Calc. Wechseln Sie zum Register Berechnen. Markieren Sie Genauigkeit wie angezeigt und beenden Sie den Dialog mit OK. s.o. “angezeigte gerundete Werte” bedeutet ‘wie für die Formatierung der jeweiligen Zelle gewählt’, d.h. in einer Rechnung wird man die Anzeige üblicherweise für alle Zellen auf 2 Nachkommastellen formatieren oder runden (2 Stellen für Eurocent). Damit „Überraschungen“ vermieden werden, schreibt man jetzt Calc vor, dass auch für die interne Berechnung alle Stellen nach diesen 2 Nachkommastellen verworfen werden (=Genauigkeit wie angezeigt) -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141668] Unexpected view change after clicking last line of text visible
https://bugs.documentfoundation.org/show_bug.cgi?id=141668 Telesto changed: What|Removed |Added Version|7.2.0.0.alpha0+ Master |4.4.7.2 release --- Comment #1 from Telesto --- Note the behaviour is depending on amount of toolbars rows/size of the toolbar icons. 3 rows of toolbars at the top creates the 'ideal' view in sample here (but well that's kind of luck; matter of zoomlevel) -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141668] Unexpected view change after clicking last line of text visible
https://bugs.documentfoundation.org/show_bug.cgi?id=141668 Telesto changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141666] The page up/page down steps are oddly chosen in Writer
https://bugs.documentfoundation.org/show_bug.cgi?id=141666 Telesto changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||1668 -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141666] The page up/page down steps are oddly chosen in Writer
https://bugs.documentfoundation.org/show_bug.cgi?id=141666 Telesto changed: What|Removed |Added Version|7.2.0.0.alpha0+ Master |3.5.0 release --- Comment #3 from Telesto --- Also in LibreOffice 3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141666] The page up/page down steps are oddly chosen in Writer
https://bugs.documentfoundation.org/show_bug.cgi?id=141666 Telesto changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 63368] FORMATTING: Images attached to cell get mispositioned when cell above is edited
https://bugs.documentfoundation.org/show_bug.cgi?id=63368 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #31 from Heiko Tietze --- (In reply to Samuel Mehrbrodt (allotropia) from comment #30) > I can reproduce... probably some invalidation issue. No need for input from UX if the principal engineer agrees with the bug. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141566] Implement os/DE theme support in Basic Editor, allow for dark mode when used
https://bugs.documentfoundation.org/show_bug.cgi?id=141566 Heiko Tietze changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #4 from Heiko Tietze --- (In reply to Rafael Lima from comment #3) > ...is the same as the one used in the Background of Writer documents. Please start Math from Calc (Insert > Object > Formula) and revise your comment. -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141292] Calc should display hint "internal calculation is done without rounding".
https://bugs.documentfoundation.org/show_bug.cgi?id=141292 Heiko Tietze changed: What|Removed |Added CC||er...@redhat.com --- Comment #26 from Heiko Tietze --- Eike, what do you think? * Highlight/Mark calculated cells with imprecise results (why not show the correct result in this case?) * Remove/Hide/Warn for "Precision as shown" * Small feedback at the statusbar if this option is on * WF -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 141654] Can't see selected autofilter
https://bugs.documentfoundation.org/show_bug.cgi?id=141654 Heiko Tietze changed: What|Removed |Added Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED --- Comment #4 from Heiko Tietze --- *** This bug has been marked as a duplicate of bug 140955 *** -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
[Libreoffice-ux-advise] [Bug 134802] [ENHANCEMENT] Proposal of a new "Paste Special" dialog box
https://bugs.documentfoundation.org/show_bug.cgi?id=134802 Gabor Kelemen changed: What|Removed |Added CC||j...@curioussymbols.com --- Comment #14 from Gabor Kelemen --- *** Bug 106852 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are on the CC list for the bug. ___ Libreoffice-ux-advise mailing list Libreoffice-ux-advise@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise
