Merge sheets, copy formats but not formulas

Keyboard macros or custom scripts

Merge sheets, copy formats but not formulas

Postby MistaX32 » Fri Apr 08, 2016 4:11 pm

 Edit: Split from Merge sheets of spreadsheet documents because questions are not allowed in the Code Snippets forum 
Thank you so much for this! This is very helpful!

I realize this is an old post but I hope I can still get through.

I intend to use this for work to compile information from different sources.
I have half-decent knowledge on java programming and very basic c++. When I look to edit these macros using "basic" I really cannot follow.

I am trying to change one thing to it: when the information from a file is pasted, I would like it include format (but not formulas - so I'm glad that's not the case now).

Would it be possible to let me know what and where I should edit this?



As an additional point, I have a folder full of spreadsheet-shortcuts so that I may access the original (which is in a customer folder) and not work with differing copies.

Is there any way to apply these great macros you created to the targets of these shortcuts?
OpenOffice 4.1.2 on Windows 10
MistaX32
 
Posts: 1
Joined: Fri Apr 08, 2016 3:57 pm

Re: Merge sheets of spreadsheet documents

Postby Villeroy » Sat Jun 22, 2019 12:31 pm

MistaX32 wrote:Is there any way to apply these great macros you created to the targets of these shortcuts?

1. I did not notice this question in 2 years because you did not post it to the right forum. See red box on top of this page.
2. Regarding the question: This works for me on a user friendly operating system. I don't have WIndows at hand yet, but I know that all its link files end with name extension .lnk and Windows hides this suffix from the user even if you tell it to not hide any name extensions.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29294
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: No registered users and 1 guest