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

[martin f krafft]

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 aware of that. It's not what I am looking for.

I guess I am thinking more like HTML templating. For instance, let's 
say I have a base template, which defines a couple of fundamental 
paragraph styles, a first page, and a default page style, and 
appropriate headers and footers for each.


Now I want to create two new templates: invoices and letters. Both 
of those are not concerned with fundamental styles or headers and 
footers. They just fill the main page area differently.


Hence my thinking is that ideally, the Invoice template should 
inherit from the Basic template in such a way that if I make a 
change to the headers/footers in the basic template, the invoice 
template automatically updates itself.


… I don't think this is possible… yet? If so, then why stop there? 
Why are templates instantiated and then filled? Why not render a 
document in the context of a template, and only store in the 
document what is required to do so, rather than duplicate everything 
that's already in the template?


Best,

--
martin krafft | https://matrix.to/#/#madduck:madduck.net
 
the unix philosophy basically involves

giving you enough rope to hang yourself.
and then some more, just to be sure.
{: .blockquote }
 
spamtraps: madduck.bo...@madduck.net

{: .hidden }

--
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

[libreoffice-users] Multiple templates based on one

[martin f krafft]

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 template?


Or maybe there is a smart way to have just one template for 
everything, and then easily choose from whatever content template is 
required in the current case?


Thanks for any input!

--
martin krafft | https://matrix.to/#/#madduck:madduck.net
 
no. no musicals. i loathe musicals. i never did have a plan for

doing one. my cousin made me sit through some fucking musical twice.
i just hate them. they bore me stiff. i think they’re just horrible.
even _hair_. and they're always lousy music.
   -— john lennon, _the lost interviews_ by ray connolly
{: .blockquote }
 
spamtraps: madduck.bo...@madduck.net

{: .hidden }

--
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] Consolidating values from multiple sheets

[Martin F Krafft]

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 is what the HTML-rendering looks like:


https://i.imgur.com/rHHekvu.png

So I want to "query" these sets of tables and for e.g. "Thu", get 
the values of the non-empty cells in the "Thu" columns on the 
various sheets.


I can do an array copy, but that includes the empty cells.

Also, ideally, I get the output sorted somehow.

--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
 
"if you are going to run a rinky-dink distro made by a couple of

 volunteers, why not run a rinky-dink distro made by a lot of
 volunteers?"
  -- jaldhar h. vyas
 
spamtraps: madduck.bo...@madduck.net


--
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

[libreoffice-users] Consolidating values from multiple sheets

[martin f krafft]

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 | Fri | Sat |
|:|:|:|
| g   | h   | | 
| a   | | b   | 
| | i   | j   | 
| g   | h   | | 
| e   | f   | | 
| | c   | d   | 
| k   | | l   |


How would one go about creating a new sheet that consolidates all 
these together, so that I'd get a list of all the values for each of 
the columns, i.e. an array with the values {5,1,11,7,11,g,a,g,e,k} 
for "Thu", and so on, and ideally without the blank lines?


Is this possible without scripting? It has to run on Excel as well 
as Calc, and I don't think scripting is a sensible way to go for 
that.


Ideally, I can also suppress duplicates *and* sort the result. Any 
ideas?


--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
 
"i can stand brute force, but brute reason is quite unbearable. there

 is something unfair about its use. it is hitting below the
 intellect."
  -- oscar wilde
 
spamtraps: madduck.bo...@madduck.net


--
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] Filter an array

[martin f krafft]

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 rows where the 
field in column C is TRUE.


So I found that

```
{=IF('./other_sheed.ods'#Sheet1.C1:C150 = TRUE;
 './other_sheed.ods'#Sheet1.A1:J150; "")}
```

kinda works, but it includes empty rows for the rows not matching 
the condition, which is kind of obvious.


Short of writing a script to could be used to (re-)generate such a 
sheet in question at certain times, is there another way to avoid 
the empty rows?


--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
 
a common mistake that people make

when trying to design something completely foolproof
was to underestimate the ingenuity of complete fools.
 -- douglas adams, "mostly harmless"
 
spamtraps: madduck.bo...@madduck.net


--
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

[libreoffice-users] Filter an array

[martin f krafft]

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 I need to actually 
have only these rows show up, so I can use it in formulae.


Is this possible?

Thanks,

--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
 
"once ... in the wilds of afghanistan, i lost my corkscrew, and we

 were forced to live on nothing but food and water for days."
  -- w. c. fields, "my little chickadee"
 
spamtraps: madduck.bo...@madduck.net


--
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] Parametrising sheets

[martin f krafft]

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 display in 
one chart.


Between 5 and 15. But more would be better, to be honest, and hence 
the desire to parametrise, rather than to hack this up with macros, 
or using copy-paste.


--
@martinkrafft | https://riot.im/app/#/room/#madduck:madduck.net
 
"the pure and simple truth is rarely pure and never simple."

  -- oscar wilde
 
spamtraps: madduck.bo...@madduck.net


--
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] Parametrising sheets

[martin f krafft]

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 hope I can!


Thanks for your response!

--
@martinkrafft | https://riot.im/app/#/room/#madduck:madduck.net
 
"i love deadlines. i like the whooshing

 sound they make as they fly by."
-- douglas adams
 
spamtraps: madduck.bo...@madduck.net


--
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

[libreoffice-users] Parametrising sheets

[martin f krafft]

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:

```
|
| _
|| |   _
|_   | | _| |
|  _| |  | || | |
| | | |  | |_   | | |
| | | |  | | |  | | |
-
```

Obviously, there'll be a single formula that produces each data 
point, but it'll be very complex, as the sheet currently derives the 
data in multiple steps.

What I need to do now is to graph multiple of those graphs in one. 
That is, I want a 3D bar graph with the first series equivalent to 
what the sheet would produce with "input" parameters (X1, Y, Z), the 
second series corresponding to "input" parameters (X2, Y, Z), and so 
on.

Is this possible? Without duplicating the sheets, of course? 
Essentially turn a sheet into a function/formula that I can "call"?

Thanks for any hints,

-- 
@martinkrafft | https://riot.im/app/#/room/#madduck:madduck.net
 
"a cigarette is the perfect type of pleasure.
 it is exquisite, and it leaves one unsatisfied."
  -- oscar wilde
 
spamtraps: madduck.bo...@madduck.net

-- 
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] Re: Writer ToC starts at §2 but hover shows §1

[martin f krafft]

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…

Maybe #31379

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"it isn't pollution that's harming the environment.
 it's the impurities in our air and water that are doing it."
  - dan quayle
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 of contents and click
> "Update index" (or via the menu Tools > Update > Indexes and
> Tables) to see if that resolves it.

I've tried that, of course.

I also managed to reproduce this in a new document, which I've
uploaded here:

  http://scratch.madduck.net/lo-toc-off-with-outline-numbering.odt
  size:10889 hash:8c39ae6c8da0971b048a76b0f2f1d82703cf2929

The problem seems to relate to (ab)using outline numbering to number
paragraphs, i.e. Level 1 is Heading 1, but Level 2 is associated
with the Text body style (as per suggested solution to my previous
thread two days ago).

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…

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"es ist gut, eine sache doppelt auszudrücken und ihr einen
 rechten und linken fuß zu geben. auf einem bein kann die wahrheit
 zwar stehen; mit zweien aber wird sie gehen und herumkommen."
  -- friedrich nietzsche
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 they are:

  http://scratch.madduck.net/lo-toc-off-by-one.png
  http://scratch.madduck.net/lo-toc-configuration.png

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"no survivors? then where do the stories come from I wonder?"
 -- captain jack sparrow
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 go to §1. So
somewhere inside, LO seems to get confused.

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.

Am I doing something wrong?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"the college students who are using lsd and marijuana today do not
 comprise a criminal class. they are not drug addicts seeking to
 escape. they're your best educated, your most creative, and your
 most couragious, young people. and like it or not, they might build
 you a new civilisation."   -- porcupine tree, voyage 34
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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, interesting, this opens up new perspectives, and it even makes
sense to treat paragraphs as outline elements.

The immediate problem I have of course is with sub-headings, i.e. if
paragraphs are outline level 2, then I can only have headings at
level 1.

If, however, I need two levels of headings, then paragraphs must be
on level 3, which then means that I always have to have level
2 headers, or else paragraphs get numbered e.g.

1. My heading
=

1.1. my subheading
---

1.1.1 This is the first paragraph

2. My second heading without subheading
===

2.1.1 This is the first paragraph, which is a bit confusing
  because there's an extra 1. At least it's not a 0.

I know one is best advised not to mix outline aith automatic
numbering, but it'd still be rather useful, I find, to have the
ability to prepend "context" to numbering styles.

If I made a feature request about this, do you see any chance of
someone taking it on?

Thanks for all your help!

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
one has to multiply thoughts to the point
where there aren't enough policemen to control them.
 -- stanislaw jerzey lec
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 varius libero. Etiam id nisi urna. Maecenas tincidunt
> >lacus at purus dignissim, ut consequat enim elementum.
> > 
> 
> That is the field "Show Sublevels" on tab "Numbering" in the "Outline
> Numbering" dialog. Click on "2" in the list "Level". Then the field is
> enabled and you can choose "2".

Dear Regina,

Thanks for replying. Unfortunately, I must have been unclear yet
again. I am aware of "sublevels" and I don't want to change anything
in outline numbering. All of my challenges revolve around paragraph
numbering (using custom enumeration styles), where I want to:

  - include the current chapter number in the paragraph number;

  - have the paragraph number reset 1 every time a new chapter
opens.

Take care,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"work consists of whatever a body is obliged to do.
 play consists of whatever a body is not obliged to do."
   -- mark twain
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 display "sublevels" for headers (they are actually
superlevels…), but what I am trying to do is to include the chapter
number in paragraph numbering. I am sorry if this was not clear:

  5. The current chapter
  --

  5.1.  Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Duis finibus posuere mauris, sit amet viverra turpis accumsan et.
Sed vitae commodo dui. Donec id est tristique, finibus orci sit.

  5.2.  Nulla tincidunt leo in risus sagittis, vel condimentum sem
interdum. Nunc et efficitur metus. Quisque a suscipit justo, at
semper magna. Proin neque elit, sodales quis nibh ut, convallis

  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 varius libero. Etiam id nisi urna. Maecenas tincidunt
   lacus at purus dignissim, ut consequat enim elementum.

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
apt-get source --compile gentoo
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Interplay between outline and paragraph numbering

[martin f krafft]

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
 numbers, i.e. instead of


  3. Some Chapter

  1. First
  2. Second


 I want/need:


   3. Some Chapter

   3.1. First
   3.2. Second


 Can Libreoffice automate this for me?

  b. At every outline-relevant heading, the numbering should be
 reset. Right now it does not, but instead I get this:


  […]
   1. First
   2. Second

   C. A new chapter

   3. First
   4. Second


  until I right-click the "3." and select "restart numbering"
  from the context-menu, which I found to be rather brittle

  Can I somehow restart paragraph numbers at every section
  start?

Thanks for any insights!

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
the only real advantage to punk music is
that nobody can whistle it.
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 don't want to remove all links. I want to remove those links that
are no longer in use.

Here's a simple example: let's assume $A$1 has the contents
"blue.ods", and I fill $B1:$B100 with a formula along the lines of

  # effectively copy 100 cells from blue.ods#Sheet 1 column B
  DDE("soffice"; $A$1; CONCATENATE("Sheet 1.$B$"; ROW()))

This will generate 100 links.

Now I change "blue.ods" to "red.ods" and recalculate. Now I have 200
links, but 100 of those are no longer in use.

Does this make sense?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
seen on an advertising for an elaborate swiss men's watch:
  "almost as complicated as a woman. except it's on time"
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 used the
absolute path in system notation. The result is the same.

I did notice that — with relative or with absolute paths — that the
DDE() calls work in some contexts, but not in others. It seems very
very brittle and I cannot figure out why.

> Call menu:Edit>Links to inspect links and delete unused links.

See my other question on the list: There are thousands of unused
links there and I can't delete them other than individually, which
can't be the solution.

I wouldn't be surprised if Libreoffice just can't handle all these
inactive links and chokes.

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
too many have dispensed with generosity in order to practice charity.
 -- albert camus
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Deleting external links

[martin f krafft]

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 to the sheer massive number of links.

We found that links can be individually deleted (broken), but we
were wondering if there's a way to do so in bulk? Or better yet, how
can I automatically remove unused references in this list?

Thanks for any hints,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"next the statesmen will invent cheap lies, putting the blame upon the
 nation that is attacked, and every man will be glad of those
 conscience-soothing falsities, and will diligently study them, and
 refuse to examine any refutations of them; and thus he will by and by
 convince himself that the war is just, and will thank god for the
 better sleep he enjoys after this process of grotesque
 self-deception."
 -- mark twain
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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";
CONCATENATE("file:./";$B$2);
CONCATENATE("$";$B$3;".$";$B$6;"$";$A8);
0)

This worked very well a year ago, but when we tried to open it as of
late, we get "Err:504" (parameter list error) all over.

The only thing that's changed is that we've since upgraded from
Libreoffice 4 to version 5.

Are you aware of (a) the relevant change, and (b) a remedy to this
problem, so that we can use DDE links as we used to with Libreoffice
5.1.2?

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
http://www.transnationalrepublic.org/
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] 12 instances of the same sheet

[martin f krafft]

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 (which I know how to do).

But how can I instantiated 12 sheets from a master sheet such that
changes to the master apply to all 12 sheets? For instance, if
I change the formatting of a cell, or the DDE() function call, how
can I make sure that I don't have to make this change 12 times?

Have you had any experienced with the like?

I've considered creating just one sheet for all 12 months, but it
just gets too wide and isn't really nice to deal with anymore. I've
also considered providing 12 forms as "views" into the sheet, but
that does seem like overkill too.

Does anyone know what I should best do?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"and the sea isn't green
 and i love the queen
 and what exactly is a dream?
 and what exactly is a joke?"
-- syd barrett
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] DDE() links not updating

[martin f krafft]

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, but since I have
thousands of links and I cannot select them in bulk, this is not
viable

Is there another way for me to just force all DDE() links to update?

Thank you,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
perl -e 'print The earth is a disk!\n if ( earth == flat );'
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 erase and recreate the array, whereas
I can just add additional DDE() lines.

The problem I am having is that with 500 lines, adding a new line
(using fill-down) takes about *an hour per line*, so to add 6 lines,
I just had the machine chugging at 100% CPU time for 6 hours, while
libreoffice was entirely unresponsive.

Do you have any idea what's going on, or how to optimise this?

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
to me, vi is zen. to use vi is to practice zen. every command is
 a koan. profound to the user, unintelligible to the uninitiated.
 you discover truth everytime you use it.
   -- reddy ät lion.austin.ibm.com
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 20 years and a FLOSS
contributor for longer than that, which means two things: I know
perfectly well how to read messages on mailing lists, and I should
have done my homework better.

I appreciated Andreas' replies and didn't think they were rude.
I should have researched this better and provided more information.
Truth is that I was under time pressure and not particularly excited
to dive into MacroScript or whatever it's called.

So, no hard feelings. I hope I can catch up and deliver what
I should have sent in the first place.

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
a warm bed in a house sounds a mite better
 than eating a hot dog on a stick
 with an old geezer traveling on a lawn mower.
-- alvin straight (the straight story)
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 didn't appreciate his message.

 Does anybody know a good solution for this dilemma?

Coexist and don't take things personal. And also try to stay away
from personal messages yourself. I.e. Tom could have sympathised
with me without guessing that I might have thought Andreas was being
rude.

If you're interested, there is
https://people.debian.org/~enrico/dcg/ and there was also recently
a fantastic article about how to choose your words on mailing lists,
but I am failing to find it. I will follow-up…

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
oh what a tangled web we weave,
 when first we practice to deceive.
 but my how we improve the score,
 as we practice more and more.
   -- sir walter scott
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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, ProtectSheets doesn't seem to work on an existing
document (while it works fine on a new document). If I assign it to
the Save Document event, then I get an error about a missing
property or method Count on the line

  For i = 0 To oDocSheets.Count-1

Do you have any idea what could be going on here? While I can read
this language, I have absolutely no idea about it. When I set
a break point on the macro, it's being ignored unless I run the
macro directly. And then, the error is a different one, it seems,
namely that

  StarDesktop.CurrentFrame.Controller.Model.Sheets

5 lines above is out of scope and (consequently) has no property
or method Sheets.

 A database with an input form would save you a lot of trouble, but
 this would require that you forget about spreadsheets and accept
 a more professional approach.

Oh, I am well aware that spreadsheets are hackery, but the use cases
I have (mainly budgeting in non-profits) require a high degree of
flexibility. I am not aware of any database that would be suitable
for these tasks, and creating one would require *way* more time than
scrambling along, especially since the structure of the budget (e.g.
for DebConf taking place in a different country every year) varies
considerably every year. Sure thing, I want to try to normalise this
a bit and then maybe the time for a database approach has come, but
for now, spreadsheets with locked cells are as good as it gets.

Thanks

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
it is easier to be a lover than a husband for the simple reason
 that it is more difficult to be witty every day
 than to say pretty things from time to time.
   -- honoré de balzac
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 better than recreating the style, so thank you for the hint.

I guess what I am really after is some sort of text-file export or
a UI allowing me to individually add and remove attributes from
a style. I imagine some tree arrangement and attributes, such as
underline, and then I can select whether this attribute

  - is set to on   (forces underlining)
  - is set to off  (forces no underlining)
  - is not set (inherits underlining from other formatting/styles)

While this does not exist, I can make do with your solution.

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
obviously i was either onto something, or on something.
 -- larry wall on the creation of perl
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 preparing
a funding application for a children's theatre to the state and the
document should look consistently formatted (it's been returned to
us before due to formatting inconsistencies… don't ask…). We are
maintaining the document in Git, and even though we all use
Libreoffice 4 on Linux, it's not uncommon that some formatting gets
lost between saving the document on two different computers. I found
that styles mitigate this problem a little bit.

  Say you have a simple table with row 1 being a header row, row
  20 a results row, and plain rows between, column A holding
  dates and column B percentages.
 
 Blending data, appearance and calculation is the major weak point
 of all spreadsheet tools. Spreadsheets are quick and dirty tools.
 Quick and dirty tools are expert tools and never fool proof by
 any means. All the meticulousness invested by millions of Excel
 experts is a waste of time. A single copy and paste or the
 unforeseen error of an untrained user may override everything.

I fully agree. And yet, fundamentally, I don't see why this couldn't
be addressed. Data and calculation are perpendicular aspects and you
can think of them as content and completely ignore everything
regarding formatting about them. I.e. at the content level, it's
just cell references, data, and formulae.

The problems seems to be on the formatting (appearance) layer.
From a user's perspective, I would currently conclude that each
cell's appearance depends on (a) the formatting attributes defined
in the (single) style applied to the cell, and (b) the formatting
attributes applied directly to the cell.

The solution IMHO would be to simply allow multiple styles to be
applied to each cell, ideally even from different sources. With
this, the appearance would depend on the attributes derived from

  1. styles applied to the column
  2. styles applied to the row
  3. direct formatting applied to the column
  4. direct formatting applied to the row
  5. styles applied to the cell
  6. direct formatting applied to the cell

The order of column-before-row could probably even be made
configurable per-sheet. Other than that, the merging would be
trivial: attributes obtained later in the above series would
override attributes set earlier, and each attribute could either be
set (forced) to on or off, or unset (in which case it's transparent
and gets ignored).



also sprach toki kantoor toki.kant...@gmail.com [2015-04-16 02:19 +0200]:
 Is this semantic markup, or presentation markup, or just sommer
 markup?

I am not entirely sure what you are differentiating between. Some is
semantic (e.g. dates), some is presentation (e.g. header).
I don't know what sommer markup is.

 What is the difference in the presentation markup between header
 and date?

Nothing. A date field means the data should be rendered as a date.
A header field means that the font should be e.g. bold on a gray
background. And there can be header-date fields, meaning that data
should be rendered as a date, in bold, and on gray background.

Makes sense?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
if ever somethin' don't feel right to you, remember what pancho said
 to the cisco kid...  `let's win, before we are dancing at the end of
 a rope, without music.'
 -- sailor
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 when trying to run it. At other
times, the sheets are simply not protected after running it.

Also, it seems impossible to assign a macro stored in a file to an
event. I.e. when trying to assign a macro to Save Document, the
macros stored in the .ods file are not available. :(

I assume that this is because the macro is assigned locally, not in
the document. In that case, I would have to make sure everyone
configures the macro in their libreoffice instances, which is
unrealistic (we can't even get everyone to install lint hooks for
Git etc.).

What I really just want is to tell the document that it should never
save the state of sheet protection and always open with all sheets
protected…

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
i think, therefore i'm single
  -- lizz winstead
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc style management

[martin f krafft]

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 wrong or how our approach could be improved.

Say you have a simple table with row 1 being a header row, row 20
a results row, and plain rows between, column A holding dates
and column B percentages.

Currently, we have 6 styles to represent all combinations, and after
formatting the entire column A as dates-plain and column B as
percentages-plain, we need to format A1 as dates-header, B1 as
percentages-header, A20 as dates-total, and B20 as
percentages-total. If ever column A or B needed reformatting (e.g.
because rows were pasted wrongly), then the manual overwriting of
the cells in rows 1, 20 and between would need to be redone.

Is there a better way to approach this? Can styles be somehow
combined, such that cell A1 would simultaneously be a header and
a date cell, given that the two styles are perpendicular and
don't really affect each other?

Thanks for any insights!

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
science without religion is lame,
 religion without science is blind.
-- albert einstein
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 statement about bold face and hence could
be combined with direct formatting.

Is there a way to return a style to defaults, or put differently,
can a style definition be reduced somehow to just the attributes
that I want to control?

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
a mathematician is a device for turning coffee into theorems.
 -- paul erdös
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Enforcing Calc sheet protection

[martin f krafft]

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, and
then lock the sheet again, before saving.

Unfortunately, that second-to-last step is often forgotten,
resulting in us committing a version of a document with unlocked
sheets.

Is there a better way to approach this? Is there maybe a trick how
to automatically protect all sheets on save, or to just temporarily
unlock them?

Thanks,

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
i wish this wish not to be granted!
-- achilles (hofstadter's geb)
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Fill down with a twist.

[martin f krafft]

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 in a house sounds a mite better
 than eating a hot dog on a stick
 with an old geezer traveling on a lawn mower.
-- alvin straight (the straight story)
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 unfortuately, it does not work.

If the two cells are B1 and C1 with references to A1 and A2, then
selecting both cells and extending the selection right will create
pairs of B1/B2 and C1/C2. The same applies to vertical
extension/filling.

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
alle menschen zerfallen, wie zu allen zeiten so auch jetzt noch, in
 sklaven und freie; denn wer von seinem tag nicht zwei drittel für
 sich hat, ist ein sklave, er sei übrigens wer er wolle: staatsmann,
 kaufmann, beamter, gelehrter.
 - friedrich nietzsche
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 appear top-to-bottom. It's
*painful* to do this by hand.

 Edit - Paste Special - tick the transpose box

This does almost what I want, except it copies values, and it does
not insert references.

 If you extend that idea so that
 B2 = B1
 C2 = C1
 D2 = D1
 E2 = E1
 and then select B2-E2, cut (or copy), click in A2 and then do
 Edit - PasteSpecial - transpose
 then
 A2 = B1
 A3 = C1
 A4 = D1
 A5 = E1

Right, except I would like A2 to be '=B2' and A3 to be '=C2' etc.

Does this make sense?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
i might disagree with what you have to say,
 but I'll defend to the death your right to say it.
   -- voltaire
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 temporary row 3 and paste it into the four fields in
the destination column G1:G4, then the references get rotated too.

I.e. the result will be:

G1 = '=F1'
G2 = '=F2'
G3 = '=F3'
G4 = '=F4'

This is because row three in the above always references the cell
above, and after transposing with paste-special, the resulting cells
are modified to reference the respective cell to the left.

If I change B3:E3 to '=B$2':'=E$3', I get an error 522 in the
result, because the cells are now all '=G$2', which is
a self-reference.

If I change B3:E3 to '=$B2':'=$E2', I get the following weird
result:

G1 = '=$B#REF!'
G2 = '=C1'
G3 = '=D2'
G4 = '=E3'

But if I change B3:E3 to all absolute references, then it works.
Super! Thank you for that hint. It's a hack, but it works.

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
der glaube an den kausalnexus ist der aberglaube
   -- wittgenstein
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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() actually
makes it totally unreadable.

Tbh, I was also wondering why this isn't a use-case for a pivot
table, given that I simply pivot data 90°…

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
a qui sait comprendre, peu de mots suffisent.
 -- intelligenti pauca
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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 numbering styles, but I am
specifically asking about the toolbar button automatic list styles
here.

Thanks,

-- 
martin | http://madduck.net/ | http://two.sentenc.es/
 
have you drugged your kids today?
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[martin f krafft]

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. First paragraph
  2. Second paragraph

  §2. Second Heading
  ''
  3. First paragraph (should be numbered '1.', not '3.')
  4. Second paragraph (should be numbered '2.', not '4.')

I can right-click on that '3.' and select Restart numbering to get
the desired effect, but I'd like to figure out how to do this
automatically.

How can I reset/restart the numbering of a given numbering style
after every outline-relevant heading?

Thanks,

-- 
martin | http://madduck.net/ | http://two.sentenc.es/
 
we are like shop windows in which we are continually arranging,
 concealing or illuminating the supposed qualities other ascribe to us
 -- in order to deceive ourselves.
 - friedrich nietzsche
 
spamtraps: madduck.bo...@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted