[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #16 from Todd V --- This is confirmed to still be an issue in 7.4.6.2: Version: 7.4.6.2 (x64) / LibreOffice Community Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL Additionally, the other conditional formats of Data Bar, Icon Set, and Date don't appear to be available via macros either - only the Condition type is available. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #15 from QA Administrators --- Dear Fab, 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 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 LibreOļ¬ciant changed: What|Removed |Added Blocks|127592 |127590 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127590 [Bug 127590] [META] Application Programming Interface (API), when all scripted languages are affected https://bugs.documentfoundation.org/show_bug.cgi?id=127592 [Bug 127592] [META] LibreOffice Basic incl."Option Compatible" modules -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 LibreOļ¬ciant changed: What|Removed |Added Blocks|107659 |127592 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107659 [Bug 107659] [META] Macro bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=127592 [Bug 127592] [META] LibreOffice Basic incl."Option Compatible" modules -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||107659 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107659 [Bug 107659] [META] Macro bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #14 from Fab --- Indeed, it really seems that the possibility of instantiating the "com.sun.star.sheet.ColorScale" service or the possibility of instantiating the "com.sun.star.sheet.XColorScaleEntry" object would solve this problem. Or maybe the "createEntry" method, when used with com.sun.star.sheet.ConditionEntryType.COLORSCALE (=1) as first argument, should accept one more argument (optional) that would be the type of the colorscale conditional format (2 or 3 colors). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Buovjaga changed: What|Removed |Added OS|Windows (All) |All CC|todven...@suomi24.fi| Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #13 from Buovjaga --- Well, then this should go to NEW -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #12 from Oliver Brinzing --- (In reply to Buovjaga from comment #11) > If this is to be treated as a documentation issue, maybe try > https://ask.libreoffice.org/ and if that does not help, the developer > mailing list. no, as mentioned above, i think the problem is, that it seems not to be possible to instantiate the "com.sun.star.sheet.ColorScale" service. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Buovjaga changed: What|Removed |Added CC||todven...@suomi24.fi --- Comment #11 from Buovjaga --- If this is to be treated as a documentation issue, maybe try https://ask.libreoffice.org/ and if that does not help, the developer mailing list. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Julien Nabet changed: What|Removed |Added Version|6.1.1.2 release |6.1.0.3 release --- Comment #9 from Julien Nabet --- Version must correspond to the oldest one. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #8 from Fab --- This problem remains with LibreOffice 6.1.1.2... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Fab changed: What|Removed |Added Version|6.1.0.3 release |6.1.1.2 release -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #10 from Fab --- (In reply to Julien Nabet from comment #9) > Version must correspond to the oldest one. Oh, tanks ! I missed that. :) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #7 from Julien Nabet --- (In reply to Fab from comment #6) > I don't know why you have problems with Xray, MRI or this macro. > Maybe try to start with a fresh install of LibreOffice (I mean an empty > profile). The macro works (or at least, I don't have any error message) until I uncomment Xray (or mri) line. I build LO from master sources and profile was clean. But certainly someone may help you anyway. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #6 from Fab --- I don't know why you have problems with Xray, MRI or this macro. Maybe try to start with a fresh install of LibreOffice (I mean an empty profile). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #5 from Julien Nabet --- (In reply to Oliver Brinzing from comment #4) > i use mri instead of xray, https://github.com/hanya/MRI/releases I installed mri, it hangs at the end so had to kill LO. Nevertheless after restarting LO, the module displayed. Then I copy paste the macro and replace the Xray line by Mri NewCF.getByIndex(0) Again: "BASIC runtime error. Sub-procedure or function procedure not defined." -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #4 from Oliver Brinzing --- i use mri instead of xray, https://github.com/hanya/MRI/releases -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #3 from Julien Nabet --- How to install XRay? I gave a try by downloading file from http://berma.pagesperso-orange.fr/index.html when click "Install" button present in the doc. I noticed these logs on console: warn:basic:9094:9094:basic/source/uno/namecont.cxx:916: couldn't open sub storage for library "Standard". Exception: (com.sun.star.io.IOException) { { Message = "/home/julien/lo/libreoffice/package/source/xstor/xstorage.cxx:2381: ", Context = (com.sun.star.uno.XInterface) @0 } } warn:stoc:9094:9094:stoc/source/inspect/introspection.cxx:1636: object of type "com.sun.star.beans.XIntrospectionAccess" lacks XTypeProvider Nevertheless, I gave a try to your macro and had this message in LO: "BASIC runtime error. Sub-procedure or function procedure not defined." -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 --- Comment #2 from Fab --- Reading the "ColorScaleEntries" property from a manually created format was the way I used to see the structure with 2 or 3 items depending on the color scale I created. I spent a lot of time trying to manipulate the service you mentionned, as well as trying to create a "ColorScaleEntry" object directly in order to add it to the sequence "ColorScaleEntries", even if I couldn't be able to find a way to add anything to it... It seems methods or constructors are missing... Or it is me who is missing something... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 119590] Wrong color scale conditional formatting structure with BASIC
https://bugs.documentfoundation.org/show_bug.cgi?id=119590 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #1 from Oliver Brinzing --- Created attachment 144560 --> https://bugs.documentfoundation.org/attachment.cgi?id=144560=edit conditionalformat it is possible to read the "ColorScaleEntries" from a manually created conditional format, see attached file. so i think, you have to fill the "ColorScaleEntries" to make it work. the question is how can this be done? I found a service "ColorScale" but don't know how to instantiate: https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1sheet_1_1ColorScale.html -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs