Fai la tua domanda

Max Pixel's profile - attività

2018-08-14 16:21:03 +0200 received badge  Domande famose (source)
2018-08-14 16:21:03 +0200 received badge  Domanda notevole (source)
2018-04-11 07:09:12 +0200 received badge  Domande famose (source)
2018-04-11 07:09:12 +0200 received badge  Domanda notevole (source)
2017-12-17 01:17:15 +0200 ha accettato una risposta How to configure PyCharm for authoring macros
  1. Add LibreOffice's included Python libraries to PyCharm as an environment
  2. Open the included Python scripts folder, or a copy of it, in PyCharm
  3. Open any of the .py files

The included .py files are, obviously, error-free, however PyCharm reports the error "unresolved context XSCRIPTCONTEXT"

What steps are necessary in order to configure PyCharm to know the interface of XSCRIPTCONTEXT?

2017-12-14 18:09:36 +0200 received badge  Domande famose (source)
2017-09-20 20:54:49 +0200 received badge  Domande famose (source)
2017-08-25 02:44:14 +0200 received badge  Domanda gettonata (source)
2017-08-23 23:03:55 +0200 ha posto una domanda Add section to Database panel in Base

Add section to Database panel in Base Context: In Base's primary interface, there are four top-level sections which are

2017-06-10 05:46:54 +0200 ha modificato una domanda How to configure PyCharm for authoring macros

How to configure PyCharm for authoring macros Add LibreOffice's included Python libraries to PyCharm as an environment

2017-06-10 05:46:29 +0200 received badge  Entusiasta
2017-06-08 18:08:21 +0200 ha commentato una risposta How to configure PyCharm for authoring macros

Is it necessary for the IDE to actually connect to the framework? I would expect there to by .py files declaring the int

2017-06-08 18:04:58 +0200 received badge  Domanda notevole (source)
2017-06-07 14:49:25 +0200 received badge  Domanda gettonata (source)
2017-06-07 10:04:45 +0200 ha risposto a una domanda How to create Macro JAR from IntelliJ IDEA

The missing step was to set the full package path. I discovered this by comparing the contents of my JAR with the exampl

2017-06-07 04:16:51 +0200 received badge  Domanda gettonata (source)
2017-06-06 17:52:52 +0200 received badge  Domanda notevole (source)
2017-06-06 11:38:10 +0200 ha posto una domanda How to create Macro JAR from IntelliJ IDEA

How to create Macro JAR from IntelliJ IDEA The Macro Documentation mentions these steps: Compile the HelloWorld.j

2017-06-06 11:18:18 +0200 ha commentato una risposta How to create a running total in Base for a Report

In my particular case, I'd very much like to give the LibreOffice API an honest effort, but thanks for sharing the fact

2017-06-06 11:15:31 +0200 ha accettato una risposta How to create a running total in Base for a Report

The Question

Given a Base table that contains a DATE column and a DECIMAL column, how would I accomplish a Report that contains a graph that reflects the accumulation of value (from the DECIMAL column) across time (as defined by the DATE column).

What are all of the pieces necessary, and how would they fit together?
If multiple viable approaches exist, what are the pros/cons?

Context

I'm migrating some calculations from a spreadsheet that they outgrew into Base. I need to figure out how to accomplish a "running total" or "running balance" for a graph on a Report.

For clarity, given the values [5, -2, 3], the graph would show something like

6|       o-->
5| o--\  |
4|    |  |
3|    o--/

My findings so far

OO forums: Problem in Per Row Computation - The gist of this thread is that referencing previous/next fields in SQL is extremely advanced, and you're better off importing the data to a spreadsheet

LO Ask: Can we have calculated fields in LibreOffice Base? - SQL UPDATE and TRIGGER features can be used to make the equivalent of a formula cell

What I haven't seen is anything about macros. From what I understand, macros/scripting are used to make entire enterprise applications on Access and Base, so I suspect that my best path forward might be to make a macro that is fired whenever the report is opened, and which iterates the table in order to populate a backing table that feeds the chart, though I'm not sure if there is a need for special queries or other elements, or if this could be done in memory so that a backing table is not necessary.

2017-06-06 11:15:31 +0200 received badge  Studioso (source)
2017-06-06 11:15:29 +0200 received badge  Sostenitore (source)
2017-06-06 11:15:24 +0200 ha commentato una risposta How to create a running total in Base for a Report

Thanks for confirming that writing macros is the best approach, and for providing those references. If you're able to l

2017-06-06 09:19:34 +0200 received badge  Domanda gettonata (source)
2017-06-06 08:07:55 +0200 ha posto una domanda How to configure PyCharm for authoring macros

How to configure PyCharm for authoring macros Add LibreOffice's included Python libraries to PyCharm as an environment

2017-06-06 07:37:24 +0200 received badge  Studente (source)
2017-06-05 07:36:19 +0200 ha posto una domanda How to create a running total in Base for a Report

How to create a running total in Base for a Report The Question Given a Base table that contains a DATE column and a DE