CODEWITHSUNDEEP
openoffice.orgopenoffice-calc
BeyelerStudios
BeyelerStudios

Reputation: 4283

Increase/Decrease a field in OpenOffice Calc

I'm trying to count (and sum up) different (physical) items and input those counts in a spreadsheet. Is there a way to increase (or decrease) an integer in a field in OpenOffice Calc? Mouse or keyboard input.

Either a shortcut+macro combination or something along the lines of these (fictive) arrows:

Increase/Decrease Field

i.e. pressing up would increase the field to value 43

In fact I would be happy for any suggestion for an open programme that would digitalize such input and produce some sort of csv or similar output.

Upvotes: 0

Views: 1450

Answers (1)

Axel Richter
Axel Richter

Reputation: 61975

Via View - Toolbars - Form Controls get the toolbar Form Controls visible.

There you have Spin Button control (see tooltips).

Insert this on the sheet by clicking it and pull the size of it with the mouse. Pull it longer than width.

Right click the control and select Control... from the context menu.

On the Data tab set the Linked cell to A3 for example.

Now switch the design mode to off by clicking the corresponding button at the toolbar Form Controls (see tooltips).

enter image description here

Upvotes: 5

Related Questions