Re: [libreoffice-users] Re: How can I reassign a macro to a custom toolbar button?

2018-03-03 Thread jorge Rodríguez
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

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-03 Thread Brian Barker
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

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-03 Thread Art
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

Re: [libreoffice-users] LO calc, how to copy partial sheet onto a new sheet

2018-03-03 Thread Michael D. Setzer II
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

2018-03-03 Thread Art
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

[libreoffice-users] Re: How can I reassign a macro to a custom toolbar button?

2018-03-03 Thread ptoye
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