[Solved] OpenOffice Calc - Button with SQL

[Rassler]

Hi All,

I would like to need your help for a small topic for you experts

I need a solution, where I need a button in my Calc Sheet, which update cells with value +1

Example to make it more clear:
- I do have a Calc Sheet which has in cells H4 till H42 a number value (sheet can be extented with the amound of rows in future)
- When the button will be pressed I would like to have, that each cell the number value will be updated with Value +1

It would be great, if you can explain the steps to me, how I can make this.


Many Thanks!

[MrProgrammer]

Hi, and welcome to the forum.

I need a solution, where I need a button in my Calc Sheet, which update cells with value +1

[Solved] How do I increase all variables by 1 with a click?
[Solved] Increment/decrement feature for cells
You can assign a recorded macro to a function key or to a toolbar button.

[Tutorial] Favorite Recorded Calc Macros

Open Office Calc - Button with SQL

This topic is in the Calc (spreadsheet) forum. I don't understand why you mention SQL in the topic subject, so I ignored the reference to SQL, which is used with databases.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Villeroy]

Since you mentioned SQL (Calc is NOT a database), the attached database has some numeric columns with random values and a form where you can manipulate any date, time, currency and integer by means of mouse wheel, up/down arrows and clicking on spin buttons.

[Rassler]

Thanks for your answer!

Hi, and welcome to the forum.

I need a solution, where I need a button in my Calc Sheet, which update cells with value +1

[Solved] How do I increase all variables by 1 with a click?
Here it says

Select your target cells (the ones to be incremented) → Edit → Paste Special →
• Selection=Numbers
• Operations=Add
• Shift=Don't
• All options unchecked → OK

But I don't see Selection, Operation etc somewhere

[Rassler]

So, now I got it!

Was my mistake with paste the data in - Sorry!

Thank you very much for your help!

Edit: Post moved from topic 74945 to this one. -- MrProgrammer, forum moderator

[MrProgrammer]

But I don't see Selection, Operation etc somewhere

Before attempting to use Paste Special you must copy 1 to the clipboard as described in the first three sentences of the topic which you quoted.

202311200914.gif (86.03 KiB) Viewed 359 times