Well, I tried to search some stuff on the internet, found some related issues but not as I want. I want to use Calc on my Linux machine to get real time stocks information from a DDE link external app, but this app will run through wine. So, I didn't try it yet cause I have to buy a login first to b...

Have you considered a keyboard listener/handler? Yes, but I want to remove some shortcuts(like the navigator hotkey) that enable the users to access other parts of my spreadsheet. Imported keyboard settings for a single document do work. This is something you can't do in the GUI and the GUI can not...

I'm sorry, but there is just an option to save the keyboard shortcuts in a .cfg file or change it for Calc or LIbreOffice.
I can store the menus, context menus, toolbars and events inside my document, but can not store the keyboard shortcuts keys...

But I want to save the .cfg file separated from the current document, and just use the macro to load it when my document is opened.

I don't want to touch the locale, I'm talking about the shortcuts from Tools > Customize... > Keyboard. I want to change them in my Calc file, it's because I have created a SpreadSheet with lots of macros and foms. So, people will use it to insert data on each textbox and unlock some other textboxes...

Tried to find anything in the internet, but no success.
So, I would like to import an existing keyboard config(with all its custom shortcuts) using a macro.
First, is it possible?
If yes, Can someone help me?

Awesome, thank you very much, man!

Hey guys, I'm trying to write a macro that will run after my LibreOffice document is hidden. So, I will run this to hide it. ThisComponent.CurrentController.Frame.ContainerWindow.SetVisible(FALSE) Then, how Can I use something like the code below? IF ThisComponent.CurrentController.Frame.ContainerWi...

Thanks man.

If I know it exactly, the Autosave feature is a Application-level parameter, but it is not a Document-level parameter. (It is not stored in the document.)

Aren't the scrollbars, menu bar and status bar all part of the Application-level? All of them can be turned off when the document is open.

Hi guys, I'm working on an interactive spreadsheet, with a lot of macros, data and buttons... to be short, It's a spreadsheet to act like a program, so the people who will be using it do not need to be familiar with spreadsheet formulas. But I have faced a problem: Due to the size of the spreadsheet...

Oh,, That worked.
Just added your code to run when the event: document is going to be saved is called.
Thank you so much, man!

I tried to call this macro before the Close_Calc macro: sub reset_changes rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object rem ---------------------------------------------------------------------- rem get...

I'm trying to write a macro which will close my Calc without asking me if I want to save it or not after hit the close button. The solution I have found was: Sub Close_Calc() ThisComponent.Close(True) End Sub It closes my document as expected, but only if I use a button or a shape to call it. If I a...

Thanks man, I will take a deep look on it.

No, link me, please.

Done!!! Just changed the variable and Worked!!! LOL

ThisComponent.CurrentController.VerticalScrollBar = false ThisComponent.CurrentController.HorizontalScrollBar = false This code works very well, it's exactly what I needed, Thank you so much. But the print preview doesn't help me, because I want the user to use my spreadsheet, it has a lot of butto...

You can not hide all of the sheet tabs. At least one tab must be shown in the calc app, when a spreadsheet file is open. You can hide all of the other sheets, together with the tabs.

I think you are wrong, since it's possible to hide even the menu bar using macros.

I'm reading this book, but i couldn't find any clue to write the macro. For the SideBar, I just figured out that using the function to record macros gave me the answer: sub Main rem ---------------------------------------------------------------------- rem define variables dim document as object dim...

Is it possible to write a macro to hide the Vertical and Horizontal scroll bars and the Sidebar on Calc? (Yes, I know that it's possible to do that using the menu options and view settings, but I want to do that using a macro, so, it will take effect in all machines I open my document.) Maybe someth...

After some work I figured out what was the problem: My spreadsheet has a lot of shapes, and I did not set the anchor to the page in some of them, also I changed the measurement unit of Calc to mm instead of cm, cause editing like that was causing some shapes to have a different size. Thank you guys ...

Hagar Delest wrote:Once you've saved in ODF, I guess that it shouldn't.

The file was originaly created in .xls format, but I opened it in LibreOffice Calc and started aditing and saving in .ods format, so, I'm not using the Excel file format anymore. My question has to do with the ODF document format.

Yes, it's saved in .ods, but the file was ported from a .xls format, does it matter?

Ok, here We go... First of all, I'm posting this issue here cause I think it's not just a Calc related issue. I have a Spreadsheet which has a lot shapes on it. That's because I have written a lot of macros and to call them I thought would be better to design my spreadsheet like that... It looks ver...

Why not simply save the doc with the amputated sheet? I'm sorry, that's because I was porting my existing code do OpenOffice/LibreOffice. Then I thought it would be possible to achieve this results only by a macro. But your answers helped me a lot, thank you very much, It worked exactly the way I w...

Yes, they will have text boxes and some cells will be avaliable to change.

I'm making a spreadsheet that has push buttons and text fields, It present the data in without showing the Scroll Bars, Menu Bar, Tool Bars and Status Bar. So, It will act like a data app viewer, that's why I want to create a macro to disable the scroll. In Excel VBA, I was using this macro: Sub blo...

Is it possible to create a macro to avoid someone to scroll down on my spreadsheet?