We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc Calendar Dropdown Menu [closed]

asked 2013-10-14 10:16:58 +0200

asteynberg gravatar image

Hi all,

Id like to find out if I can add a dropdown calendar menu to my Calc spreadsheet? I saw there is a extension for a calender on the Libre repository, but I would prefer it if the menu is fixed in the cell. I've also come across a few Openoffice macros, but my knowledge of macros is poor so Im not sure how to use it.

Thanks in advance!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-11 07:19:33.778762

3 Answers

Sort by » oldest newest most voted

answered 2013-10-14 12:42:58 +0200

JohnSUN gravatar image

updated 2013-10-15 10:07:08 +0200

Do you mean something like that? Rename it to "calendar.ods" after download


edit flag offensive delete link more

answered 2014-05-20 10:13:51 +0200

asteynberg gravatar image

Hi JohnSUN, I've tested this on the latest version of Libre, but the calendar macro does not want to work? The error when I click on the calendar cell is"BASIC runtime error, Object variable not set". Any idea how to fix this?

edit flag offensive delete link more

answered 2013-10-15 08:53:16 +0200

asteynberg gravatar image

Hi JohnSun, when I open the renamed file this is what I see(see attached image).C:\fakepath\calc open.png when i click on the dates I receive this error(see attached image).C:\fakepath\calc error.png

Any ideas? Im running Libreoffice 4.1 Thanks again for your help

edit flag offensive delete link more


Very strange. Under 4.0.3 it works fine. Now I will update the program to try to understand the source of the problem.

JohnSUN gravatar imageJohnSUN ( 2013-10-15 10:06:13 +0200 )edit

Updated office suite to version Yes, you're right - now the macro doesn't work. Sorry. :-(

JohnSUN gravatar imageJohnSUN ( 2013-10-15 16:35:41 +0200 )edit

no problem!though I was doing something wrong,thank you again for your help johnsun!

asteynberg gravatar imageasteynberg ( 2013-10-15 19:05:07 +0200 )edit

Hi JohnSUN,

any idea how I can get the macro to work on my side? should I rollback my Libre version to 4.0.3?

asteynberg gravatar imageasteynberg ( 2013-10-18 09:52:07 +0200 )edit

I don't know what to advise. You can rollback to version 4.0.3. You can wait for the new version - perhaps this bug will be fixed. You can try this extension...

JohnSUN gravatar imageJohnSUN ( 2013-10-18 11:13:05 +0200 )edit

Think I will rollback to version 4.0.3 until the new version comes out with the bug fixed, thanks again for your help JohnSUN

asteynberg gravatar imageasteynberg ( 2013-10-21 07:55:53 +0200 )edit

Oh! Tested macro from calendar.ods in LiO - work nice too!

JohnSUN gravatar imageJohnSUN ( 2013-10-23 18:42:38 +0200 )edit

Question Tools

1 follower


Asked: 2013-10-14 10:16:58 +0200

Seen: 3,737 times

Last updated: Oct 15 '13