[libreoffice-users] Base Guide 6.2 Published!

2020-05-03 Thread Pulkit Krishna
Hello Everybody, At last Base Guide 6.2 has been published. I have uploaded the complete book as well as the separate chapters to the wiki. They can be downloaded from:- https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Oliver, Can you put the book on the main

Re: [libreoffice-users] Range names

2020-05-03 Thread Steve Edmonds
Hi Johnny. I came up against this issue last year after needing to open an excel sheet in Calc. Excel allows range names that Calc doesn't so the sheet wouldn't work. I wanted to rename the offending excel ranges. I couldn't find a solution like you seek. steve On 03/05/2020 19:35, Johnny Rosenber

Re: [libreoffice-users] Insert page before TOC

2020-05-03 Thread Ianseeks
On Saturday, 2 May 2020 10:17:28 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" > Set the cursor at the start of the TOC. > Pr

Re: [libreoffice-users] Insert page before TOC

2020-05-03 Thread Robert Großkopf
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 change

[libreoffice-users] Range names

2020-05-03 Thread Johnny Rosenberg
Hi! I'm just wondering if I'm missing something. 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 eve