Ask Your Question

pabelmont's profile - activity

2016-02-19 03:59:02 +0100 received badge  Popular Question (source)
2016-02-19 03:59:02 +0100 received badge  Famous Question (source)
2016-02-19 03:59:02 +0100 received badge  Notable Question (source)
2014-01-28 18:25:55 +0100 asked a question Need formula with Dynamic RANGE

I want to sum a column of numbers ONLY down to the current (not the last) row. something like

B{THISROW} = SUM(A1:A{THISROW}).

THUS, IF COLUMN A HAS {10,3,2,5,8,12), THE CONDITIONAL SUM (IN COLUMN B) WOULD BE(10,13,15,20,28,40)

2013-11-13 18:54:00 +0100 received badge  Famous Question (source)
2013-11-13 18:54:00 +0100 received badge  Notable Question (source)
2013-11-13 18:54:00 +0100 received badge  Popular Question (source)
2013-02-09 21:06:27 +0100 asked a question create-forms in base: lefthand choices disappeared, need SUBMIT control

I installed Ubuntu 12.04 yesterday and began to try out LibreOffice BASE, using a pre-existing database object from OpenOffice.

At some stage, while I was creating a new FORM in BASE, I clicked something on the (leftish) bottom which caused the left-hand vertical menu of form-items to disappear.

[1] How do I get them back?

[2] When I have them back, how do I create a SUBMIT button (or the like) so that the new form will not merely accept the typing-in of data for a record but ALSO insert it into the associated TABLE?