[libreoffice-users] Question about a possible bug in writer.

2015-03-20 Thread 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

Re: [libreoffice-users] Question about a possible bug in writer.

2015-03-21 Thread 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

[libreoffice-users] PDF Forms - Trying to /not/ reinvent the wheel.

2015-03-06 Thread 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

Re: [libreoffice-users] LibreOffice Sort Bug ?

2015-03-26 Thread 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.

Re: [libreoffice-users] LibreOffice Sort Bug ?

2015-03-25 Thread 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

[libreoffice-users] Curious question about Styles

2015-03-30 Thread 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

Re: [libreoffice-users] Curious question about Styles

2015-03-30 Thread 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.

[libreoffice-users] Request for resoure suggestions.

2015-03-27 Thread 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

Re: [libreoffice-users] Request for resoure suggestions.

2015-03-27 Thread 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

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread 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

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread 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

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread 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.

[libreoffice-users] Releases

2017-07-26 Thread 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

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

2017-09-28 Thread 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

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

2017-10-12 Thread 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

Re: [libreoffice-users] Insert current date

2018-05-21 Thread 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

[libreoffice-users] Locking guide lines in drawing.

2018-06-26 Thread 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

[libreoffice-users] Re: Error messge interpretation...

2018-07-25 Thread 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

Re: [libreoffice-users] Re: Error messge interpretation...

2018-07-25 Thread 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

[libreoffice-users] Re: Error messge interpretation...

2018-07-17 Thread 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

[libreoffice-users] Error messge interpretation...

2018-07-17 Thread 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

[libreoffice-users] Can LO do this?

2018-09-03 Thread 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/

Re: [libreoffice-users] Re: Can LO do this?

2018-09-03 Thread 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:

[libreoffice-users] Looking for input form example...

2018-12-29 Thread 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

Re: [libreoffice-users] Looking for input form example...

2018-12-30 Thread 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

Re: [libreoffice-users] Re: Method advice requested.

2019-09-16 Thread 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 +

[libreoffice-users] Method advice requested.

2019-09-16 Thread 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

[libreoffice-users] Re: Method advice requested.

2019-09-16 Thread 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?

Re: [libreoffice-users] Strange question on Macro?? (in Spreadsheet)

2020-07-07 Thread 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"

[libreoffice-users] Behavior that seems ... inconsistant.

2020-06-08 Thread 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

Re: [libreoffice-users] Re: version control of sorts: it is gone?

2020-07-22 Thread 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

[libreoffice-users] Crash creating DB from Spreadsheet.

2021-04-02 Thread 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

[libreoffice-users] Re: Crash creating DB from Spreadsheet.

2021-04-02 Thread 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/mt

Re: [libreoffice-users] Crash creating DB from Spreadsheet.

2021-04-02 Thread 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:

[libreoffice-users] Better approach for formatting

2021-08-09 Thread 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

[libreoffice-users] Proper forum for feedback.

2022-04-06 Thread 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.

[libreoffice-users] Macros in spreadsheets

2022-12-23 Thread 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

Re: [libreoffice-users] Macros in spreadsheets

2023-01-02 Thread 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

[libreoffice-users] Quirky behavior report....

2023-04-10 Thread 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.

[libreoffice-users] Actual bug report.

2023-04-10 Thread 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:

[libreoffice-users] Master document and styles.

2024-01-14 Thread 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

Re: [libreoffice-users] Master document, internal link between documents and pdf

2024-01-14 Thread 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

[libreoffice-users] Re: Master document and styles.

2024-01-31 Thread 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

Re: [libreoffice-users] Master document and styles.

2024-01-31 Thread 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 > > s

[libreoffice-users] Re: Master document and styles.

2024-02-23 Thread 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