Ask Your Question

Boggle's profile - activity

2020-11-17 21:50:20 +0100 received badge  Notable Question (source)
2020-07-21 00:54:58 +0100 received badge  Famous Question (source)
2020-07-20 14:53:38 +0100 received badge  Notable Question (source)
2020-06-20 23:01:59 +0100 received badge  Famous Question (source)
2020-03-15 17:00:44 +0100 received badge  Popular Question (source)
2020-02-13 01:58:47 +0100 received badge  Famous Question (source)
2020-01-20 20:08:18 +0100 commented question [Calc] Insert Decimal two digits from end of number

Anyone have any idea how to do this? Seems quite trivial. I think a feature like "fixed decimal" would achieve this as w

2020-01-20 15:27:33 +0100 received badge  Notable Question (source)
2019-12-26 18:35:17 +0100 received badge  Popular Question (source)
2019-12-26 01:35:06 +0100 received badge  Commentator
2019-12-26 01:33:49 +0100 received badge  Enthusiast
2019-11-16 19:20:26 +0100 received badge  Famous Question (source)
2019-11-14 23:18:25 +0100 marked best answer [Calc] How to reference document name in macro?

LibreCalc

https://pastebin.com/5nuPQ9DT here is my pdf macro.

I wish for it to reference the document name instead of some predetermined, "hard coded" name that is in the macro.

How do I reference the document name here?

2019-11-14 20:14:58 +0100 received badge  Notable Question (source)
2019-11-13 12:05:14 +0100 received badge  Popular Question (source)
2019-11-11 23:14:17 +0100 received badge  Popular Question (source)
2019-11-11 19:09:00 +0100 marked best answer [Calc] AutoInput values valid for any sheet?

LibreCalc

Currently, autoinput remembers values input on the current sheet only. So if I entered a word on Sheet 1, subsequent attempts to enter that word on that sheet would get an AutoInput prompt. I'd like that word to also get an autoinput prompt on OTHER sheets as well.

So if I enter "timecard" on SHEET 1, when I begin typing "timecard" on SHEET 2, I'd like autoinput to give me a prompt.

Is this possible to do?

EDIT: it appears that maybe it's not possible? Since it collects previously used words in that column . That seems very specific and not very useful...what if someone wants that feature in the same row? Anyway, here is the Screenshot from Librecalc guide:

(edit: activated screenshot)

2019-11-11 19:08:46 +0100 received badge  Famous Question (source)
2019-11-11 19:08:12 +0100 marked best answer [Calc] Insert current year into header?

https://i.imgur.com/kb7Fq6a.png

I'm able to select sheet title, and date, but the date is day/month/year. I only want the current year.

Unable to edit that text, since it just erases the entire date.

How can I do this?

2019-11-11 16:00:21 +0100 edited question [Calc] AutoInput values valid for any sheet?

[Calc] AutoInput values valid for any sheet? LibreCalc Currently, autoinput remembers values input on the current sheet

2019-11-10 09:53:06 +0100 received badge  Notable Question (source)
2019-11-09 07:14:52 +0100 received badge  Popular Question (source)
2019-06-15 20:59:43 +0100 received badge  Famous Question (source)
2019-05-28 19:34:39 +0100 received badge  Notable Question (source)
2019-03-22 11:02:54 +0100 marked best answer Prohibit non-numerical characters from being entered into a cell

I'd like to outright prohibit the entry of non-numerical characters into cells (except the . for the decimal).

A conditional format that changes that cell with a non numerical character, to red, would suffice. I tried but was unable to find a conditional format argument that would do this.

2019-03-22 11:02:12 +0100 received badge  Notable Question (source)
2019-03-21 11:59:49 +0100 marked best answer Prevent "delete content" prompt when backspacing?

When I backspace a cell, it give a prompt to "delete content". I just want it to clear the cell by default. Anyway to do this?

I searched the LibreCalc Guide and it didn't mention a way to set a default.

2019-03-21 10:13:11 +0100 received badge  Popular Question (source)
2019-03-21 02:06:51 +0100 asked a question Prevent "delete content" prompt when backspacing?

Prevent "delete content" prompt when backspacing? When I backspace a cell, it give a prompt to "delete content". I just

2019-03-20 23:12:20 +0100 received badge  Notable Question (source)
2019-03-20 14:50:49 +0100 received badge  Popular Question (source)
2019-03-20 13:01:33 +0100 marked best answer Macro to Copy Current Sheet and insert it after current sheet

Then I'd like to create a button out of this. I want it to copy the current active sheet, then insert it after the current active sheet.

Thanks!

2019-03-20 13:01:33 +0100 received badge  Scholar (source)
2019-03-20 13:01:27 +0100 commented answer Macro to Copy Current Sheet and insert it after current sheet

Sorry about that. Thanks for the resources, I'll definitely give them a read. I would like to be able to learn and apply

2019-03-20 12:32:00 +0100 received badge  Notable Question (source)
2019-03-20 09:56:35 +0100 received badge  Popular Question (source)
2019-03-20 03:23:25 +0100 asked a question Macro to Copy Current Sheet and insert it after current sheet

Macro to Copy Current Sheet and insert it after current sheet Then I'd like to create a button out of this. I want it to

2019-03-20 01:15:11 +0100 received badge  Popular Question (source)
2019-03-20 01:12:35 +0100 answered a question Reference "previous sheet"

answer is to use this macro: Function SheetName(Optional nSheet As Long) On Error Goto errhandler If IsMissing(nShe

2019-03-20 01:06:21 +0100 commented question Reference "previous sheet"

Interesting. Well I'll have to find a way to capture that since I may use this on multiple devices. Thanks again for all

2019-03-20 01:04:59 +0100 commented question Reference "previous sheet"

Interesting. Well I'll have to find a way to capture that since I may use this on multiple devices. Thanks again for all

2019-03-20 00:30:59 +0100 commented question Reference "previous sheet"

That worked!!! Thank you so much!!! Where is this macro stored? Is it stored within the LibreCalc document?

2019-03-19 20:24:17 +0100 asked a question Prohibit non-numerical characters from being entered into a cell

Prohibit non-numerical characters from being entered into a cell I'd like to outright prohibit the entry of non-numerica

2019-03-19 20:20:25 +0100 commented question Reference "previous sheet"

Tried inputting that as the formula for cell C33 in January, and got this error: https://i.imgur.com/CMNQ7mW.png If I a

2019-03-19 20:17:52 +0100 commented question Reference "previous sheet"

Tried inputting that as the formula for cell C33 in January, and got this error: https://i.imgur.com/CMNQ7mW.png

2019-03-19 19:59:36 +0100 commented question Reference "previous sheet"

@JohnSUN and Mike, this is what I have for my macro. https://i.imgur.com/62uYuMZ.png and it works!!! One last hiccup.

2019-03-19 19:56:19 +0100 commented question Reference "previous sheet"

@JohnSUN and Mike, this is what I have for my macro. https://i.imgur.com/62uYuMZ.png and it works!!! One last hiccup.

2019-03-19 18:44:54 +0100 commented question Reference "previous sheet"

Now that I dig into it, I see that you're correct regarding the excel function. Sorry for the confusion. Still not reall