Bugzilla – Attachment 79498 Details for
Bug 54854
calc add-in functions are not evaluated as expected
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Python script to be run as a macro to illustrate the issue decrined in the previous comment.
bug54854Doobiedoo.py (text/x-python), 845 bytes, created by
kiaora-paora
on 2013-05-18 13:02:21 UTC
(
hide
)
Description:
Python script to be run as a macro to illustrate the issue decrined in the previous comment.
Filename:
MIME Type:
Creator:
kiaora-paora
Created:
2013-05-18 13:02:21 UTC
Size:
845 bytes
patch
obsolete
># -*- coding: utf-8 -*- >''' >illustrate bug 54854 using the DooBieDoo add-in >''' >import uno > >def bug54854Doobiedoo(): > ctx = uno.getComponentContext() > desktop = ctx.ServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop",ctx) > sheet = desktop.getCurrentComponent().CurrentController.ActiveSheet > > cell = sheet.getCellRangeByName("E5") > cell.setFormula('=DOOBIEMULT(2.5,1.1)') > > cell = sheet.getCellRangeByName("E7") > cell.setFormula('=DOOBIEDIV(7.5,2.5)') > > cell = sheet.getCellRangeByName("E9") > cell.setFormula('=DOOBIECONCAT("Good","Bye")') > > cell = sheet.getCellRangeByName("E11") > cell.setFormula('=DOOBIECONCATOPTIONAL("Een","Twee")') > > cell = sheet.getCellRangeByName("E13") > cell.setFormula('=DOOBIECONCATOPTIONAL("Een","Twee","Drie")') > >g_exportedScripts = bug54854Doobiedoo, > ># EOF
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=79498">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 54854
:
67091
| 79498 |
79505
|
79532
|
79533