[Libreoffice-bugs] [Bug 154852] CELL() function does not update after worksheet rename
https://bugs.documentfoundation.org/show_bug.cgi?id=154852 kenjfzh...@163.com changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEW |RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] CELL() function does not update after worksheet rename
https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #9 from kenjfzh...@163.com ---
(In reply to Eike Rathke from comment #6)
> (In reply to Eike Rathke from comment #3)
> > For this to work, the formula cell containing CELL() would have to listen at
> > a sheet rename event. Which currently isn't broadcasted as a data change at
> > all, and also shouldn't in general except for CELL() and probably
> > INDIRECT().
> >
> > The reference appears updated because it refers only to the sheet number and
> > when being viewed that is resolved to the current name.
>
> Hi, Eike, the cell() function is what I needed.
> I use 'CELL("address",S1!$B$2)' in MS office, and it works fine, but it not
> work right in libreoffice.
Hi, Eike, thanks for your info, and it works.
I just understood your message after the workaround explanation from ady.
Thank you so much.
Have a nice day!
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143200] Crash: Assertion failing when pasting a cell to a large-height range
https://bugs.documentfoundation.org/show_bug.cgi?id=143200 Commit Notification changed: What|Removed |Added Whiteboard||target:7.6.0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154876] FORMCONTROLS: Radio button reference value (on) not passed exported to PDF
https://bugs.documentfoundation.org/show_bug.cgi?id=154876 --- Comment #1 from Steve --- This is on Win10 21H2. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154876] New: FORMCONTROLS: Radio button reference value (on) not passed exported to PDF
https://bugs.documentfoundation.org/show_bug.cgi?id=154876 Bug ID: 154876 Summary: FORMCONTROLS: Radio button reference value (on) not passed exported to PDF Product: LibreOffice Version: 7.5.2.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Writer Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: st...@nyhof.id.au This problem is new since LibreOffice 7.1.8.1, where things worked just fine. To reproduce: 1. Create a radio button group in a Writer document. 2. Set a button's 'Data' tab 'Reference value (on)' to '5'. 3. Export As PDF (with 'Create PDF Form' ticked). 4. Open the resulting PDF in Acrobat. 5. Right-click the radio button, select 'Properties'. 6. Click the 'Options' tab. 7. Note that the 'Radio Button Choice' field is set to '0'. It should be '5'. If the identical steps are taken in Writer 7.1.8.1, the value is exported properly. I also tested 7.4.6 and it exhibited the problem too. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] CELL() function does not update after worksheet rename
https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #8 from kenjfzh...@163.com ---
(In reply to ady from comment #7)
> (In reply to Eike Rathke from comment #3)
> > For this to work, the formula cell containing CELL() would have to listen at
> > a sheet rename event. Which currently isn't broadcasted as a data change at
> > all, and also shouldn't in general except for CELL() and probably
> > INDIRECT().
>
>
> * FWIW (OT), INFO() doesn't even react to recalculation (e.g. INFO("recalc")
> when going from Automatic to Manual is not updated by recalc hard).
>
> * FWIW, Google Sheets works in the same way as LO (i.e. CELL() doesn't
> listen at sheet rename event).
>
>
>
> (In reply to kenjfzhong from comment #5)
> > formula := =CELL("address",S3.$B$2)
> > result := "$S2.$B$2"
>
>
> Simple workaround:
> 1. In $Sheet2.$A$1, use the (volatile) function =NOW()
> 2. Wherever you want, use =CELL("address",$Sheet2.$A$1)
> 3. Rename the worksheet Sheet2 to whatever else you want.
>
> Result: since you have autocalculate ON, when you rename the worksheet the
> volatile function NOW() gets updated, and so the dependent CELL() function
> will get updated too.
Ah! thanks for your workaround, it works!
Thank you so much!
Have a good day!
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 38194] Style indicator in document margin
https://bugs.documentfoundation.org/show_bug.cgi?id=38194 --- Comment #53 from Jim Raykowski --- (In reply to Eyal Rozenberg from comment #51) > Nice work! Thanks! > * The diagonal stripes pattern is too "bold" IMHO. I'd consider decreasing > its strength, e.g. by a transparency like effect, i.e. stripe color = eps * > original color + (1 - eps) * black. I agree. Is what is shown in the second demo better for you? > * Repeating my question about controlling the color palette > * Will it be possible to highlight only _some_ of the styles? Noted for future enhancements. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 38194] Style indicator in document margin
https://bugs.documentfoundation.org/show_bug.cgi?id=38194 --- Comment #52 from Jim Raykowski --- Created attachment 186749 --> https://bugs.documentfoundation.org/attachment.cgi?id=186749=edit Demo of border, hatch pattern, and feature name changes Attached is a demo of changes made to the patch to: - show no border around DF and CS - make the hatch line color less dark - increase the hatch line spacing - use 'Spotlight' in place of 'Highlight' Also shown is placement of the UNO control used to show character directed formatting. The patch does not include an icon for the UNO or add it to any toolbar or menu. Design team assistance please. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154875] "Use slide background" area fill keeps coming back in sidebar, transparency slider gone
https://bugs.documentfoundation.org/show_bug.cgi?id=154875 Aron Budea changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC||aron.bu...@gmail.com --- Comment #1 from Aron Budea --- Confirmed using LO 7.6.0.0.alpha0+ (60bce1af8aab2115d603781193bb659b35d1aedb) / Ubuntu. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154861] scalc crash on long scrolling (PageDown) ; Skia/Vulkan / Extremely high RAM consumption
https://bugs.documentfoundation.org/show_bug.cgi?id=154861 a_san...@mail.ru changed: What|Removed |Added Summary|scalc crash on long |scalc crash on long |scrolling (PageDown) ; |scrolling (PageDown) ; |Skia/Vulkan |Skia/Vulkan / Extremely ||high RAM consumption -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154861] scalc crash on long scrolling (PageDown) ; Skia/Vulkan
https://bugs.documentfoundation.org/show_bug.cgi?id=154861 --- Comment #6 from a_san...@mail.ru --- When scrolling, memory consumption increases greatly. It can be seen in the task manager. After a while, free memory runs out and scalc closes or hangs. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] CELL() function does not update after worksheet rename
https://bugs.documentfoundation.org/show_bug.cgi?id=154852 ady changed: What|Removed |Added Version|7.5.1.2 release |Inherited From OOo -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] CELL() function does not update after worksheet rename
https://bugs.documentfoundation.org/show_bug.cgi?id=154852 ady changed: What|Removed |Added Summary|The cell formula does not |CELL() function does not |reflect the updated result |update after worksheet ||rename -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154861] scalc crash on long scrolling (PageDown) ; Skia/Vulkan
https://bugs.documentfoundation.org/show_bug.cgi?id=154861 --- Comment #5 from a_san...@mail.ru --- It reproduce on 7.5.3.1 / 7.5.2.2 / 7.4.6.2 / 7.3.7.2 / 7.3.5.2 / 7.3.1.3 / 7.3.0.3 / 7.3.0.1 / 7.3.0.0 a1 x64 The profile is always new. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] The cell formula does not reflect the updated result
https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #7 from ady ---
(In reply to Eike Rathke from comment #3)
> For this to work, the formula cell containing CELL() would have to listen at
> a sheet rename event. Which currently isn't broadcasted as a data change at
> all, and also shouldn't in general except for CELL() and probably INDIRECT().
* FWIW (OT), INFO() doesn't even react to recalculation (e.g. INFO("recalc")
when going from Automatic to Manual is not updated by recalc hard).
* FWIW, Google Sheets works in the same way as LO (i.e. CELL() doesn't listen
at sheet rename event).
(In reply to kenjfzhong from comment #5)
> formula := =CELL("address",S3.$B$2)
> result := "$S2.$B$2"
Simple workaround:
1. In $Sheet2.$A$1, use the (volatile) function =NOW()
2. Wherever you want, use =CELL("address",$Sheet2.$A$1)
3. Rename the worksheet Sheet2 to whatever else you want.
Result: since you have autocalculate ON, when you rename the worksheet the
volatile function NOW() gets updated, and so the dependent CELL() function will
get updated too.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154865] Enhancement: Eliminate duplicate Page settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154865 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154550] add icon for Edit Index Entry
https://bugs.documentfoundation.org/show_bug.cgi?id=154550 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154822] "Repeat header" table's option causes in incorrect "Select table" selection
https://bugs.documentfoundation.org/show_bug.cgi?id=154822 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154865] Enhancement: Eliminate duplicate Page settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154865 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154822] "Repeat header" table's option causes in incorrect "Select table" selection
https://bugs.documentfoundation.org/show_bug.cgi?id=154822 --- Comment #6 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154714] Auto capital should not be applicable to a single letter inside quotations
https://bugs.documentfoundation.org/show_bug.cgi?id=154714 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154714] Auto capital should not be applicable to a single letter inside quotations
https://bugs.documentfoundation.org/show_bug.cgi?id=154714 --- Comment #7 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147326] UI: "augmented reality" hovering mode (immediate display of underlying formulas etc.)
https://bugs.documentfoundation.org/show_bug.cgi?id=147326 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147326] UI: "augmented reality" hovering mode (immediate display of underlying formulas etc.)
https://bugs.documentfoundation.org/show_bug.cgi?id=147326 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147333] Sheet Styles in Calc (Page style)
https://bugs.documentfoundation.org/show_bug.cgi?id=147333 QA Administrators changed: What|Removed |Added Resolution|--- |INSUFFICIENTDATA Status|NEEDINFO|RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147333] Sheet Styles in Calc (Page style)
https://bugs.documentfoundation.org/show_bug.cgi?id=147333 --- Comment #3 from QA Administrators --- Dear ppae, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146389] charts in xlsx lost data opening in Libreoffice
https://bugs.documentfoundation.org/show_bug.cgi?id=146389 QA Administrators changed: What|Removed |Added Resolution|--- |INSUFFICIENTDATA Status|NEEDINFO|RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146389] charts in xlsx lost data opening in Libreoffice
https://bugs.documentfoundation.org/show_bug.cgi?id=146389 --- Comment #8 from QA Administrators --- Dear Vikas, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 145149] Unable to open spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=145149 --- Comment #5 from QA Administrators --- Dear Richard BARRAS, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 137272] Superscripted font is cut off and line spacing increased when smaller block quoted text has footnote or endnote in it, due to use of one font size for all footnotes in
https://bugs.documentfoundation.org/show_bug.cgi?id=137272 --- Comment #13 from QA Administrators --- Dear TH, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 98451] SVG: Transform scale works wrong on stroke, if Skia is enabled
https://bugs.documentfoundation.org/show_bug.cgi?id=98451 --- Comment #14 from QA Administrators --- Dear Regina Henschel, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 90139] EDITING: Cursor can disappear when cancelling Insert Shapes or Text Box when cursor in comment
https://bugs.documentfoundation.org/show_bug.cgi?id=90139 --- Comment #11 from QA Administrators --- Dear Gordo, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141014] RTL footnotes that are added to ms-word files appear mirrorred in ms-word
https://bugs.documentfoundation.org/show_bug.cgi?id=141014 --- Comment #13 from QA Administrators --- Dear Yotam Benshalom, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 140685] Changes in gutter position are not applied immediately but need reload
https://bugs.documentfoundation.org/show_bug.cgi?id=140685 --- Comment #3 from QA Administrators --- Dear Regina Henschel, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141143] Extra paragraph is inserted after dragging an image
https://bugs.documentfoundation.org/show_bug.cgi?id=141143 --- Comment #8 from QA Administrators --- Dear GAIDO Gilles, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 139637] Certain animations not functioning in Impress; previews end abruptly.
https://bugs.documentfoundation.org/show_bug.cgi?id=139637 --- Comment #4 from QA Administrators --- Dear Vijayendra Acharya, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126970] calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zerro.
https://bugs.documentfoundation.org/show_bug.cgi?id=126970 --- Comment #8 from QA Administrators --- Dear Oleksandr, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 118167] FILESAVE XLSX VBA-Project and Microsoft Excel Objects look different after export
https://bugs.documentfoundation.org/show_bug.cgi?id=118167 --- Comment #13 from QA Administrators --- Dear Gabor Kelemen, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 94660] ORDERING with Unicode order is not respected (sort dialogue and autofilter)
https://bugs.documentfoundation.org/show_bug.cgi?id=94660 Robert Lacroix changed: What|Removed |Added Severity|minor |normal -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 94660] ORDERING with Unicode order is not respected (sort dialogue and autofilter)
https://bugs.documentfoundation.org/show_bug.cgi?id=94660 --- Comment #5 from Robert Lacroix --- There is a bug here, but it's not what the OP thinks it is. The bug is: autofilter overwrites the sort range's descriptor. The OP wants the natural sort order, but that's not available through autofilter. So we sort the range with options and then add Autofilter. The problem is that Autofilter, when actually applied, overwrites the sort order option set in the sort range's descriptor. 1) Open a new Calc document and enter the OP's data into a column of cells along with a heading row of "data", but we scramble the data a bit to confirm that the sort is happening. Our cell contents are: data aaa2004 aaa_2006 aaa_2005 2) Select the range including the heading and sort it with options: 2a) Select the range including the title 2b) Choose Data menu > Sort... 2c) Choose Sort dialog Options tab 2d) Check "Range includes column labels" 2e) Check "Enable natural sort" 2f) Click OK The data is now sorted as the OP wants. Our cell contents are: data aaa2004 aaa_2005 aaa_2006 3) With the range still selected, choose Data menu > Autofilter Autofilter sees that the range has a column heading set by the sort range's descriptor and does not ask whether to use the first row as a heading. This is good. The range's heading cell now acquires the Autofilter dropdown menu button, but nothing will happen to the data until the Autofilter option is exercised, which we will do in step 5. 4) With the range still selected, confirm that sort options are still set. 2a) Choose Data menu > Sort... 2b) Choose Sort dialog Options tab 2c) See that the column labels and natural sort options are still checked 2d) Click Cancel 5) Sort the range using the Autofilter's dropdown menu button in the heading. 5a) Click the downward pointing triangle in the heading cell 5b) Click Sort Ascending Notice that the data is now sorted as the OP's complains, not the natural order. 6) With the heading row still selected, verify sort options once again. 6a) Choose Data menu > Sort... 6b) Choose Sort dialog Options tab 6c) See that the column label is still checked but the natural sort is now unchecked. 2d) Click Cancel Step 6 shows that the Autofilter sorting action overwrites the sort descriptor. The Sort Ascending and Sort Descending UI buttons and corresponding menu options are even more egregious, wiping out the entire sort descriptor including the column heading. Is this by design? I think not. As far as the default sort order, I find no fault in LO Calc's choice. Unicode Technical Standard #10 UNICODE COLLATION ALGORITHM https://www.unicode.org/reports/tr10/ declares as the basic principle: "The position of characters in the Unicode code charts does not specify their sort order." The meaning of "Unicode order" is thus utterly ambiguous because code points collate in different orders for different languages. However, taking the cue of "unix ls" as the OP's desired sort order, the "Enable natural sort" option should be selected by the OP. The default sort order used by LO is in fact the start of the Unicode code set, where the first 127 characters copies the 7-bit ASCII code: punctuation precedes digits which precedes alphabetic characters. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141623] Qt5 refresh problem when starting LO start center and cairo (text) rendering ennabled
https://bugs.documentfoundation.org/show_bug.cgi?id=141623 --- Comment #11 from samuelweaver --- It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/3f204ca2fed7614e1e12180af5ce5bfd88249eb7/https://drift-hunters.io -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154591] I edit excel files and then save as 97-2003 Format and later when I open it backup it is completely empty. Frustrating to say the least
https://bugs.documentfoundation.org/show_bug.cgi?id=154591 John changed: What|Removed |Added Summary|crashes |I edit excel files and then ||save as 97-2003 Format and ||later when I open it backup ||it is completely empty. ||Frustrating to say the ||least Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #2 from John --- I ran in safe mode for awhile and it still happens. Completely deleted LibrOffice from PC and re-loaded 7.4.6.2 It still happens. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] The cell formula does not reflect the updated result
https://bugs.documentfoundation.org/show_bug.cgi?id=154852 kenjfzh...@163.com changed: What|Removed |Added Version|Inherited From OOo |7.5.1.2 release -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] The cell formula does not reflect the updated result
https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #6 from kenjfzh...@163.com ---
(In reply to Eike Rathke from comment #3)
> For this to work, the formula cell containing CELL() would have to listen at
> a sheet rename event. Which currently isn't broadcasted as a data change at
> all, and also shouldn't in general except for CELL() and probably INDIRECT().
>
> The reference appears updated because it refers only to the sheet number and
> when being viewed that is resolved to the current name.
Hi, Eike, the cell() function is what I needed.
I use 'CELL("address",S1!$B$2)' in MS office, and it works fine, but it not
work right in libreoffice.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] The cell formula does not reflect the updated result
https://bugs.documentfoundation.org/show_bug.cgi?id=154852
--- Comment #5 from kenjfzh...@163.com ---
(In reply to ady from comment #2)
> There is one detail that should be noted: The formula in the formula bar
> gets updated instantly without the need to force recalculate, so there is no
> problem there.
>
> The CELL() function is considered volatile, depending on its arguments.
I tried to reset below formula again
,and I also checked the Data> Calculate> AutoCalculate is on
,and I confirmed that formula result is not be recalculated again.
formula := =CELL("address",S3.$B$2)
result := "$S2.$B$2"
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] The cell formula does not reflect the updated result
https://bugs.documentfoundation.org/show_bug.cgi?id=154852 --- Comment #4 from kenjfzh...@163.com --- (In reply to ady from comment #1) > Just use the keyboard, either [F9] on the specific cell, or > [CTRL]+[SHIFT]+[F9]. > > These are in menu Data > Calculate. > > Unless someone could demonstrate that this was not happening with the CELL() > function before (I have not checked), then this would probably end up being > NAB. Hi, ady, Thanks for your tips. What the cell formula does in my case, is to check the sheet name automatically, this is a trick I've used in MS office for a long time, and I would be very grateful for this approach in libreoffice. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154865] Enhancement: Eliminate duplicate Page settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154865 --- Comment #3 from Don Matschull --- (In reply to Stéphane Guillou (stragu) from comment #1) > I could see that but the issue disappeared after I reset my user profile. > You can do that by using Help > Restart in Safe Mode and using both options > in "Reset to factory settings". (But keep in mind that you will lose any > user customisation.) > > However, it would be interesting to find steps that would make the issue > reappear. > Do you know how it started? > Please also paste here the information copied from Help > About LibreOffice. I restarted in Safe Mode which eliminated the duplicate page settings. I don't know when or what happen to cause the duplicate. I've attached an image of my About LibreOffice screen. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154865] Enhancement: Eliminate duplicate Page settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154865 --- Comment #2 from Don Matschull --- Created attachment 186748 --> https://bugs.documentfoundation.org/attachment.cgi?id=186748=edit About LibreOffice screen -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154874] Crash in LibreOffice Writer when typing real fast
https://bugs.documentfoundation.org/show_bug.cgi?id=154874 Stéphane Guillou (stragu) changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||stephane.guillou@libreoffic ||e.org --- Comment #1 from Stéphane Guillou (stragu) --- Please share your version information copied from Help > About LibreOffice. Thank you! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154861] scalc crash on long scrolling (PageDown) ; Skia/Vulkan
https://bugs.documentfoundation.org/show_bug.cgi?id=154861 Stéphane Guillou (stragu) changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||stephane.guillou@libreoffic ||e.org -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154865] Enhancement: Eliminate duplicate Page settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154865 Stéphane Guillou (stragu) changed: What|Removed |Added OS|Windows (All) |All CC||stephane.guillou@libreoffic ||e.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Stéphane Guillou (stragu) --- I could see that but the issue disappeared after I reset my user profile. You can do that by using Help > Restart in Safe Mode and using both options in "Reset to factory settings". (But keep in mind that you will lose any user customisation.) However, it would be interesting to find steps that would make the issue reappear. Do you know how it started? Please also paste here the information copied from Help > About LibreOffice. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154865] Enhancement: Eliminate duplicate Page settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154865 m.a.riosv changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154830] Fileopen takes too long to open an existing small file.
https://bugs.documentfoundation.org/show_bug.cgi?id=154830 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #7 from m.a.riosv --- No delay Version: 7.5.3.1 (X86_64) / LibreOffice Community Build ID: d29ee673721b12c92b3de9b9663473211414f0db CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Maybe some network printer installed, not available. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154867] Enhancement Eliminate unnecessary Object settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154867 Stéphane Guillou (stragu) changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED CC||stephane.guillou@libreoffic ||e.org --- Comment #3 from Stéphane Guillou (stragu) --- On top of what Regina pointed out, the sections related to text are relevant to text written in the shape (as explained in bug 154866), so they should stay visible if the user wants to change settings before writing text. However, while testing, I noticed other issues and reported bug 154870 and bug 154875. Closing this one as "not a bug". -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 107580] [META] Area content panel of the Properties deck/tab of the sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=107580 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||154875 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=154875 [Bug 154875] "Use slide background" area fill keeps coming back in sidebar, transparency slider gone -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151188] Area-Fill color in Sidebar is not selected on click on the 1st element
https://bugs.documentfoundation.org/show_bug.cgi?id=151188 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||4875 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154875] New: "Use slide background" area fill keeps coming back in sidebar, transparency slider gone
https://bugs.documentfoundation.org/show_bug.cgi?id=154875 Bug ID: 154875 Summary: "Use slide background" area fill keeps coming back in sidebar, transparency slider gone Product: LibreOffice Version: 7.4.4.2 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Keywords: bibisected, bisected, regression Severity: normal Priority: medium Component: LibreOffice Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: stephane.guil...@libreoffice.org CC: samuel.mehrbr...@allotropia.de Blocks: 107580 Steps to reproduce: 1. Open Draw or Writer 2. Insert a shape 3. Set area fill to "Use Slide Background" in sidebar 4. Set it back to "Color" Result: sidebar's transparency slider is gone. Clicking out of the shape and selecting it again makes the setting go back to "Use Slide Background", even though Color is still active on canvas. In: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Bibisected with linux-64-7.4 repo to first bad commit 478fd06265ded7669db2ff092db37513de528270 which points to core commit 8f0d52d122024d1ed0bd5f59d36e3ade5b7b5629 which is a cherrypick of: commit 490c2fc6080aa652b9b31385517aaf536f5bbd57 author Samuel MehrbrodtThu Nov 03 10:56:47 2022 +0100 committer Samuel MehrbrodtThu Nov 03 14:22:42 2022 +0100 tdf#151174 Hide transparency widgets when not needed Reviewed-on: https://gerrit.libreoffice.org/c/core/+/142221 Samuel, can you please have a look? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107580 [Bug 107580] [META] Area content panel of the Properties deck/tab of the sidebar -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154820] Pasting a cell from Excel changes the default cell style
https://bugs.documentfoundation.org/show_bug.cgi?id=154820 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |NEW --- Comment #1 from m.a.riosv --- Reproducible Version: 7.5.3.1 (X86_64) / LibreOffice Community Build ID: d29ee673721b12c92b3de9b9663473211414f0db CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 96c4c0fcffc4f0a1f5a49be576646d15d613228e CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154717] Drop one note and revise the other in the "Refer using" section of Cross-references
https://bugs.documentfoundation.org/show_bug.cgi?id=154717 sdc.bla...@youmail.dk changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |sdc.bla...@youmail.dk |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154874] New: Crash in LibreOffice Writer when typing real fast
https://bugs.documentfoundation.org/show_bug.cgi?id=154874 Bug ID: 154874 Summary: Crash in LibreOffice Writer when typing real fast Product: LibreOffice Version: unspecified Hardware: IA64 (Itanium) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Writer Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: gdehuff...@gmail.com Description: 1) I am not using the HTML editor. 2) I had annoying crashes with a 600+Kb LibreOffice Writer document but, it wasn't too frequent so I lived with it for years. 3) Then it became very annoying so I split the document into two ~ 300Kb documents to see if that would eliminate the problem - it didn't help and, if anything, it happened sometimes only a few minutes apart and at least once a day which was a lot worse than before the split. 4) After several totally unacceptably frequent occurrences where recovery didn't pick up what had been typed in a very short interval, it finally dawned on me that the crashes were happening when I typed very fast on a word or a short sequence of words whose letters were configured on the keyboard in such a way that I could type them much faster than most words. 5) in the two days since I've slowed my typing down, I haven't had a single crash. that is a big improvement. In case it helps, I am running Windows 10 Pro (64 bit)'s latest update on a very fast 8 core Intel i7-10875H processor in a Dell XPS 1700, laptop with a 9700Bios that stays upgraded when Dell releases a new update, 16MB Cache, 32GB (2x16G) DDR4-293MHZ Ram with NVIDIA graphics (GeForce RTX 2060 6GB GDDr6 with Max Q) Gil DeHuff Steps to Reproduce: 1.the crashes were happening when I typed very fast on a word or a short sequence of words whose letters were configured on the keyboard in such a way that I could type them much faster than most words. 2. 3. Actual Results: crash Expected Results: no crash Reproducible: Always User Profile Reset: No Additional Info: not sure about Itanium64 hardware or version # but it is the latest update. It is automatically updated by Microsoft early in their release schedule. This is what I do know for certain about my system: In case it helps, I am running Windows 10 Pro (64 bit)'s latest update on a very fast 8 core Intel i7-10875H processor in a Dell XPS 1700, laptop with a 9700Bios that stays upgraded when Dell releases a new update, 16MB Cache, 32GB (2x16G) DDR4-293MHZ Ram with NVIDIA graphics (GeForce RTX 2060 6GB GDDr6 with Max Q) Don't see any need to reset my user profile since it doesn't happen unless I type too fast for the I/O channels -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143571] leftover coloured selection rectangle remains after particular undo/redo sequence related to table insertion
https://bugs.documentfoundation.org/show_bug.cgi?id=143571 Stéphane Guillou (stragu) changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=12 | |0678| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 117780] Blue textbox background when pasting sheets from clipboard using templates
https://bugs.documentfoundation.org/show_bug.cgi?id=117780 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||0678 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154852] The cell formula does not reflect the updated result
https://bugs.documentfoundation.org/show_bug.cgi?id=154852 Eike Rathke changed: What|Removed |Added CC||er...@redhat.com Hardware|x86-64 (AMD64) |All Version|7.5.1.2 release |Inherited From OOo Ever confirmed|0 |1 OS|Windows (All) |All Status|UNCONFIRMED |NEW --- Comment #3 from Eike Rathke --- For this to work, the formula cell containing CELL() would have to listen at a sheet rename event. Which currently isn't broadcasted as a data change at all, and also shouldn't in general except for CELL() and probably INDIRECT(). The reference appears updated because it refers only to the sheet number and when being viewed that is resolved to the current name. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141817] Blue square after undo table in Impress
https://bugs.documentfoundation.org/show_bug.cgi?id=141817 Stéphane Guillou (stragu) changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=12 | |0678| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 120678] Blue image background after undo/redo of a slide paste
https://bugs.documentfoundation.org/show_bug.cgi?id=120678 Stéphane Guillou (stragu) changed: What|Removed |Added See Also|https://bugs.documentfounda |https://bugs.documentfounda |tion.org/show_bug.cgi?id=14 |tion.org/show_bug.cgi?id=11 |1817, |7780 |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=14 | |3571| --- Comment #6 from Stéphane Guillou (stragu) --- Still repro in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 140522] Using Keypad Entry Fills Many Pages With The Selected Number
https://bugs.documentfoundation.org/show_bug.cgi?id=140522 --- Comment #7 from miguel --- What fixed the error for me was installing a new version of KeyScrambler protection software. I found on the KeyScrambler forums that the repeating numbers issue was due to a bug in the KeyScrambler software. QFX pointed me to an updated version; I installed; and the bug went away. Thankfully. I too had to use OpenOffice. Most of the time I use OpenOffice, due to other issues with LibreOffice. I use Libreoffice occasionally, if I have some issue with a Microsoft document (latest MS versions). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 103394] Can't undo impress background change from sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=103394 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org Blocks||112602 Summary|Can't undo impress |Can't undo impress |background color change |background change from ||sidebar --- Comment #7 from Stéphane Guillou (stragu) --- Still repro in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=112602 [Bug 112602] [META] Slide Layouts content panel of the Properties deck/tab of the sidebar -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 112602] [META] Slide Layouts content panel of the Properties deck/tab of the sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=112602 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||103394 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103394 [Bug 103394] Can't undo impress background change from sidebar -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154867] Enhancement Eliminate unnecessary Object settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154867 --- Comment #2 from Don Matschull --- (In reply to Regina Henschel from comment #1) > The "Cap style" is not only used for the ends of a line but for dashes and > dots as well. So even closed shapes need it for the case their outline is > dashed. Thank you. I had not seen that information anywhere before. I now see where this can be useful and should be available. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 141817] Blue square after undo table in Impress
https://bugs.documentfoundation.org/show_bug.cgi?id=141817 Stéphane Guillou (stragu) changed: What|Removed |Added Resolution|WORKSFORME |DUPLICATE --- Comment #6 from Stéphane Guillou (stragu) --- Rectangle colour is the selection colour of the desktop environment. (In reply to Telesto from comment #5) > No repro (and no active memory if the STR is lacking something) > Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community > Build ID: 05366b8e6683363688de8708a3d88cf144c7a2bf > CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win > Locale: nl-NL (nl_NL); UI: nl-NL > Calc: CL Build includes the commit that fixed bug 112067. *** This bug has been marked as a duplicate of bug 112067 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 112067] EDITING: A residual colored rectangle appears on all slides after a specific undo/redo table operation
https://bugs.documentfoundation.org/show_bug.cgi?id=112067 --- Comment #8 from Stéphane Guillou (stragu) --- *** Bug 141817 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 120678] Blue image background after undo/redo of a slide paste
https://bugs.documentfoundation.org/show_bug.cgi?id=120678 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||9799 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 117780] Blue textbox background when pasting sheets from clipboard using templates
https://bugs.documentfoundation.org/show_bug.cgi?id=117780 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||9799 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 119799] Table becomes blue if it's pasted 2 times in a row
https://bugs.documentfoundation.org/show_bug.cgi?id=119799 Stéphane Guillou (stragu) changed: What|Removed |Added Blocks||102593 CC||stephane.guillou@libreoffic ||e.org See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||7780, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||0678 Version|4.1 all versions|Inherited From OOo --- Comment #4 from Stéphane Guillou (stragu) --- Still repro in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Already in OOo 3.3, so inherited. Very similar to bug 117780. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=102593 [Bug 102593] [META] Paste bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 102593] [META] Paste bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=102593 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||119799 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=119799 [Bug 119799] Table becomes blue if it's pasted 2 times in a row -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 112067] EDITING: A residual colored rectangle appears on all slides after a specific undo/redo table operation
https://bugs.documentfoundation.org/show_bug.cgi?id=112067 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||3571 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 105948] [META] Undo/Redo bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=105948 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||143571 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=143571 [Bug 143571] leftover coloured selection rectangle remains after particular undo/redo sequence related to table insertion -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143571] leftover coloured selection rectangle remains after particular undo/redo sequence related to table insertion
https://bugs.documentfoundation.org/show_bug.cgi?id=143571 Stéphane Guillou (stragu) changed: What|Removed |Added CC||mark...@gmail.com, ||stephane.guillou@libreoffic ||e.org Priority|medium |low Blocks||100366, 105948 Version|7.3.0.0 alpha0+ |7.0.6.2 release Severity|normal |minor Summary|Blue square after |leftover coloured selection |particular undo/redo|rectangle remains after |sequence related to table |particular undo/redo |insertion |sequence related to table ||insertion See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||2067 --- Comment #6 from Stéphane Guillou (stragu) --- This is very similar to the resolved bug 112067. The colour of the rectangle depends on the selection colour of your desktop environment, it's orange for me on Ubuntu 20.04 with GNOME 3.36.8. It is persistent when switching slides. A file reload makes it disappear. Still reproducible in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Also in 7.0. Started with core commit f3f7cc53efda828af8897fa45fa2a8f18cf3b48b which was a fix for crash bug 136956. Not marking as regression as it was crashing on first Ctrl + Z previously, but copying Mark in just in case he has ideas. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=100366 [Bug 100366] [META] Impress/Draw table bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=105948 [Bug 105948] [META] Undo/Redo bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 100366] [META] Impress/Draw table bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=100366 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||143571 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=143571 [Bug 143571] leftover coloured selection rectangle remains after particular undo/redo sequence related to table insertion -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 48534] EDITING: No footnotes possible in frames including figure captions
https://bugs.documentfoundation.org/show_bug.cgi?id=48534 --- Comment #18 from john.m.ast...@verizon.net --- This bug is still present in as of 2023! Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 20; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded The structure of my document requires me to use captions for photographs, but I also need to footnote the sources of the photographs. I've done hours of work until I encountered this problem. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154873] The Random Number Generator dialog should allow the user to inform the number of rows and columns to be generated
https://bugs.documentfoundation.org/show_bug.cgi?id=154873 Eike Rathke changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #1 from Eike Rathke --- Shift+Ctrl+T A1:AX1 Enter 50x1 range gets selected ;-) But yeah.. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154745] Basic Dialogues: Runtime Appearance differs from Editor (spin buttons, dropdown list) on Linux
https://bugs.documentfoundation.org/show_bug.cgi?id=154745 --- Comment #5 from Kai Struck --- Thanks for testing. It worked ok with LO 4.4.7.2 on Lubuntu. This is when I created these extensions: https://extensions.libreoffice.org/en/extensions/show/change-multiple-images-in-writer-pictool https://extensions.libreoffice.org/en/extensions/show/chorddiagrams https://extensions.libreoffice.org/en/extensions/show/chordtransposer and a lot more of dialogues for this project: http://struckkai.blogspot.de/2015/04/libreofficesongbookarchitect.html All these are nowadays only usable on Windows and broken on Linux (although they look ok in the Editor on the Linux Versions!!!) So I'm asking for a solution to make the dialogues appear the same as they are constucted in the Editor. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 117780] Blue textbox background when pasting sheets from clipboard using templates
https://bugs.documentfoundation.org/show_bug.cgi?id=117780 --- Comment #5 from Stéphane Guillou (stragu) --- Created attachment 186747 --> https://bugs.documentfoundation.org/attachment.cgi?id=186747=edit test file using Classy Red template Still reproducible in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded As the "Classy Red" template is not available anymore, here's a blank presentation that uses it, to test. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154871] ROUNDDOWN returns invalid results when working with larger numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=154871 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 125577] EDITING: Impress: Background image turns to solid blue when editing Master Slide
https://bugs.documentfoundation.org/show_bug.cgi?id=125577 --- Comment #9 from Stéphane Guillou (stragu) --- Reproduced with recent master build: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154871] ROUNDDOWN returns invalid results when working with larger numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=154871 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |DUPLICATE OS|Windows (All) |All --- Comment #1 from Eike Rathke --- > A4 should be 28147497671265 Should be 28147497671265.2 > B4 should be 2814749767126 Should be 2814749767126.2 Anyway, fixed with bug 154792. *** This bug has been marked as a duplicate of bug 154792 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 60814] Colors of shapes change after copy+paste from one drawing to another
https://bugs.documentfoundation.org/show_bug.cgi?id=60814 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org --- Comment #18 from Stéphane Guillou (stragu) --- (In reply to Clemens Eisserer from comment #3) > @Joel: Thats why I added the video. instead of complex textual description, > its easily understandable what I did and what happend watching the video. But now the video is not on YouTube anymore. And in general, videos are less accessible than text. Copying and pasting blue and yellow rectangles from attachment 74776 into a new document, I can still reproduce in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Outline (for both) and fill (for the blue rectangles) change. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154873] New: The Random Number Generator dialog should allow the user to inform the number of rows and columns to be generated
https://bugs.documentfoundation.org/show_bug.cgi?id=154873 Bug ID: 154873 Summary: The Random Number Generator dialog should allow the user to inform the number of rows and columns to be generated Product: LibreOffice Version: 7.6.0.0 alpha0+ Master Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rafael.palma.l...@gmail.com Calc's Random Number Generator (accessible via Sheet - Fill Cells - Fill Random Number) allows to generate random values that will be applied to the selected cell range. This means that you need to manually select the range where the numbers will be placed. The problem with this is when you want to create many random numbers at once, for instance 10,000 rows by 50 columns. It's a really bad experience to select such enormous range manually. Instead, we should allow the user to enter how many columns and rows to generate from a starting selected cell. This would be similar to what Excel does (not exactly, but similar). See attachment 186746 from bug 154872 for a comparison between Calc and Excel RNG's. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147326] UI: "augmented reality" hovering mode (immediate display of underlying formulas etc.)
https://bugs.documentfoundation.org/show_bug.cgi?id=147326 --- Comment #3 from Robert Lacroix --- The visual cortex is insanely faster at recognizing patterns than the conscious mind. To the user it feels like a video game. Blinkenlights empowers the user to see the spreadsheet more efficiently. > Let's start with a use case. A user wants to verify that a pattern of cell references occurs in formulas consistently across a group of cells, and that certain formulas in the group differ in a specific way. This is useful where frequent copying/pasting of cells can introduce mistakes, and when transposing may produce unexpected results. This is somewhat trivial for small spreadsheets, but is time-consuming and error-prone for larger spreadsheets. For very large sheets, it's better to unconditionally copy and paste a desired repeating formula pattern into the range, because that's faster and more reliable than visual inspection. Best of course would be to use protected cells, but that's not always desirable or feasible. Range formulas can be another solution, but they're not the easiest objects to work with and in my experience most people never use them. For a simple example, a column contains relative references forming a running calculation like a cumulative sum, and the first row contains a different formula pattern or a constant to initialize the calculation. The user wants to ensure that the relative formula in every rows is the same except the first row. With status quo, the user must go to each cell to see its formula. This displays a black-and-white cell formula in the input line, which the user must read and interpret. More visual feedback is provided by pressing F2 which adds coloured outlines to cell references and colours the corresponding references of the in-cell formula (but not the input line), at the cost of adding two more keystrokes for each cell examined. This is better but imperfect, however, since some outlines may be hidden by the in-cell editor, particularly when the in-cell formula covers multiple cells, and it adds the risk of inadvertently changing a formula. Simply colouring cell references in the input line the same as the in-cell editor would improve regular F2 edit mode, and that's essentially modification 3. The new hovering mode allows the user to scan the pointer down the column and watch as the pattern of coloured cell outlines follows the pointer down, remaining the same or momentarily jumping to a different shape or colour layout. This is extremely fast by virtue of relying on the user's inate ability to see disturbances in a pattern, much faster than using the higher-level brain functions of reading and understanding formulas. This basically automates the keystrokes of the manual F2 process but also protects the cells. The user validates the first formula in a group by inspection, then swipes the pointer through the range to see that other formulas use the same pattern. The fine motor control required of the user to swipe the mouse over the cells of interest can even be eliminated, if LO highlights the block of adjacent cells that share the same relative formula as the cell under the pointer. I realize as well that this will be fast, the user may want the page to scroll automatically when approaching the visible edge of the cells currently displayed. However, that's not part of this proof-of-concept. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 107738] [META] Section bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=107738 Bug 107738 depends on bug 130199, which changed state. Bug 130199 Summary: Confirm deletion of hidden sections https://bugs.documentfoundation.org/show_bug.cgi?id=130199 What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154872] Missing distributions in Calc's Random Number Generator
https://bugs.documentfoundation.org/show_bug.cgi?id=154872 Rafael Lima changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||1526 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 131526] Random number generator Option no duplicates
https://bugs.documentfoundation.org/show_bug.cgi?id=131526 Rafael Lima changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||4872 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154872] New: Missing distributions in Calc's Random Number Generator
https://bugs.documentfoundation.org/show_bug.cgi?id=154872 Bug ID: 154872 Summary: Missing distributions in Calc's Random Number Generator Product: LibreOffice Version: 7.6.0.0 alpha0+ Master Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rafael.palma.l...@gmail.com Created attachment 186746 --> https://bugs.documentfoundation.org/attachment.cgi?id=186746=edit Comparison between Calc and Excel RNG's Calc has a good Random Number Generator (RNG), however it lacks 3 options that are offered by Excel's RNG: 1) Poisson distribution 2) Patterned 3) Discrete distribution (a.k.a custom distribution) Distributions (1) and (3) are very relevant in universitites when teaching Discrete Simulation and Stochastic processes. So I would like to propose the implementation of these distributions to make Calc a better choice to teach these subjects. See attached screenshots comparing the features offered by Calc and Excel. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154871] New: ROUNDDOWN returns invalid results when working with larger numbers
https://bugs.documentfoundation.org/show_bug.cgi?id=154871 Bug ID: 154871 Summary: ROUNDDOWN returns invalid results when working with larger numbers Product: LibreOffice Version: 7.4.5.1 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: brianjheis...@gmail.com Example I: A1 =28147497671265.2 A2 =ROUNDDOWN(A1,-2) A3 =ROUNDDOWN(A1,0) A4 =ROUNDDOWN(A1,2) The result in A2 should be 28147497671200 but it is instead 28147497671300. The result in A3 should be 28147497671265 but it is instead 28147497671300. The result in A4 should be 28147497671265 but it is instead 28147497671300. Example II: B1 =2814749767126.2 B2 =ROUNDDOWN(($B$1),-2) B3 =ROUNDDOWN(($B$1),0) B4 =ROUNDDOWN(($B$1),2) The result in B2 should be 2814749767100 and it is. The result in B3 should be 2814749767126 but it is instead 2814749767130. The result in B4 should be 2814749767126 but it is instead 2814749767130. I may be wrong but I suspect some kind of disconnect between Calc's IEEE 754 Double and the mechanics of the ROUNDDOWN function because as I experiment with different values, closing in on operands requiring no more than 32-bits for representation sees this problem fade away. IEEE 754 Double should give us 15 digits (and sometimes, 16 digits) of precision in the significand. Version: 7.4.5.1 (x64) / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154870] New: Line cap style label greyed out in sidebar even though still functional and applicable
https://bugs.documentfoundation.org/show_bug.cgi?id=154870 Bug ID: 154870 Summary: Line cap style label greyed out in sidebar even though still functional and applicable Product: LibreOffice Version: 7.0.0.3 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Keywords: implementationError Severity: minor Priority: low Component: LibreOffice Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: stephane.guil...@libreoffice.org CC: caol...@redhat.com Blocks: 105752 Steps to reproduce: 1. Open Draw or Writer 2. Draw a rectangle 3. See sidebar: Line > Cap style is set to "Flat" by default, the "Cap style" string's font is black. 4. Double click on shape to enter text edit mode 5. Click out on canvas, select the shape again Result: "Cap style" is greyed out but the field is still functional (for example, change the line style to dashed, the width to the highest value, and change the cap style to see that it does apply). Expected: Text should remain black. Version: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Caolán, this started in 7.0 when the setting got exposed in the sidebar with 4f6d95ead1286748810e937c7672de08b8b39a38. Could you please have a look? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=105752 [Bug 105752] [META] Line content panel of the Properties deck/tab of the sidebar -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 105752] [META] Line content panel of the Properties deck/tab of the sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=105752 Stéphane Guillou (stragu) changed: What|Removed |Added Depends on||154870 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=154870 [Bug 154870] Line cap style label greyed out in sidebar even though still functional and applicable -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92283] UI: property sidebar is not up to substituting the "line and fill toolbar" with respect to line width
https://bugs.documentfoundation.org/show_bug.cgi?id=92283 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org --- Comment #8 from Stéphane Guillou (stragu) --- Points 1 and 2 still apply in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b06f35de68a555b85bceb5fc29d1a5f426f4bb7 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded I agree that, when editing shapes in Draw, having less options than in Writer when using the default UI is unexpected. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154866] Enhancement: Eliminate unnecessary Line settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154866 Stéphane Guillou (stragu) changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #3 from Stéphane Guillou (stragu) --- Thanks for the reply, Don. I will mark as "not a bug", but let us know if you feel there is still something to fix here. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154867] Enhancement Eliminate unnecessary Object settings in Properties deck of Sidebar
https://bugs.documentfoundation.org/show_bug.cgi?id=154867 Regina Henschel changed: What|Removed |Added CC||rb.hensc...@t-online.de --- Comment #1 from Regina Henschel --- The "Cap style" is not only used for the ends of a line but for dashes and dots as well. So even closed shapes need it for the case their outline is dashed. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 154831] Replace string is empty
https://bugs.documentfoundation.org/show_bug.cgi?id=154831 maison changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
