Re: [libreoffice-users] Multiple templates based on one

Regarding the following, written by "lo.harald.ber...@t-online.de" on 2023-10-12 at 19:11 Uhr +0200: You can edit this document, usually "Untitled1", and save it again as a new document template. See also: https://wiki.documentfoundation.org/Videos/Document_Templates_in_Writer Yeah, I am

[libreoffice-users] Multiple templates based on one

Hello, I am designing a bunch of templates for a small business, e.g. * blank template with just the logo * invoice * official letter * meeting minutes The last three are all just based off the first one, and it pains me to make a copy of the template. Is there a way to inherit from a master

Re: [libreoffice-users] Consolidating values from multiple sheets

Regarding the following, written by "Brian Barker" on 2021-08-18 at 02:33 Uhr +0100: Sorry, but I have no idea what this picture represents. It is usually more helpful to explain how your sheets are organs. Sorry, these were ASCII-formatted tables, but something munged them on the way. Here

[libreoffice-users] Consolidating values from multiple sheets

Hey, I've got several sheets with values such as the following: | Thu | Fri | Sat | |:|:|:| | 5 | 6 | | | | 9 | 10 | | 1 | | 2 | | | 9 | 10 | | 11 | | 12 | | 7 | 8 | | | | 3 | 4 | | 11 | | 12 | Here is another | Thu

Re: [libreoffice-users] Filter an array

Regarding the following, written by "martin f krafft" on 2021-03-10 at 09:32 Uhr +1300: I'd like to create a sheet that is essentially just an array reference to another spreadsheet, but filtered by a column. I.e. make this sheet list `{=file://./other_sheet.ods.A1:J150}` but only

[libreoffice-users] Filter an array

Hey, I'd like to create a sheet that is essentially just an array reference to another spreadsheet, but filtered by a column. I.e. make this sheet list `{=file://./other_sheet.ods.A1:J150}` but only rows where the field in column C is TRUE. I know I can filter the view of such a sheet, but

Re: [libreoffice-users] Parametrising sheets

Regarding the following, written by "Steve Edmonds" on 2020-02-18 at 15:06 Uhr +1300: Do Y and Z stay the same and just x varies (as input). For this one graph, yes. I'd probably also want to make other graphs with Y and Z varying. How many input values of x would you want process and

Re: [libreoffice-users] Parametrising sheets

Regarding the following, written by "Steve Edmonds" on 2020-02-18 at 14:17 Uhr +1300: I don't know about turning a sheet into a formula, but you could create a macro to generate your output series. That sounds ugly, but yes, that could work. But I was really trying to avoid that, and still

[libreoffice-users] Parametrising sheets

Hello folks, I have an elaborate sheet that essentially takes 3 different values as input, and outputs two data series, which I can use to produce a bar chart like so: ``` | | _ || | _ |_ | | _| | | _| | | || | | | | | | | |_ | | | | | | | | | | | | |

Re: [libreoffice-users] Re: Writer ToC starts at §2 but hover shows §1

also sprach martin f krafft <madd...@madduck.net> [2017-03-03 10:27 +1300]: > Even though there are no instances of either Heading 1 or Text body > before the first header, this seems to throw off display of the TOC > (which the hover-text for links is just fine). So I guess, a bug

Re: [libreoffice-users] Re: Writer ToC starts at §2 but hover shows §1

also sprach libreoffice-ml.mbou...@spamgourmet.com [2017-03-03 09:48 +1300]: > Seems to work OK for me, with LibreOffice 5.3.0.3 on Windows. Does > this happen with every document, or just the one? All I can think > to try is right-click within the table

[libreoffice-users] Re: Writer ToC starts at §2 but hover shows §1

also sprach martin f krafft <madd...@madduck.net> [2017-03-02 11:07 +1300]: > Please see the attached screenshots for the ToC with the hover text, > as well as the setting in the index dialogue. The preview looks > exactly right. Since this list strips attachments, here th

[libreoffice-users] Writer ToC starts at §2 but hover shows §1

Hello, I'm using Writer 5.2.5.1 for a document using in which I use outlining for numbering and a table of contents. The problem I have is that while the first Heading 1 instance correctly gets numbered §1, the ToC displays it as §2 *but* when I hover over the entry, I am told to ctrl-click to

Re: [libreoffice-users] Interplay between outline and paragraph numbering

also sprach Philip Jackson [2017-02-28 05:23 +1300]: > Using Tools > Outline numbering on the 'numbering' tab, select > level 1 and set paragraph style to 'Heading 1' then, select level > 2 and set paragraph style to 'Text Body' and 'show sublevels' = 2. Ah,

Re: [libreoffice-users] Interplay between outline and paragraph numbering

also sprach Regina Henschel [2017-02-27 23:29 +1300]: > > 6. The next chapter > > --- > > > > 6.1 sed nulla non rutrum. Donec dapibus pellentesque enim at > >feugiat. Mauris gravida maximus nulla, sed dapibus quam. Cras > >non

Re: [libreoffice-users] Interplay between outline and paragraph numbering

also sprach Robert Großkopf [2017-02-27 20:05 +1300]: > > 3. Some Chapter > > > > 3.1. First 3.2. Second > > > I have tried this one: > Opened a new document. > Written down > Header 1 > Header 2a > Header 2b Thanks for taking the time to respond! I know I can

[libreoffice-users] Interplay between outline and paragraph numbering

Hello, I am working on a complex document with plenty of sections and auto-numbered paragraphs. They're using a custom paragraph style with a custom numbering style for that. Don't ask me why… I now have two challenges: a. I'd like to include the outline numbering in the paragraph

Re: [libreoffice-users] Re: Deleting external links

also sprach Andreas Säger [2016-04-20 17:20 +0200]: > DDE("soffice";"path_name","ref") and URL links > 'file:///path/name.ods'#$Sheet.A1 are established by formula > expressions. Before you can delete them in the links dialog, you > have to remove all formula references. I

Re: [libreoffice-users] Re: Err:504 with DDE links since LO 4→5 upgrade

also sprach Andreas Säger [2016-04-20 17:11 +0200]: > Works for me. DDE works with system notation ("C:\path name\file > name.ods") and with URL notation > "file:///C:/path%20name/file%20name.ods". Try the system notation. For testing purposes, I made a copy of the file and

[libreoffice-users] Deleting external links

Hey list, we are dealing with a rather complex spreadsheet and looking at Edit→Links, there are literally thousands of links in there that are no longer used anywhere in the document. Opening the document (and saving, and sometimes editing, and …) takes several minutes, and we think this is due

[libreoffice-users] Err:504 with DDE links since LO 4→5 upgrade

Hey list, We're dealing with a complex document containing hundreds of DDE links. Worse yet, those DDE links are dynamically created, e.g. using the following formula to reference filename ($B$2), sheet name, ($B$3), column ($B$6), and row (in column $A starting at $A8): =DDE("soffice";

[libreoffice-users] 12 instances of the same sheet

Hi guys (and girls), I need to create a spreadsheet with a sheet for each month of the year. This per-month sheet is actually quite complex, involving a lot of formatting, DDE(), and VLOOKUP() calls etc.. Therefore, I would really like to create one master sheet that has the month parametrised

[libreoffice-users] DDE() links not updating

Hello, I am having a problem with DDE(). The referenced file was changed, but the DDE() result does not update. I tried F9, and I also edited the formula and reentered it, but nothing changes. Edit→Links says not available for all of them. Why is that? Only after I click Update is it updated,

[libreoffice-users] DDE() taking minutes while the CPU has a party

Hey guys, I have a document with about 20 columns and 500 rows using DDE(soffice, …) to get the data from another doucment. The reason I am using DDE() instead of an array reference to the other file is that the array reference does not grow, i.e. if the referred file has a line added, I have to

Re: [libreoffice-users] Re: Enforcing Calc sheet protection

also sprach Tom Davies tomc...@gmail.com [2015-04-16 21:06 +0200]: I'm not sure that aspect is clear from Andreas' post but he probably didn't mean it to be as rude as it might have sounded. It is just something that could potentially be helpful. Wait wait, I am a Debian developer for almost

Re: [libreoffice-users] Casual conversation (was: Re: Enforcing Calc sheet protection)

also sprach Nino Novak nn.l...@kflog.org [2015-04-17 10:21 +0200]: But as far as I perceive it, a bunch of subscribers do appreciate Tom's friendly tone, even if the contents is sometimes not very helpful. Yes, I would be surprised if there weren't a larger number of people on this list who

Re: [libreoffice-users] Re: Enforcing Calc sheet protection

also sprach Andreas Säger ville...@t-online.de [2015-04-15 17:40 +0200]: There is a macro under LibreOffice MacrosToolsMiscProtectSheets which can be used together with ToolsCustomizeEventsSave Document Oh, I didn't even know about all these macros. I'll investigate! Thanks. Unfortunately,

Re: [libreoffice-users] Re: Editing Calc styles: returning to a default

Hi Andreas, thanks for taking your time to respond. also sprach Andreas Säger ville...@t-online.de [2015-04-15 17:44 +0200]: Not sure if I understand what you're after. The [Standard] button on the style editor dialog resets all attributes to the attribute values of the parent style. This is

Re: [libreoffice-users] Re: Calc style management

also sprach Andreas Säger ville...@t-online.de [2015-04-15 17:56 +0200]: Don't be too picky. Concentrate on the cells that need constant editing. There is nothing wrong when you apply some hard attributes to fixed (protected) content. My experience varies. In one case, for instance, we are

Re: [libreoffice-users] Re: Enforcing Calc sheet protection

also sprach Andreas Säger ville...@t-online.de [2015-04-16 13:05 +0200]: Sub protectSheets_onSave(ev) eSh = ev.Source.Sheets.createEnumeration() while eSh.hasMoreElements() sh = eSh.nextElement() sh.protect() wend End Sub Also does not work. :( At some points, I get an error

[libreoffice-users] Calc style management

Dear all, we're working with pretty complex spreadsheets in a project and I've been pushing for the strict adherence to styles (rather than direct formatting). But I am approaching levels of complexity that make it really hard for everyone, and I would love to hear some advice on what I am doing

[libreoffice-users] Editing Calc styles: returning to a default

Dear list, we work with styles extensively. Occasionally, someone will make a mistake and e.g. apply bold face to a style. The problem is that it seems Calc irrevocably remembers this. We can now deselect bold face, but then the style will incorporate not bold, whereas before it simply made no

[libreoffice-users] Enforcing Calc sheet protection

Dear all, we've been pretty strict about locking our Calc sheets, turning cell protection on by default and selectively unlocking those cells that are meant to be edited. Every now and then, some protected cells have to be changed. Currently, the mode of operation is to unlock the sheet, edit,

[libreoffice-users] Fill down with a twist.

Hey folks, If a cell A1 contains '=B1' and I fill-down from A1 to A3, I get references to B2 and B3 for the two new cells. Is it possible to fill down, but scan right? E.g. make A2 become C1 and A3 become D1? Thanks, -- @martinkrafft | http://madduck.net/ | http://two.sentenc.es/ a warm bed

Re: [libreoffice-users] Fill down with a twist.

also sprach Sigrid Carrera sigrid.carr...@gmail.com [2014-09-19 10:18 +0200]: I haven't tested this myself yet, but I would suspect, that if you fill in the first two or three cells manually, then mark all 3 cells and use the mouse to fill in the rest, it will do what you want. Good idea, but

Re: [libreoffice-users] Fill down with a twist.

also sprach Tom Davies tomc...@gmail.com [2014-09-19 12:37 +0200]: I'm not completely sure why you are trying to do this. Context could be useful. I have a table with assumptions about conference days in a budget, and the days are in columns left-to-right. In the overview, I need the days to

Re: [libreoffice-users] Fill down with a twist. [SOLVED w/ hack]

also sprach Tom Davies tomc...@gmail.com [2014-09-19 13:56 +0200]: Create (perhaps by inserting a new row 3 temporarily?) B3 = '=B2' C3 = '=C2' D3 = '=D2' E3 = '=E2' etc and then select all them, copy and transpose 'into' A2 and onwards. Does that not work? No. :( If I take that

Re: [libreoffice-users] Fill down with a twist.

also sprach Stefan Weigel stefan.wei...@bildungskreis.org [2014-09-19 18:55 +0200]: This formula in A1 should behave as you desire: =OFFSET($B$1;0;ROW()-ROW($B$1)) Yeah, I've since found OFFSET() as well, but as you can imagine, my functions aren't just simple references, and using OFFSET()

[libreoffice-users] Changing the default, automatic numbering style

Hello list, When I click on the toolbar numbering button, my current paragraph (or selection) gets numbered with arabic numerals, and indented. How can I change the numbering symbols at level 2+ of such an automatic list, and how can I modify the indentation? Note: I know about paragraph and

[libreoffice-users] Numbering styles: restarting after a heading

Hello, I have a paragraph style Enumeration that I use a lot in legal documents. It is configured to use a numbering style Enumeration. Please see the attached screenshot. My problem is that the numbering is consecutive across all paragraphs, e.g. §1. First Heading ' 1.