[Libreoffice-bugs] [Bug 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #20 from Mike Kaganski --- I would say, that this is not a bug. UDFs (user-defined functions) should not operate on things like controllers, active sheets, etc; they are expected to take data, digest it, and output data. Relying on other data not directly mentioned in the formula is basically breaking the assumptions ... so indeed, there might be no controller when the function is executed (and the load time is just one example; the document may also be opened in headless configurations, etc). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #19 from Jon A. Miller --- -bug still exists on version: Version: 7.4.1.2 (x64) / LibreOffice Community Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL Edition Windows 10 Pro Version 21H2 Installed on2020-07-12 OS build19044.2006 Experience Windows Feature Experience Pack 120.2212.4180.0 -bug is a regression on version 6.1.4.2 released Dec 2018 -Ref: 123275 marked as dupe -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #18 from Oliver Brinzing --- repro with: Version: 7.4.1.2 (x64) / LibreOffice Community Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: default -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #17 from QA Administrators --- Dear Taka~ TIDA, 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Xisco Faulí changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||4098 -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Xisco Faulí changed: What|Removed |Added Blocks|125077 | Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=125077 [Bug 125077] [META] regressions introduced by row height recalculation on document load -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Xisco Faulí changed: What|Removed |Added Keywords|regression | Version|6.1.0.0.alpha1+ |4.4 all versions --- Comment #16 from Xisco Faulí --- if recalculation on File Load for ODF files is set to Always Recalculate in Tools/Options.../LibreOffice Calc/Formula the problem can also be reproduced in Version: 5.2.0.0.alpha1+ Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; Locale: ca-ES (ca_ES.UTF-8) and Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e thus, this is not a regression per se. 1e55a47e89a9d9d6cf9cb3993484022aaf2c097b just made this problem more visible -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Xisco Faulí changed: What|Removed |Added Blocks||125077 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=125077 [Bug 125077] [META] regressions introduced by row height recalculation on document load -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Oliver Brinzing changed: What|Removed |Added CC||arminlin...@arminlinder.de --- Comment #15 from Oliver Brinzing --- *** Bug 125042 has been marked as a duplicate of this bug. *** -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #14 from Jon A. Miller --- Bug still exists with LO 6.2.3.2 Win10-1809 -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Oliver Brinzing changed: What|Removed |Added CC||john.wayne.corn...@gmail.co ||m --- Comment #13 from Oliver Brinzing --- *** Bug 123764 has been marked as a duplicate of this bug. *** -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Oliver Brinzing changed: What|Removed |Added CC||ekm...@gmail.com --- Comment #12 from Oliver Brinzing --- *** Bug 123275 has been marked as a duplicate of this bug. *** -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Xisco Faulí changed: What|Removed |Added Version|6.1.4.2 release |6.1.0.0.alpha1+ CC||xiscofa...@libreoffice.org -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #11 from Taka~ TIDA --- @ LibreOffice [[ Version: 6.2.0.3 Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: kde5; Locale: ja-JP (ja_JP.UTF-8); UI-Language: en-US Calc: threaded ]] The error-boxes were not appeared. But the macro wasn't evaluated. ((Older version of LibreOffice evaluated recursively, so it showed correct values.)) A sample spread-sheet for Debug; "_DeBug2_price-sample_dollar.ods" can be download from HERE↓ vvv (This doesn't include the macro but call it.) >https://drive.google.com/open?id=1sI1eU3FdMCr9CmCr-zVFsyfLsUEyBENp -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 --- Comment #10 from 千田 --- (In reply to Oliver Brinzing from comment #3) > may related to > > https://bugs.documentfoundation.org/show_bug.cgi?id=122545 > FILEOPEN: Error on creating script provider for Python script from > location=document ? #-- Calcurate 計算式 Iterative References ■ Iterations 反復 Steps 100 Minimum change: 0.001 General Calculations ■ Automatically find column and row labels 行と列のラベルを自動的に検索 Formula 数式 Detailed Calculation Settings 詳細な計算の設定 XX NG XX● Default settings デフォルト設定 ○ Custom (conversion of text to numbers and more): ユーザー定義 ↓ OK ○ Default settings デフォルト設定 ● Custom (conversion of text to numbers and more): ユーザー定義 Recalculation on File Load ファイル読み込み時に再計算 Excel 2007 and newer: Always recalculate 常に再計算する ODF spreadsheet (not saved by LibreOffice): Always recalculate 常に再計算する -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005
--- Comment #9 from 千田 ---
(In reply to Regina Henschel from comment #2)
> Where is your macro located? Inside a document or in "My Macros & Dialogs"
> library 'Standard' or in a different library or somewhere else?
> When is your macro called?
[[
in "My Macros & Dialogs" library 'Standard';
it's called on loading a file which calls macro.
At Version: 6.1.4.2
err:423
次のプロパティまたはメソッドが見つかりません：getCurrentController。
]]
At 6.2.0.2
[My Macros & Dialogs[
error-line:86, err:423
Property or method not found: CurrentController.
error-line:34, err:423
Property or method not found: getCurrentController.
]]
At 6.2.0.2
[file-macro[
error-line:86, err:91
Object variable not set.
]]
((''source
Dim oDoc, oCtrl, oSheet As Object
oDoc = ThisComponent
oCtrl = oDoc.getCurrentController() REM < error line:34
oSheet = oCtrl.ActiveSheet
''~~~ another Function ~
Dim oDoc, oCtrl, oSheet As Object
oSheet = ThisComponent.CurrentController.ActiveSheet REM < error line:86
))
--
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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 raal changed: What|Removed |Added CC||r...@post.cz, ||vasily.melenc...@cib.de Keywords||bibisected, bisected --- Comment #8 from raal --- This seems to have begun at the below commit. Adding Cc: to Vasily Melenchuk ; Could you possibly take a look at this one? Thanks 5d007cfc8733799cf0535eac3e482eb8cae4b908 is the first bad commit commit 5d007cfc8733799cf0535eac3e482eb8cae4b908 Author: Jenkins Build User Date: Fri Jun 8 00:50:11 2018 +0200 source sha:1e55a47e89a9d9d6cf9cb3993484022aaf2c097b author Vasily Melenchuk 2018-04-06 20:19:10 +0300 committer Thorsten Behrens 2018-06-08 00:47:06 +0200 commit 1e55a47e89a9d9d6cf9cb3993484022aaf2c097b (patch) tree3a3372525645775c32721e59ce8c205c8f474ffd parent 2a7f74900fb646235b74d4c9bd4690e44edc3ed4 (diff) tdf#62268: allow row height recalculation on document load -- 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 123005] FILEOPEN: Error on creating getCurrentController().getActiveSheet() for basic script from location=document ?
https://bugs.documentfoundation.org/show_bug.cgi?id=123005 Oliver Brinzing changed: What|Removed |Added Summary|After update on |FILEOPEN: Error on creating |2019/1/26(26th Jan 2019), |getCurrentController().getA |the macro CurrentController |ctiveSheet() for basic |does not exist |script from ||location=document ? OS|Linux (All) |All See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||2545 --- Comment #7 from Oliver Brinzing --- reproducible with Version: 6.1.5.1 (x64) Build-ID: f18954c1ba9116b85c32b6bdbc0188d3e0fd24c7 CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; Gebietsschema: de-DE (de_DE); Calc: group threaded -- 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
