[libreoffice-users] Use of QR/Barcode insertion.

[Michael Tiernan]

I'm wondering if I missed something.

In "calc", the "Insert" -> "OLE Object" -> "QR and Barcode" option gives me
a window that allows me to put "text" into the field which it then
generates the graphic from.

Did I miss it? How do I tell it to use the contents of a cell as the source
of the graphic?
(I have generated a series of values that I want to use to create a QR code
for each one.)
Thanks for everyone's time.

-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein

-- 
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] Re: Master document and styles.

[Michael Tiernan]

On Wed, Jan 31, 2024, 6:03 PM Michael Tiernan 
wrote:

>
> 1) I'm going to (next time I try this) start by duplicating any style I
> want to use and prefix it with my project name so I can keep them easier to
> identify.
>


Now that I understand it better I'll answer the two questions I got in the
mail.

If one of my styles uses a predefined style like default paragraph text and
someone else changes that they won't know that it affects the rest of the
document so if I use a prefixed name cut off any connection to the other
formats.

So, yes I use a prefix with my styles and I tried to separate the "inherit
from thing and chain them to each other as best I can.

I have a template for each chapter/topic and I am trying to load changes in
styles into that and then I can propagate that across the sections. It's
ugly but the best I cand with my limited experience. (It also allows me to
document the procedure for updating the manual for those less versed in it.)

>

-- 
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] Re: Master document and styles.

[Michael Tiernan]

Okay, here's what I've "figured out so far." Based on some *very* limited
knowledge. Just from my point of view.

1) I'm going to (next time I try this) start by duplicating any style I
want to use and prefix it with my project name so I can keep them easier to
identify. (I don't have to go through the "did I modify that style" for my
project if I do that.)

2) My current mess was/is caused by not being clear on where the
"authority" of the styles resides. So, I'll keep a page template (an .odt
file) and *NEVER* modify the styles pages in the book. I have to modify the
master template then import it to my current document. Once I like it, then
import it into each separate part of the book. Each import using the
"overwrite" option.

3) The very first thing I'll duplicate is the default settings when I open
the blank page.

I will reiterate the desire, should it become an option, I want to "export"
a/some/all of the styles as a separate file, maybe a json, etc. where I can
then manage only the settings I care about.

Thanks for everyone's time and help!

-- 
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] Master document and styles.

[Michael Tiernan]

On Mon, Jan 15, 2024, 12:03 PM Wiebe van der Worp  wrote:

> On 14-01-2024 17:02, Michael Tiernan wrote:
> > I have a master document which has a number of styles in it.
> >
> > I have a "Page/Section" template that I distribute to others to create
> > sections for inclusion into the master.
>
> Is working with .ott templates an option?


I just double checked, that's what I distribute, an .ott file.

Tomorrow, when I get a few mins I'll review the suggestions I was sent.

I did think about the method of messing up the smooth handling of styles
and am going to look into it more.

I've written some things here,
> hope it helps
>

Yes! Very helpful.

Thank you!

-- 
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] Master document and styles.

[Michael Tiernan]

I have a master document which has a number of styles in it.

I have a "Page/Section" template that I distribute to others to create 
sections for inclusion into the master.


One of those people (correctly) fixed a mistake of mine and sent it back.

I can absorb those changes by loading the styles from his returned 
document into my template and then into the master.


Now, what's the best way to change all the sections other folks sent me 
and make sure that all the styles are consistently synchronized across 
all documents?


Also, maybe this is a good time to suggest that the exporting and 
importing of styles be done using an external file, i.e. XML or JSON, 
would be really a nice feature to have.


(Part of that suggestion is driven by, what i see as, the inability to 
absorb into a template document the styles from the master document. Or 
so it seems.)


I have also come to the opinion that the "smart" (*cough*) way for me to 
keep them all coordinated is to copy every style used in the docs into a 
new one with some prefix like "my" and use it on all styles in the doc 
such as "my  Default Paragraph"



Thanks for everyones time.

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Master document, internal link between documents and pdf

[Michael Tiernan]

On 1/13/24 5:39 AM, Robert Großkopf wrote:



The question is :

In document C.odt I put the definition of electrical *connector* and 
give an antonomasia *WAGO*.


In the W.odt document I put *WAGO*: electrical connector whose name 
is that of the manufacturer.


I would like to put a link from WAGO in the C.odt document to WAGO in 
the W.odt document.


Open Document W.odt.


But if both documents are in a master document the reference could be 
found and will work. 


(Addmittidly Ive not tried it yet)

Can this work for page numbers too?

(Using the original document as an example), adding to the reference for 
"WAGO" in the "C" document something that may say something like see 
"WAGO on page XXX" where the XXX is where the finished document will put 
the reference to WAGO?


Than ks for everyones time.

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Actual bug report.

[Michael Tiernan]

When attempting to muddle about with some data from a google form.

First, the version info is:

Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 
53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Mac OS X 
13.3; UI render: default; VCL: osx Locale: en-US (en_US.UTF-8); UI: 
en-US Calc: threaded


I have ~104 "Fields" from a long google form. They look like this:

Timestamp
Email Address
Respondent's Name: (Last, First)
Respondent's preferred pronoun:
Respondent's Title:
Respondent's Email:
Respondent's Phone Number:
Full/Proper name for your group:
What do you use for an abbreviation for your group?
Choose Section Please:
Choose Principle Investigator to edit
Principle Investigator #1 Name: (Last, First)
Principle Investigator #1 Title:
Principle Investigator #1 Phone:
Principle Investigator #1 Email:
Mailing list membership for PI#1 [xxx Announce]
Mailing list membership for PI#1 [xxx Alarm]
Add another?
Principle Investigator #2: Name: (Last, First)
Principle Investigator #2: Title:
...

(I get what I was handed.)

So, now, I try to create a DB with it.

I open the "Create DB" dialog and begin to work my way through it.

I get this screen: (As expected.)

https://www.dropbox.com/s/g913wtewb7gandc/MCT_Screenshot_20230410_084718-P1.png?dl=0

So, trying to use almost all the fields execept for a couple. So, I do 
the ">>" thing to move them all over so I can go delete the ones I don't 
want. That gives us this screen:


https://www.dropbox.com/s/bi3ec5snrf2shht/MCT_Screenshot_20230410_084805_P2.png?dl=0

On this screen, I tried to resize the "Query Wizard" screen to be wider 
so that I can read the field names and I can't.


That's the bug.


--
  << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan 
  Non Impediti Ratione Cogatationis

  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein

--
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] Quirky behavior report....

[Michael Tiernan]

Using Libreoffice:

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 8; OS: Mac OS X 13.3; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

I have two displays, the laptop and an external with it.

I did an "About LibreOffice" on the laptop screen and got what I 
expected, the little window came up. I then tried to move that window to 
the external display and it disappeared!


I tried it multiple times with the same result.

BUT, open the "About" from the menubar of the external display and it 
stays and I can move it to the laptop screen without any problems.



--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Macros in spreadsheets

[Michael Tiernan]

On 12/23/22 11:02 AM, Andrew Pitonyak wrote:

If you are looking to cause functions to recalculate,


Thanks for the reply.

Here's the thing. It's not that I want to force a recalculate, it's that 
I have to in order to get the macros to respond.


Here's an example: (What I expect when the spreadsheet finishes opening.)

/*Cell*//*
*/  /*Contents*//*
*/  /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
192.168.17.231
D3
=ipmask(D1)
255.255.255.0
D4
=ipmasklken(D3)
24

Now, when I actually do open the spreadsheet, it says:

/*Cell*//*
*/  /*Contents*//*
*/  /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
#NAME?
D3
=ipmask(D1)
#NAME?
D4
=ipmasklken(D3)
#NAME?

So, if I say it differently, it *seems* like the Macros aren't run when 
the spreadsheet is opened.


The macro library has a "Main" entry that is empty. If I choose "Tools" 
-> "Macros" -> "Run macro" and then select "Main" and execute it, 
there's no visible change.


BUT, if I go into the contents of "D2" and add a space at the end of the 
formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and hit 
return and the macro executes and displays the proper value.


HOWEVER, none of the other cells change so I have to go into each one 
and do the same sort of thing, add a space at the end of the line or 
between the macro and the parenthesis, each time, hit return and it 
works properly.


This is obviously not the correct way it should work.

Hence my query about "starting" macros when the document is opened.

So, that leads to, am *I* doing something wrong?

Thanks for everyone's time.

--
  << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan 
  Non Impediti Ratione Cogatationis

  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein

--
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] Macros in spreadsheets

[Michael Tiernan]

I have a couple of BASIC macros in a spreadsheet.

I keep thinking that there must be a "init" function that isn't being 
called because each time I open the spreadsheet, the macros don't run. I 
have to mess about a bit and then force each cell to recalculate 
manually. (I'm sure that there's a global 'recalculate' button/tool 
somewhere but that's secondary to the problem.)


I know there's a lot of documentation out there on macros (almost too 
much) but I'm not sure where to start reading, does anyone have a 
pointer that would address, not how to create a macro but how to 
incorporate it to become automatic?


Thanks.

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Proper forum for feedback.

[Michael Tiernan]

I was recently working on a form for a database and I ran into some quirks
that had me cursing and I wondered if anyone wants the feedback (more
nicely worded of course) on the things that irked me during the build
process?

If so, where/how should this be channeled?

Thanks for everyone's time.

-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein

-- 
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] Better approach for formatting

[Michael Tiernan]

I have a request to create a table *like* entry in Writer that would look
like this:

Revision  Date  Author
   Description

so that if done, it would look sort of like this: (Newest on top).

V1.4   21-July-80Fred Farkle
   Long verbose description of all the brilliant changes put back in..
V1.3   20-Jul-80  Peter Pickle
   Deleted long verbose descriptions put in by Fred "Purple Prose"
Farkle.
V1.2   19-July-80Fred Farkle
   Added long verbose description of all the brilliant changes put back
in.
   (Multiple lines of content here.)

I did it and passed it back for the other person to go on with. BUT, I
started wondering if there's a "better" way to do such a thing.

I thought one method using "Paragraph Styles" to do the work but it seems
like the wrong tool for the job.

I considered a table but it doesn't seem to fit the task either.

The PITA is the long description below the entry line.

So I'm wondering how, without changning the required format, how would you
make such a thing in a Writer document?

A) I'm asking to learn.
B) I'm asking to stir the collective discussions.
C) See if anyone has a solution that is unique. :)

Thanks everyone for the use of your electrons.
-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein

-- 
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] Crash creating DB from Spreadsheet.

[Michael Tiernan]

This was a wacky crash. I've downloaded the newest beta to try it out and
it seems to not have behave the same way so, to use Rosannana Danna's
overused phase "Never mind!" ;)

Thanks to everyone!

I'm going to start over with this.

-- 
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] Re: Crash creating DB from Spreadsheet.

[Michael Tiernan]

On 4/2/21 7:36 AM, Michael Tiernan wrote:

Just checking before I file a bug report,


As someone pointed out, I wasn't at the newest version.

My apologies for wasting folk's time.

I'll update and revisit this.

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Crash creating DB from Spreadsheet.

[Michael Tiernan]

Just checking before I file a bug report, anyone else seen (or know of) 
a fairly repeatable crash of LO when using a spreadsheet as the DB when 
creating a query or form?


In short, I have a simple(istic) spreadsheet with 27 columns, and 
(currently truncated to 16 rows).


When I attempt to create a DB and link it to that Boom.

(Yes, I'm collecting screenshots showing the sequence.)

Thanks for everyone's time.

Version: 7.0.3.1
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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: version control of sorts: it is gone?

[Michael Tiernan]

The thing I've noticed is that even of the checkbox for "always save new
version" is set it doesn't do, as I supposed, save a new version when you
hit "Save", you actually have to go into the versions box and force it.

-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein
Sorry for the unedited top post. Client forces it.

On Wed, Jul 22, 2020, 4:00 PM Uwe Brauer  wrote:

> >>> "AB" == Alan B  writes:
>
>> Hello Uwe,
>> I'm using LibreOffice version 6.0.7.3.
>
>> "Version..." is the ninth item on the "File" menu.
>
> Ah thanks but it is only for odt format, not for docx. Which makes sense
>
> Uwe
>
> --
> 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
>
>

-- 
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] Strange question on Macro?? (in Spreadsheet)

[Michael Tiernan]

On 7/2/20 2:06 PM, Michael D. Setzer II wrote:

I've been trying to take a formula that calculates the difference between to
dates into years/months/days.


I'll ask if anyone has a macro or formulae that would do almost the same 
thing but allow it to be expressed further out to include "hours" and 
"minutes" I'd like to see it if possible.


I have a running log of incidents and it has two sets of columns.

First pair is "Start" and "End" of power event. That calculation would 
be nice if I could express it as:


### Days, ## Hours, ## Minutes

The second calculation, the one that I've been working on is the 
difference between the previous "End" and the new "Start" and that I do 
need to express "[# Year][# Months][## Days][## Hours] ## Minutes" where 
the values of '0' wouldn't be shown (but that's a luxury right now)


The 'datedif' function would work if it accepted the arguments for 
smaller measures such as "h"/"m"/"s".


Any suggestions?

--
  << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Behavior that seems ... inconsistant.

[Michael Tiernan]

This is being offered as a "data point" to the user interface development.
It may very well be "as expected" but it seemed odd so I thought I'd
mention it to see what other folks thought.

Here's a sequence of operations I'll call "Case 1":

I create a spreadsheet. Column A starts at a number (i.e. 100) and the rest
of the column is "=A1+1" and is filled down using the "Fill Down" menu
option. This gives us 100,101,102, etc. At the bottom of this new column, I
select the bottom entry, do a "Copy" to the clipboard then go down one cell
and "Paste" from the clipboard and the correct value goes in, formatting
and all.

So far, nothing unusual.

Now, "Case 2":

I take a second spreadsheet and put my starting number in A1 like before.
BUT, now I go to row 2 and select A2..A4 (three rows) and hit the button to
"Merge and Center Cells" and now I have a big cell in the second position.

I put the same formula in it "=A1+1" and it correctly becomes 101. I select
that cell again and do a "Copy" to the clipboard, go down one cell and am
now on A5. Note, it skipped to the /next/ cell after this enlarged cell. I
"Paste" and it creates a duplicate large cell and puts the adjusted formula
in it.

From what I can see, the operations are consistant.

But, now select ths enlarged cell at "A5" (which is A5, A6, A7) and pull
down to A8 and do a "Fill down" and it goes wonky. The cells A6, and A7
suddenly become filled with individual values and the "Merge" done
previously goes away.

It /seems/ (but I might be wrong) that the behavior should have been to
turn A8 and subsequent two more cells into one large cell via an implied
Merge and then copied the contents of the cell above it into it adjusting
the formula appropriately.

Thanks for everyone's time. I hope this is helpful in some way.

Version: 6.4.4.2
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein

-- 
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: Method advice requested.

[Michael Tiernan]

On 9/16/19 4:38 PM, Steve Edmonds wrote:

Hi Michael.
I use Fields for this purpose.


Interesting idea! Thanks for that!


--
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] Re: Method advice requested.

[Michael Tiernan]

And I *knew* not to put a picture in the message. :(

Duh. Here's a link to the intended graphic:

https://www.dropbox.com/s/0mb6v5w9z85d3rp/Untitled.png?dl=0


--
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] Method advice requested.

[Michael Tiernan]

I thought that this might be a good place to ask this question which in 
turn may help others.


I have a project that I'm working on and it occurred to me that there 
might be a smarter way to arrive at a solution.


First, the objective is to write a "night watchman's alarm manual" for a 
series of possible alarms that may be indicated on an annunciator panel.


I already broke up the document into a first section of "instructions, 
why we're doing this, etc."


The second section is, one page per item of the annunciator panel 
indicators. An example of an indicator would be something like 
"EMERGENCY GENERATOR ON" that's the heading at the top of the page. 
After that comes other stuff.


Now, here's the thing that I thought I'd ping this list about (I 
assume I'm not the only one to ever think of this.)


I have, on one of the first pages, a table of people as "Name, Title, 
Cell Phone, Home Phone" in alphabetical order. What I'd *like* to do is 
on subsequent pages, under a particular indicator is the section of "who 
to call" and I'd like to link specific people from that first list, to 
the annunciator incident.


So, my "Call List" is twenty names A-Z.

I'd like it if the "EMERGENCY GENERATOR ON" list to have a specific 
three from that big list done in a "linked" manner so that when the 
phone list is updated (Maybe I get a new cell number) then entire 
document doesn't need to be scrubbed for that information and the only 
thing that needs changing is the first entry in the master list.


Graphically, the connections would look something like this:

Is this sort of thing listed/discussed in any of the existing 
documentation? If so, can you provide pointers so I (and others) might 
learn?


Suggestions welcome.

Thanks for everyone's time!


--
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] Looking for input form example...

[Michael Tiernan]

Thanks for e everyone's response.

I'm going to look at the pointers you've provided.

What I'm convinced they want to do (I know, not right tool for the right
job) is have a form doc that can be opened on demand, filled in by the
operator then printed. I'm being led to believe that they don't even want
to save it to disk.

They're just looking (it seems) to provide a way of forcing the formatted
output of some fields. It's not even critical, it's an exercise for them
and, as much as it pains me I'm letting them run with it to let them learn
from it.

Thanks for everyone's time.

Best wishes to all for the new year!

-- 
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] Looking for input form example...

[Michael Tiernan]

I got asked to help someone solve a simple problem in a simple manner *and*
provide a steppingstone for someone to learn more about scripting LO.

Has anyone seen an example that is a form for taking simple input and then
outputs the form data in one of two manners, either as a simple text file
of the values of each field or as a "finished" or "print ready" page.

Has anyone seen anything on the LO web pages like this? Preference is for
an already existing example and not giving her a bunch of "go read webpage
__ and learn it from scratch" (I expect to be doing that for her/them.)

Thanks in advance for any pointers.
-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein
Sorry for the unedited top post. Client forces it.

-- 
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: Can LO do this?

[Michael Tiernan]

That answer was the perfect length.

Thank you very much for clearing that up for me!

-- 
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] Can LO do this?

[Michael Tiernan]

The question is not "Is there a better way to do this" because a working
(but klunky) solution exists. I'm asking about specific capabilities of LO
forms. Particularly with relation to printing a filled-in form.

I'd like to build a form with the usual assortment of data collection
fields /but/ I'd like a free text field/box in the middle that is
approximately the width of the document and, say 1/4 the page long.

(Now the detail/feature in question...)

I'd like this field to have the magic property that, should someone fill
this field with a lot of text, that when printed, it will fill the box as
described above (word wrapped would be much preferred) but the overflow
would come out on a subsequent page when printed.

It could be that the subsequent page repeats the entire content of that
field instead of "picking up where it left off". I'm not sure of this yet.

It might be that during the "filling in" the box shows a scroll bar and is
a window into the contents. Or it could be that during input the text box
is elastic and changes with the contents but when printed it doesn't change
the physical structure of the form. (And doesn't show any scroll bars.)

If the contents of the field is less than enough to fill the box on the
first page then this subsequent pages are supressed.

An example of use might be something like a repair form, comment form, or
organization intake form.

The important part being that the page layout hen printed isn't changed by
someone "long-winded" but the form accommodates it without a problem by
overflowing onto other pages.

Thanks to everyone for sharing their knowledge and ideas. (Not just about
this but in general.)

And thanks to all for your time.

-- 
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: Error messge interpretation...

[Michael Tiernan]

Wow! Where'd you find that referenced?

Yes, that fixed the fundamental problem allowing the form to work.

Thank you so very much!

-- 
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] Re: Error messge interpretation...

[Michael Tiernan]

I've been banging away at this problem and I don't think the problem is 
at the ODBC level but LOs attempts to generate SQL statements correctly.


I don't have the wherewithal to isolate the problem further than to have 
seen an error in the code (sqllite SQL request string) so I'm trying to 
simplify an example with a subform but that's about the best I can do at 
the moment.


Let's get this out of the way:
/*Before anyone states the obvious, the example I'm using is /NOT/ in 
need of rewriting, it is an example to prove that there's a problem. It 
is a vastly simplified version of a much larger form I was in the 
process of building.*/


In short. I simplified the problem so that it is one table that points 
to another and it's a one-to-many relationship. The example is a 
computer model pointing to installed models.


The LO SQL generated has a strange reference to a link in it that makes 
no sense from a SQL point of view.


As far as I can tell the error comes from LO. It is well within reason 
that the problem is caused by my incorrect design but it seems a stretch 
at this point.


Here's the SQL statement (reformatted) I got in the trace of the ODBC 
library call:

SELECT
  "SystemModels"."SystemModel" AS "SystemModel",
  "SystemModels"."SystemMfg" AS "SystemMfg",
  "SystemModels"."SystemMfgName" AS "SystemMfgName"
FROM
  "SystemModels" "SystemModels"
WHERE
  ( "SystemModels"."SystemModel" =:link_from_SystemModel )

That last line has the problem. :(

I'm going to do some tests to see if it really is my form that is 
causing it but that seems like a stretch.


Passing this on for general knowledge and in an effort to help others.

--
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] Re: Error messge interpretation...

[Michael Tiernan]

On 7/17/18 9:23 AM, Michael Tiernan wrote:

Anyone able to offer a breadcrumb for me to follow?

Thanks for the suggestions!

I think I've figured out that it's the ODBC setup.

I'm going to go back to the start to make sure I have it right.

--
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] Error messge interpretation...

[Michael Tiernan]

I have a fairly simple form that queries a DB.

I have a form and a subform.

I "linked" the two fields for the subform and when I execute the form, I 
get the error message:


SQL Status: HY000
Error code: 1

parameter marker count incorrect

I assume it should be obvious but I can't figure out where the problem is.

Anyone able to offer a breadcrumb for me to follow?

Thanks for everyone's time.

--
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] Locking guide lines in drawing.

[Michael Tiernan]

I went through a lot of work to set up a drawing page with lots of guide
lines but now that I have that done I can't figure out how to lock them in
place so that they don't accidentally get moved around. (Which happens a
lot.)

So my question is:
Can guides be locked down?
If so, where do I learn more about it?
(I have searched the help and docs but couldn't find any answers.)

Thanks for everyone's time.

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

[Michael Tiernan]

Sorry for the untrimmed quote and top post Gmail client forces it like
this.

I started to write a macro (and failed miserably) because I wanted to, in a
spreadsheet, enter today's date and time in a column (or two) that then
*never* updates again. All of my attempts at getting this to work (via
existing methods or by creating a macro) failed.

I simply had to accept that I had to enter it every time I I made an entry.

If I got it wrong l'd love to hear of a better way to do it.
-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein

On Mon, May 21, 2018, 4:49 AM Ricardo Berlasso  wrote:

> 2018-05-21 10:37 GMT+02:00 Peggy <33mar...@gmail.com>:
>
> > Years ago in Word Perfect there was a feature that allowed me to use a
> > shortcut key (even picking from a menu would be good) that inserted
> today's
> > date. Does Libre Writer have this feature?
> >
>
> Insert → Field → More fields → Document: under Type select Date and then if
> its fixed or should update any time you open the document. On the right
> column you can choose from different formats.
>
> Regards,
> Ricardo
>
>
>
> >
> > I've never written a macro and the couple of instructions I've seen look
> > complicated. If there is no feature for this, would their be a way to
> write
> > a macro for the tecnically challenged?
> >
> > Peggy
> >
> > --
> > 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/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
>
> --
> 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/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

[Michael Tiernan]

On 10/11/17 10:17 PM, Mike Adams wrote:

(*snip*)


First off, thanks to everyone who did respond! It has been very 
educational seeing different approaches to this same problem.


Mr Thurgood's reference to that online book is helpful to say the least. 
Thanks!


The approach Mr Faye offers gives me some insight into things I never 
tried. (New toys!)


The method Mr Adams offered seems to fit my needs the best (for this 
purpose) and I've tried it but find that somethings not quite right.


Here's a link to a screen shot of the calculations:
https://www.dropbox.com/s/b4x50sv2e3ycyxa/mytest-spreadsheet.jpg?dl=0

And this is the spreadsheet I built it from:
https://www.dropbox.com/s/mt84id1mg1qkh8h/mytest-spreadsheet.ods?dl=0

In short, I expected for 2017 that the first Tuesday (#3) of Jan should 
be 1/3/2017 but I get Sunday Jan/1/2017


I'm trying to suss it out but I thought I'd provide that response back.

Again, thanks everyone!

--
  << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan 
  Non Impediti Ratione Cogatationis

  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


--
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] Calculating the Nth weekday of a month.

[Michael Tiernan]

Instead of my breaking my neck trying to figure it out, I thought I'd ask.

Has anyone come up with a macro/formula/method for deriving the date 
(-mm-dd) of the Nth weekday of a month?


Example:
The second Tuesday of each month of 2017 would be:
2017-01-10
2017-02-14
2017-03-14
etc.

Thanks for your time in advance.

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

[Michael Tiernan]

I just want to double check the language used on the website.

Is the release 5.3.4 a "Stable" release or still in development? I don't 
see language on the website differentiating the "stable" releases verses 
the "prerelease" or "release candidate" flavors.


Any place I should have been looking for this answer?

Thanks for everyone's time.


--
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] Curious question about Styles

[Michael Tiernan]

I can create a document and thereby create a style for use in it.

I can then, after saving it, create another document and load those
styles in for use in this new document.

I assume I'm doing this wrong but it *seems* that I can create a List
type in that first document but it seems that I *cannot* load those
styles into the second document.

Am I missing something?

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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] Curious question about Styles

[Michael Tiernan]

On 3/30/15 1:10 PM, Barry Say wrote:
 In 'Styles and Formatting' (F11), the top left New Style button has
 a Load Styles option.
 The next window has a From File' option.
That's what I was doing and it works for everything BUT the list styles.
(Or so it seems.)

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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: LibreOffice Sort Bug ?

[Michael Tiernan]

On 3/28/15 6:20 AM, Tom Davies wrote:
 That is exactly the most perfect use-case that would be better in a
 database than in a spreadsheet. 
Not really since, while for me the prospect of using a DB back end isn't
daunting, for most it is.

Secondly, this is the perfect use-case where a DB back end can't be used
since the process of collecting the data for populating the SS was
organic and constantly changing until it arrived at the current state it
is in where yes, putting a backend on it would work very well BUT, I
can't then send a copy to my co-workers and ask them to use it without
their heads exploding.

One must consider the use-case when deciding how to use the tools available.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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: LibreOffice Sort Bug ?

[Michael Tiernan]

I meant to say, I'd be happy with the menu buttons performing the sort
using the last chosen options.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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: LibreOffice Sort Bug ?

[Michael Tiernan]

On 3/27/15 8:01 AM, Nino Novak wrote:
 1) This seems to be an old known problem (see e.g. [1])
It's older than that by a bit, I reported it back in 2012 I think. (I'd
have to hunt it down.) However, known isn't as accurate as we'd like
if people seem to find this as new on a semi-regular basis.
 2) I just tested 3.4.1 (LibO+AOO) - its already present there, so IMHO it's
 inherited from OOo
Also, from my perspective, I'm not accusing/blaming those working on
this for it having happened, it did, time to move on, now I'd like to
get it fixed.
 3) an easy Workaround exists (go over Data  Sort, choose proper column
 label Options)
A point I'd tried to make back then but got no where with was that
it's not an easy work-around when you have to do it multiple times
over and over in the process of using a collection of data means you
waste a *lot* of time during this work around which, when you have to
do it multiple times, stops being easy and becomes long and tedious.

I have a spreadsheet of ~450 entries, one for each machine in a data
center. Sometimes I have to sort it on the names, sometimes the serial
number, sometimes the rack location, etc. In my cases, when I was
building this list, to, EACH TIME, bring up the menu option, go and
click off *AGAIN* the button to choose the second page of the dialog,
click the label button, then click Ok *AGAIN* wasted a lot of time
and introduced new places for me to trigger an error in the process when
really, assuming the minimum choices was the correct approach.

Maybe that's what we need, a button to set the sort options, just once
to smart or standard meaning don't *ass*u*me* anything when trying
to decide what to do with the data.
 So IMO the next questions are,
 - how important is this bug?
 - is there general agreement about a default behavior / column label
 recognition algorithm?

 Then the bug could be pushed to a higher prio / dev visibility.
The philosophical arguments I'd like to make is that using the
assumption of lowest common expectation (for lack of a better term) is
that you assume the least number of optional choices that you can unless
explicitly told otherwise.

As someone previously stated, if I select/highlight a number of words in
a word processor to effect change on them such as bold/italic/underline,
I expect the operation to be done in the simplest of terms, I don't want
you to avoid doing capital letters because that's an option somewhere I
didn't expect.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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] Request for resoure suggestions.

[Michael Tiernan]

I'm working on improving my formatting skills. I'm using a ~10pg
document as my test.

My first problem is to figure out a specific part of styles. I can
format the document to have a heading (specifically heading 2) at the
start of each section. Looks nice. Copied the existing style, made a few
mods, very pleased.

NOW, I want to try to add a number to each section and I'm having
trouble understanding the correct route for this.

I have already gotten:

 John
 George
 Paul
 Ringo


and it worked fine. Now I want to change the style to be like:

   I John
  II George
 III Paul
  IV Ringo

So, I can't tell if I should be trying to modify the Heading 2 style
or if I should be trying to add a List format to the mix.

I'm looking for suggestions on where I can read about the uses of each
and learn the differences.

Thanks for any suggestion!

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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] Request for resoure suggestions.

[Michael Tiernan]

On 3/27/15 6:03 AM, Regina Henschel wrote:
 You are looking for a numbering of headings. For that purpose List
 is always wrong.
(*WHEW*) i feel better. :)

Thanks for the answer.
 Do you have already download the tutorials? 
Got them now and am going to get started on them
 If you are not very advanced, you should not try to do it by changing
 the style. The way to go is via menu Tools and item Outline numbering. 
This is helpful. Because I've not been intimidated by screwing with
styles, I'm inclined to ask what is it about changing a style that is so
much harder? (Just for my own future reference.)

And thank you to everyone for the answers. I'm opening all the links and
sucking in what I can.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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] LibreOffice Sort Bug ?

[Michael Tiernan]

On 3/25/15 8:12 PM, Tim Lloyd wrote:
 at this point in the game this particular menu option can not be changed.
See, now *THAT* is an answer we can live with. Thank you!

I hate it but now I know what the problem (behind the scenes) is.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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] LibreOffice Sort Bug ?

[Michael Tiernan]

On 3/25/15 6:53 PM, Wade Smart wrote:
 I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working.
When I reported it, I provided a great deal of information about it and
was told Not a bug and works for me by those who have the power to
close bugs.

My argument was/is that if you use the sort arrows (as you have done
here) then you're asking/telling LO to sort the selected rows with no
options.

Instead it was deemed correct that instead, LO assumes the first cell
found is used as a label regardless of any other settings.

This feature (*cough*) cost me a number of hours of work to get around
and avoid.

The argument is that since you can use the Sort menu option and change
this behavior *for each sort occurrence* then there's a work around for
the feature and we should be happy with that.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


-- 
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] Question about a possible bug in writer.

[Michael Tiernan]

On 3/21/15 7:51 AM, Virgil Arrington wrote:
 I just tried recreating this problem with my system, and all worked well.

 I'm using LO 4.3.6.2 on Ubuntu 14.04.
Thanks to all for the replies.

Since no one jumped up yelling that they've seen it I'll assume it's
my fault/problem.

Let me recreate a test document for it and see what happens.

Short answers, on Mac OSX.6.8 (No, can't upgrade yet.)
LO  Version: 4.2.8.2  Build ID: 48d50dbfc06349262c9d50868e5c1f630a573eb

Let me try again and I'll update the list with the results.

-- 
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] Question about a possible bug in writer.

[Michael Tiernan]

I'm asking here before I go and hunt down if there's a bug.

I've done these steps. Very simple an unsophisticated process.
1) I create a new writer document.
2) I paste into it a load of plain text.
3) Go to first page. Create a footer with page of page number
4) Go to last page, the footer says 8 of 8.
5) Now, begin to format text.

Some of the changes:
A) Bold and Center a line of text.
B) Select some text and created bulleted list.

At this point the page counts are correct. NOW, I adjust the right
margin of the bulleted text and the page number /following/ the margin
change gets reset.

Has anyone seen this?
Anyone have any suggestions to look into before I try filing a bug report?
Thoughts?

Thanks for everyone's time.

-- 
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] PDF Forms - Trying to /not/ reinvent the wheel.

[Michael Tiernan]

I've done a lot of searching including the list archived and I've found
no answers yet.

I've been able to take a document and turn it into a form and export it
as a PDF form for filling in.

I'm looking to find out if anyone's (successfully I hope) created a PDF
form this way which *includes a little bit of javascript (or any other
script) which allows for some minor field manipulations.*

I just want to make sure I'm not accelerating towards a brick wall. ;)

My objective is simple. There's a lot of examples that already exist
that show how to create a date field in a form that is updated/filled in
when the PDF is opened. I'd like to get that field filled in using a
specific format and then have it validated.

All of the examples are how to do this using one of the Adobe tools to
put some javascript into place to make this work.

I'd like to find out if that javascript and field relationship can be
created from LibreOffice.

Thanks for everyone's time and bandwidth.

Any guidance is welcome.

-- 
   MCT  Michael C Tiernan. http://www.linkedin.com/in/mtiernan
  Non Impediti Ratione Cogatationis
  Women and cats will do as they please, and men and dogs
   should relax and get used to the idea. -Robert A. Heinlein


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