Re: [libreoffice-users] Re: How can I reassign a macro to a custom toolbar button?
Hi Ptoye and all:
You can do the same process but more directly with :
Menu-Tools-Customize
I was using for this explanation: LO 6.0.1.1 with English setting
By the way, The Document Foundation organization, that is in
charge to development LibreOffice, is needing voluntaries to update the
documentation and help, to the new version: 6.0. If you want to
contribute with this, you can e-mail to this list to Olivier Hallot to
know more about this.
Regards,
Jorge Rodríguez
El 03/03/2018 a las 05:09, ptoye escribió:
Firstly - sorry to all. I was getting extremely frustrated in trying to do
what looks like a simple thing, but obviously isn't.
I'm finding it a bit difficult to follow your instructions - I suspect that
you are using a different language (Spanish?) from myself.
In Step 2 there isn't a "All Commands" button - but there's an "Add command"
button - is this what you meant?
What you have suggested here - and many thanks for this - seems to be what I
found out by myself: add new buttons and remove the old ones. This is a very
long-winded way of going about it and I'm surprised that the designers
didn't think of a more user-friendly way of reassigning. Your suggestion
implies that they didn't. I had assumed that I'd missed something simple.
I still think it would be a good thing if the help system mentioned this
mechanism.
jorge Rodríguez wrote
Hi Ptoye and all:
At first, try to be more polite because almost all us are
volunteers and collaborate as we can and all of us try to do better.
As I understand, you can reassign a macro following this steps (Or
solve your problem like this) :
1) Menu-Tools-Macros-Organize Macros-LibreOffice Basic (I use this
because is the only programming language that I've used to make a macro
and assign to a toolbar. I don't know if using other language is the
same to do it.)
2) Select Assign icon to open a Dialog Window. There select Toolbars and
click on "All Commands" option. Scroll down to find Macros and select it.
3) In the Chart Function, appear the places where your macros should be
4) Found what you need
5) Now, at right, you can see the Options bar (Default Standar), where
you can select whatever toolbar existing in LibreOffice Calc. But now,
select the + icon that it place at right of it.
6) Appear a Dialog Window where you can input a name ("MyTools" for
example), to make a new toolbar where you can assign all your Macros or
only some of them. Select too the place where it will be saved (Option
below).
7) Now, select the macros that you previously found ( Chart Function
-point 4 ), and with the Arrow to right move to new toolbar "MyTools"
all the Macros that you want.
8) Click "Ok" and then Close the Window. In the area of the toolsbars
(Top of your spreadsheet), below the two first default bar, you can find
your new MyTools bar icons that each one run each macro assigned.
9) The last step is to eliminate the macros of the other toolbar where
you had assigned some of the macros and where you couldn't find place
for all of them. I hope you know how to do this to doesn't duplicate
icons in your spreadsheets (Two bar of them with some same icons that do
the same). If you had problem, can request again to the user e-mail list
of LibreOffice.
I hope this help,
Jorge Rodríguez
-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet
At 14:08 03/03/2018 -0500, Bonly "Art" Bonly wrote: Problem solved, ... Good-oh! At 09:51 03/03/2018 -0500, Bonly "Art" Bonly wrote: ... no matter how I copy it, the formulas are not copied properly. I suspect there *is* a way to do this, but no matter ... ... I can edit each cell to make it right, but it's far to much effort/time to edit all the formulas in each of the columns. I want 365 days worth of data, each day has 8 entries, so I would have to edit almost 3000 (365*8) individual formulas. No, you wouldn't. Any spreadsheet with 3000 individual formulae gives incorrect results. Yes, really! It is humanly impossible to enter 3000 separate formulae without making some errors. Spreadsheets are fragile computation devices and entering many individual formulae is the way to guarantee erroneous results. Instead you probably want at most eight carefully crafted formulae which, when filled down 365 rows, will generate the formulae you need. Indeed, it may even be possible to create a single formula and use it across eight columns, sheets, or whatever as well as filled down 365 rows. So whatever the copying did to your formulae, you would need to re-create at most eight formulae, not nearly 3000. Constructing spreadsheets this way instead of piecemeal is essential if you aspire to reliability. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet
Problem solved, I am constantly amazed at how easy a problem is solved with just a little nudge in the right direction! Thanks to you all! And, thanks to all who administer and maintain the mailing list! BB On 03/03/2018 10:03 AM, Michael D. Setzer II wrote: > If you put a $ in front of the column and/or Row, it will have the copies > remain > unchanged. (Can also be with sheet name linking to that). > > Would have to see the good and bad versions of formulas to see how it > would be changed. > > > > > > On 3 Mar 2018 at 9:51, Art wrote: > > Subject: Re: [libreoffice-users] LO calc, how to copy partial > sheet onto a new > sheet > To: users@global.libreoffice.org > From: Art > Date sent:Sat, 3 Mar 2018 09:51:20 -0500 > >> Hi Brian, Michael, et al, >> >> Brian, yes, the procedure you gave works, as stated. >> >> But, now I realized that I can't expand the spreadsheet to make >> additional days by copying the previous day of data. So, I have a few >> days of data, but need to duplicate those columns so I can have more >> days worth of data to log new quantities of data for each of the new days. >> >> And, no matter how I copy it, the formulas are not copied properly. I >> can see the corrupted formulas after the copy operation. And, I can edit >> each cell to make it right, but it's far to much effort/time to edit all >> the formulas in each of the columns. I want 365 days worth of data, each >> day has 8 entries, so I would have to edit almost 3000 (365*8) >> individual formulas. >> >> I think Michael might be on the right track and has given me some input >> regarding what to search the help file for. Some of the data should >> indeed NOT be changed, while some of it should!!! I had no idea that >> absolute or partial absolute address existed! It's a diet spreadsheet, >> so 7 columns have to refer back to the columns that need to retrieve the >> raw data on calories, carbs etc. And that data does not change. Let me >> try to decipher the help file, although many times it doesn't help much >> because I don't understand so many of the terms it refers to-so I get >> lost easily. Somewhat of a spreadsheet newbie. >> -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet
If you put a $ in front of the column and/or Row, it will have the copies remain unchanged. (Can also be with sheet name linking to that). Would have to see the good and bad versions of formulas to see how it would be changed. On 3 Mar 2018 at 9:51, Art wrote: Subject:Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet To: users@global.libreoffice.org From: Art Date sent: Sat, 3 Mar 2018 09:51:20 -0500 > Hi Brian, Michael, et al, > > Brian, yes, the procedure you gave works, as stated. > > But, now I realized that I can't expand the spreadsheet to make > additional days by copying the previous day of data. So, I have a few > days of data, but need to duplicate those columns so I can have more > days worth of data to log new quantities of data for each of the new days. > > And, no matter how I copy it, the formulas are not copied properly. I > can see the corrupted formulas after the copy operation. And, I can edit > each cell to make it right, but it's far to much effort/time to edit all > the formulas in each of the columns. I want 365 days worth of data, each > day has 8 entries, so I would have to edit almost 3000 (365*8) > individual formulas. > > I think Michael might be on the right track and has given me some input > regarding what to search the help file for. Some of the data should > indeed NOT be changed, while some of it should!!! I had no idea that > absolute or partial absolute address existed! It's a diet spreadsheet, > so 7 columns have to refer back to the columns that need to retrieve the > raw data on calories, carbs etc. And that data does not change. Let me > try to decipher the help file, although many times it doesn't help much > because I don't understand so many of the terms it refers to-so I get > lost easily. Somewhat of a spreadsheet newbie. > > BB > > > > On 03/02/2018 11:05 PM, Brian Barker wrote: > > At 21:45 02/03/2018 -0500, Bonly "Art" Bonly wrote: > >> I did the complete duplicate on a new sheet ... > > > > That sounds as if you copied and pasted "on a new sheet". Have you > > also tried copying the sheet using the technique I described - > > creating the new sheet in the process - instead? > > > > Brian Barker > > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ABC 16613838.513356 | EINSTEIN140857745.999240 ROSETTA 64915897.511531 | SETI109315939.406767 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet
Hi Brian, Michael, et al, Brian, yes, the procedure you gave works, as stated. But, now I realized that I can't expand the spreadsheet to make additional days by copying the previous day of data. So, I have a few days of data, but need to duplicate those columns so I can have more days worth of data to log new quantities of data for each of the new days. And, no matter how I copy it, the formulas are not copied properly. I can see the corrupted formulas after the copy operation. And, I can edit each cell to make it right, but it's far to much effort/time to edit all the formulas in each of the columns. I want 365 days worth of data, each day has 8 entries, so I would have to edit almost 3000 (365*8) individual formulas. I think Michael might be on the right track and has given me some input regarding what to search the help file for. Some of the data should indeed NOT be changed, while some of it should!!! I had no idea that absolute or partial absolute address existed! It's a diet spreadsheet, so 7 columns have to refer back to the columns that need to retrieve the raw data on calories, carbs etc. And that data does not change. Let me try to decipher the help file, although many times it doesn't help much because I don't understand so many of the terms it refers to-so I get lost easily. Somewhat of a spreadsheet newbie. BB On 03/02/2018 11:05 PM, Brian Barker wrote: > At 21:45 02/03/2018 -0500, Bonly "Art" Bonly wrote: >> I did the complete duplicate on a new sheet ... > > That sounds as if you copied and pasted "on a new sheet". Have you > also tried copying the sheet using the technique I described - > creating the new sheet in the process - instead? > > Brian Barker > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How can I reassign a macro to a custom toolbar button?
Firstly - sorry to all. I was getting extremely frustrated in trying to do
what looks like a simple thing, but obviously isn't.
I'm finding it a bit difficult to follow your instructions - I suspect that
you are using a different language (Spanish?) from myself.
In Step 2 there isn't a "All Commands" button - but there's an "Add command"
button - is this what you meant?
What you have suggested here - and many thanks for this - seems to be what I
found out by myself: add new buttons and remove the old ones. This is a very
long-winded way of going about it and I'm surprised that the designers
didn't think of a more user-friendly way of reassigning. Your suggestion
implies that they didn't. I had assumed that I'd missed something simple.
I still think it would be a good thing if the help system mentioned this
mechanism.
jorge Rodríguez wrote
> Hi Ptoye and all:
>
> At first, try to be more polite because almost all us are
> volunteers and collaborate as we can and all of us try to do better.
>
> As I understand, you can reassign a macro following this steps (Or
> solve your problem like this) :
>
> 1) Menu-Tools-Macros-Organize Macros-LibreOffice Basic (I use this
> because is the only programming language that I've used to make a macro
> and assign to a toolbar. I don't know if using other language is the
> same to do it.)
>
> 2) Select Assign icon to open a Dialog Window. There select Toolbars and
> click on "All Commands" option. Scroll down to find Macros and select it.
>
> 3) In the Chart Function, appear the places where your macros should be
>
> 4) Found what you need
>
> 5) Now, at right, you can see the Options bar (Default Standar), where
> you can select whatever toolbar existing in LibreOffice Calc. But now,
> select the + icon that it place at right of it.
>
> 6) Appear a Dialog Window where you can input a name ("MyTools" for
> example), to make a new toolbar where you can assign all your Macros or
> only some of them. Select too the place where it will be saved (Option
> below).
>
> 7) Now, select the macros that you previously found ( Chart Function
> -point 4 ), and with the Arrow to right move to new toolbar "MyTools"
> all the Macros that you want.
>
> 8) Click "Ok" and then Close the Window. In the area of the toolsbars
> (Top of your spreadsheet), below the two first default bar, you can find
> your new MyTools bar icons that each one run each macro assigned.
>
> 9) The last step is to eliminate the macros of the other toolbar where
> you had assigned some of the macros and where you couldn't find place
> for all of them. I hope you know how to do this to doesn't duplicate
> icons in your spreadsheets (Two bar of them with some same icons that do
> the same). If you had problem, can request again to the user e-mail list
> of LibreOffice.
>
> I hope this help,
>
> Jorge Rodríguez
-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
