[Libreoffice-bugs] [Bug 132266] New: Interactive-type macros

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132266

            Bug ID: 132266
           Summary: Interactive-type macros
           Product: LibreOffice
           Version: 6.3.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: framework
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: r.a.scarfe at gmail.com

Description:
Conda and jupyter are integral parts of Python's ascendancy in data science,
and neither are python-specific tools.

I have a proposal in two parts:

* Add a core option for macros in Calc "Tools" -> "Macros" -> "Interactive" ->
"Python" that launches the bundled python repl and automatically includes the
local variable "document" as web browsers consoles do. When I exit the REPL I
should get an option to save my session as a macro.
* Add an extension that adds a jupyter kernel from a conda environment
installed outside libreoffice installation. There are graphical tools to manage
this such as Continuum Analytics' Anaconda Navigator. There are many jupyter
kernels available: https://github.com/jupyter/jupyter/wiki/Jupyter-kernels. I
wouldn't expect a first implementation to provide libreoffice bindings for any
of these externally managed kernels.

This feature request represents is intended to document the minimum level of
support I would need as a dabbler in order to make LibreOffice a first option
for exploratory data science instead of opening up a jupyter notebook.

Steps to Reproduce:
Open up "Tools" -> "Macros" -> "Organise Macros" -> "Python..."

Actual Results:
As someone with a deep level of familiarity with the python REPL as a
calculator that's easy to jump into I fail to find anywhere to start writing
python commands and get confused as to why it seems so hard to start a new
macro.

Expected Results:
I can follow my nose and get to a REPL, then save my session as a macro after
I'm done.


Reproducible: Always


User Profile Reset: No



Additional Info:
I love LibreOffice but I am yet to use it as part of my daily workflow. Python
has no obvious GUI user story for beginners but being bundled with LibreOffice
means that it should be celebrated by the python community, whereas instead
it's complex and not idiomatic to ask a beginner to write "Hello World!".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200420/ef4f06be/attachment.htm>