Re: [libreoffice-users] Insert page before TOC
On Monday, 4 May 2020 09:28:02 BST Robert Großkopf wrote: > Hi Ian, > > > Thanks Robert. That allowed me to insert a page break but the new > > page had a background colour the same as the TOC and changing the > > style from "Contents Heading" to Default Style" wouldn't remove it. > > Did you really press Alt + Enter two times? > The first break will be part of the TOC, the second break will be out of > the TOC. > > I have tested this before and saw that the first Alt + Enter was part of > the TOC and will have been gone when updating the TOC. > > Regards > > Robert > damn, yes, i did forget. works as you said now. At the end of the day, it might be quicker to delete the TOC, insert a page and the recreate the TOC. thanks again. -- opensuse:tumbleweed:20200501 Qt: 5.14.1 KDE Frameworks: 5.69.0 - KDE Plasma: 5.18.4 - kwin 5.18.4 kmail2 5.14.0 (20.04.0) - akonadiserver 5.14.0 (20.04.0) - Kernel: 5.6.6-1-default - xf86-video-nouveau: 1.0.15 -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Insert page before TOC
On Sunday, 3 May 2020 10:54:47 BST Robert Großkopf wrote: > Hi Ian, > >> > >> you could try this: > >> Change the TOC. It is protected against manual changes. > > How do you change it if its protected other than update it? I couldn't find > > how to "unprotect it" > > Right click with mouse on the TOC → Edit Index > Type → Type and Title → Protected against manual changes (must be unchecked) > > Regards > > Robert > Thanks Robert. That allowed me to insert a page break but the new page had a background colour the same as the TOC and changing the style from "Contents Heading" to Default Style" wouldn't remove it. So it looks like the only work around is to delete the TOC to insert a page. -- opensuse:tumbleweed:20200501 Qt: 5.14.1 KDE Frameworks: 5.69.0 - KDE Plasma: 5.18.4 - kwin 5.18.4 kmail2 5.14.0 (20.04.0) - akonadiserver 5.14.0 (20.04.0) - Kernel: 5.6.6-1-default - xf86-video-nouveau: 1.0.15 -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Range names
At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote: Let's say I have a spreadsheet (I actually have several ) with a lot of cells and ranges already filled with data and formulas. One day I discover the range naming feature, so I name a few cell ranges. Shouldn't there be some easy way to replace every occurrence of those cell ranges in all my formulas? I don't think any automatic system could do exactly what you probably want. Say your range is A1:B5 on Sheet1 and suppose you name this as Name. You may think that "Name" is now synonymous with "A1:B5", but no: instead it is shorthand for "$Sheet1.$A$1:$B$5". There are thirty-two variations on "Sheet1.A1:B5" you may have in your spreadsheet, each including a different combination of those dollar signs. As you will know, each version behaves differently if you fill ranges from a cell with a formula containing it, or if you copy and paste from such a cell. So the differences are important. By including "Name" in a formula, you are choosing to imply the anchored or absolute version of the range. In order to preserve the precise meaning and behaviour of your existing formulae, any automatic system should replace a spelled-out reference only when it includes all five dollar signs. But in practice one may rarely add all those dollar signs in formulae, instead using only as many are necessary for the filling or copying that one is expecting to need. I suspect you wouldn't be impressed if an automatic system failed to replace "A1:B5" or "A$1:B$5" with your newly defined "Name". But if it did, it would corrupt some spreadsheets that you or others might compose. And when I say easy, I mean easier than doing search and replace on each one of them one by one. I can't find such a feature. Is there an extension for it? When you do this, you would need to determine in each case whether the replacement by the range name would be appropriate. And an automatic system could not do that for you. I'm going to write a macro for it, ... Which of the thirty-two variations will it replace? I trust this helps. 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Insert page before TOC
Hi Ian, > Thanks Robert. That allowed me to insert a page break but the new > page had a background colour the same as the TOC and changing the > style from "Contents Heading" to Default Style" wouldn't remove it. Did you really press Alt + Enter two times? The first break will be part of the TOC, the second break will be out of the TOC. I have tested this before and saw that the first Alt + Enter was part of the TOC and will have been gone when updating the TOC. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy