Re: [libreoffice-users] Help with conditional formatting (Calc)

2024-05-25 Thread Paul Goyette
On Sat, 25 May 2024, Rob Jasper wrote: Paul, Yes, you should use a formula as condition. To use a formula as condition: Go to Format -> Conditional -> condition -> More rules -> formula: $C$3=$Sheet1.$A$14 And use A5:J10 as range (if you select the range before defining the

[libreoffice-users] Help with conditional formatting (Calc)

2024-05-25 Thread Paul Goyette
.$row$column", apply format to the entire range a-N:j-N Is this possible? +-+--+--+ | Paul Goyette (.sig) | PGP Key fingerprint: | E-mail addresses:| | (Retired) | 1B11 1849 721C 56C8 F63A | p...@wh

[libreoffice-users] problem

2024-04-15 Thread Paul Moore
hi what is going on with the updates as all my documents that are listed just come up with lines and nothing else and i cant seem to get them back. i can see them on the recent documents but that's all. hopefully something can be done thanking you Paul -- To unsubscribe e-mail to: users

Re: [libreoffice-users] Printer not showing in LO print dialog

2024-04-02 Thread Paul D. Mirowsky
I have not noticed scroll bars on certain occasion that block other printers from being seen. I drive myself crazy, but it is what it is. On 3/28/24 11:35, Eric Beversluis wrote: When I have a LO Writer document open and tell it to print, the dialog only shows the Brother MFC printer and not

Re: [libreoffice-users] Labels created in Writer shifts downward while printed

2024-03-25 Thread Paul D. Mirowsky
A shat in the dark... * A blank or unseen line at last table row cell(s) * Incorrect metric vs decimal inch calculation forcing a mismatch between software and printer * header or footer is not zero in length * Select all and right click "clear direct formatting" Hope this helps. On

[libreoffice-users] Need help with getting invoice numbers on my invoices

2023-11-30 Thread Paul
Can you help please? Thank you. Paul Hegele 604-618-7684 www.Alphaelectricvancouver.com -- 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

[libreoffice-users] Address from Evolution Address Book defined but not displayed

2023-09-30 Thread Paul D. Mirowsky
Version: 7.5.7.1 (X86_64) / LibreOffice Community Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded When using: Templates: Address Book Assignment from the Book Source...> menus,

Re: [libreoffice-users] LO version 7.6 shows 7.5.5.2

2023-09-28 Thread Paul D. Mirowsky
Logout and then login. Check menu for two installed versions. I am using Ubuntu 22.04.3 LTS - Gnome 42.9 I always install from LibreOffice direct download of package which leaves the old version listed in the menu system and installed. I use synaptic to remove the old version. Logout, login

Re: [libreoffice-users] Address Book Conundrum

2023-09-11 Thread Paul D. Mirowsky
I confirm that Base was _always_ installed with the rest of the suite for me. Do you have LibreOffice Start Center with your installation? On 9/11/23 13:45, Robert Großkopf wrote: Hi Peter, Am 10.09.23 um 13:07 schrieb Peter Hillier-Brook: For donkey's years I've been using an address book

Re: [libreoffice-users] Address Book Conundrum

2023-09-11 Thread Paul D. Mirowsky
Not a 100% sure, but try this. Open a Writer document Left click on Check "Available Databases" column on right. If not there, try button below to reconnect to Calc spreadsheet. Hope this helps. On 9/10/23 07:07, Peter Hillier-Brook wrote: For donkey's years I've been using an address

Re: [libreoffice-users] problems on Ubuntu

2023-09-02 Thread Paul D. Mirowsky
When opening a Calc spreadsheet, is the name of your file at the very top of the window? Example: BlahBlahBlah.ods - LibreOffice Calc On 9/2/23 10:43, Rogier F. van Vlissingen wrote: This year, I switched to Ubuntu, and I am having a problem with the opening of spreadsheet and other Libre

Re: [libreoffice-users] Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive or similar online / cloud drives ?

2023-07-26 Thread Paul D. Mirowsky
As a side note: Ubuntu 22.04.2 LTS can be connected to Google Drive via gmail account. Using Files (the gnome default), it adds my account as a folder location on the side panel and works very well. On 7/26/23 00:09, Hastham S wrote: dear allGood day Is anyone using Libreoffice SYNCHED to

Re: [libreoffice-users] weirdness in save dialogue box

2023-07-24 Thread Paul D. Mirowsky
Just out of curiosity, at any time did you receive a "Confirm File Format" window and unchecked the "Ask when not saving in ODF or default format" dialog? An error in this function might react oddly, even though unlikely. On 7/24/23 11:21, Mike Scott wrote: On 22/07/2023 19:03, Steve

Re: [libreoffice-users] LO Draw Newbie

2023-07-03 Thread Paul D. Mirowsky
Hello Vince If your needs go beyond basic 2D drafting, I would suggest looking at SweetHome3D. *Sweet Home 3D* is a free interior design application which helps you draw the plan of your house, arrange furniture on it and visit the results in 3D. https://www.sweethome3d.com/ Hope this

Re: [libreoffice-users] How to select the screen that the Impress presenter console displays on?

2023-04-24 Thread Paul D. Mirowsky
Did not reply to list. My apologies. I am assuming you are running Windows in a VM. This may help...Setting up Multiple Monitors in a KVM QEMU VM: Updated 2022 https://www.youtube.com/watch?v=63i1-sDIips On 4/20/23 21:31, Thomas Cameron wrote: Howdy - I'm a technical trainer. I usually

Re: [libreoffice-users] Help with Impress

2022-11-16 Thread Paul D. Mirowsky
By any chance, did you start by importing a Power Point? On 11/11/22 12:34, Gregory Forster wrote: Hi     Recently, I volunteered to teach computer classes at a senior center.  I'm teaching Excel, Word, Power Point, etc. I'm trying to promote LibreOffice.  I use LibreOffice at home. 

Re: [libreoffice-users] hardening libreoffice 7.0.4 - Secure Installation

2022-11-04 Thread Paul D. Mirowsky
/Common_Vulnerabilities_and_Exposures         and https://www.cve.org/ See what is required by your and other governmental offices. Visit: https://www.gsa.gov/technology/government-it-initiatives/cybersecurity/cybersecurity-programs-policy         and https://www.cisa.gov/cdm Try to enjoy your pursuit. Paul

Re: [libreoffice-users] Issue with automating a simple process.

2022-05-04 Thread Paul D. Mirowsky
I apologize, but I do not know how Calc handles this function, but the logic is... If A5 greater then zero, then end process Hope this helps. On 5/3/22 04:33, Michael D. Setzer II wrote: Have a shell script that creates 2 csv files with data that changes each quarter of year. Script

Re: [libreoffice-users] Cannot save file

2022-03-03 Thread Paul D. Mirowsky
It may be that Notepad may force a fix in Windows. Found this... Then I went back to one of the Notepad-windows, and attempted to copy a text string into a Calc cell. WITH success (today). Now as an extra measurement, I attempted to copy a bit internally and from external, but this time from

Re: [libreoffice-users] Cannot save file

2022-03-03 Thread Paul D. Mirowsky
Are you able to create and save an empty .odt? If so, does copying to it after saving empty .odt work? On 3/3/22 15:01, Paul D. Mirowsky wrote: Have you tried?... [Right click][Left click: Paste Special; Unformatted Text] Before pasting do [Right click][Left click: Clear Direct

Re: [libreoffice-users] Cannot save file

2022-03-03 Thread Paul D. Mirowsky
Have you tried?... [Right click][Left click: Paste Special; Unformatted Text] Before pasting do [Right click][Left click: Clear Direct Formatting] Is it possible that the source file has locked text? On 3/2/22 03:14, Thomas Blasejewicz wrote: Good afternoon Another incomprehensible

Re: [libreoffice-users] missing printer formats

2022-02-17 Thread Paul D. Mirowsky
What operating system does a "Curtains 10" use? Then see Epson Search Result for XP-630 current drivers at: https://download.ebz.epson.net/dsc/search/01/search/searchModule Hope this helps. On 2/16/22 15:37, black mountain wrote: LO Users Ahoy: I used LO4 on a Curtains 7 machine for some

Re: [libreoffice-users] printing pages in reverse order not possible in LO 7.2.5.2.0+

2022-02-16 Thread Paul D. Mirowsky
Ken, I have been unable to recreate your issue. Version: 7.3.0.3 / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 4; OS: Linux 5.16; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Here is a capture of the print dialog

Re: [libreoffice-users] Libreoffice impress presentation - metropolis - exported as PDF, doesn't display correctly on some devi

2021-05-17 Thread Paul D. Mirowsky
Shot in the dark. You can probably assume those fonts that currently work on Iphone with Metropolis are available by default. Find out the fonts that aren't working and substitute with other default fonts that are used on Iphone. Use only those font inside Metropolis. Hope this helps.

Re: [libreoffice-users] Write Closed but Windows 10 won't provide safe to remove flash drive

2021-03-06 Thread Paul D. Mirowsky
1. Separately open a window of the folder showing the document you are opening. Make a backup copy from Windows. Once your document is open, a temporary file should be created in that folder. When closing the document, the temporary document should disappear. If the temporary document

Re: [libreoffice-users] Language setting in Calc

2021-02-19 Thread Paul D. Mirowsky
This may be an answer. Choose Tools - Options. Go to Language Settings - Languages. Under Default languages for documents, select the document language for all newly created documents. If you mark For the current document only, your choice will only apply to the current document.

Re: [libreoffice-users] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

2021-01-29 Thread Paul D. Mirowsky
An engineer, a statistician, and a physicist are out hunting. They spot a buck, and each take turns to try and bag it. The physicist goes first. He pulls out his lab book and quickly calculates the trajectory of the bullet, assuming it is a perfect sphere in a vacuum. The bullet falls *20m*

Re: [libreoffice-users] Epson XP-820 paper size setup

2020-12-17 Thread Paul D. Mirowsky
oes work. Note: Printer min/max sizes may not be available to do what you want as defined by manufacturer. Hope this helps. Paul On 12/15/20 6:52 AM, Dave Howorth wrote: On Mon, 14 Dec 2020 13:49:03 -0500 "Paul D. Mirowsky" wrote: Which operating system are you using? On 12/9/20 1:13 P

Re: [libreoffice-users] Epson XP-820 paper size setup

2020-12-14 Thread Paul D. Mirowsky
Which operating system are you using? On 12/9/20 1:13 PM, Gary Dale wrote: I'm running Debian/Bullseye and the printer is attached via USB cable. My LibreOffice version is 7.0.3.1. My CUPS version is 2.3.3op1. The printer is using the Epson ESC/P-R driver. The printer works fine but one

Re: [libreoffice-users] Copying data from Calc to Base...

2020-07-23 Thread Paul D. Mirowsky
When in Calc, be sure the date fields are actually defined as DATE type and -MM-DD format before copy/paste. Hope this helps. On 7/22/20 11:33 PM, zed wrote: Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate I am trying to copy and paste a LibreOffice Calc file from that program

Re: [libreoffice-users] Presentation - video record

2020-06-18 Thread Paul D. Mirowsky
Suggest using screen recorder software. * 8 Best Screen Recorders for Windows 10 – Free & Paid (2019 rev.) o https://atomisystems.com/screencasting/record-screen-windows-10/ * 9 Best Screen Recorders For Linux o https://itsfoss.com/best-linux-screen-recorders/ * How to record the

Re: [libreoffice-users] Re: Writer Comments Have Faintly Printed Indicator Lines

2020-06-04 Thread Paul D. Mirowsky
I poked around a little more, but could not find any more references. There has to be some type of color description field in a file for it to show as it is. It may take a bit of effort, but if you can change that, at least it will be more obvious. You may want to submit a suggestion that

Re: [libreoffice-users] Writer Comments Have Faintly Printed Indicator Lines

2020-06-01 Thread Paul D. Mirowsky
LIbreOffice Version: 6.3.5.2 Try...     Create a comment from     When cursor is inside comment then: I haven't done this, but hopefully it will effect the dashed line as well as text font. Paul On 5/29/20 10:43 PM, seedpress wrote: I’m having an aggravating problem with using

Re: [libreoffice-users] Open .csv by specifying column widths on command line

2020-04-08 Thread Paul D. Mirowsky
...@yahoo.it wrote: Hi Paul, I've tried to create an ods file to use as template as suggested. I've set my intended column widths in it, enabled line wrapping, then I saved it. Then I ran: soffice -n template.ods --infilter=CSV:44,34,UTF8 myfile.csv Unfortunately what actually happens

Re: [libreoffice-users] Open .csv by specifying column widths on command line

2020-04-08 Thread Paul D. Mirowsky
There may be another answer. I import semi-colon (;) separated data into Writer, recorded Macro filters and tied them together. In my case, I made a Menu which reformat the data fields. See the example below from URL:

Re: [libreoffice-users] Problem with print dialogue

2020-04-08 Thread Paul D. Mirowsky
This may work. Wayland solution Since Ubuntu 18.04, Wayland is the default display protocol. To enable scaling: * Enable fractional Scaling experimental-feature: |gsettings set org.gnome.mutter

Re: [libreoffice-users] Open .csv by specifying column widths on command line

2020-04-08 Thread Paul D. Mirowsky
Would this work in your command line mixed with Brians' idea? -n {filename} Creates a new document using *{filename}* as a template. From: https://help.libreoffice.org/Common/Starting_the_Software_With_Parameters On 4/7/20 6:58 AM, edonkey2001-libreoff...@yahoo.it wrote: Thanks Brian for

Re: [libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Paul D. Mirowsky
I hope that once you have HSQLDB working, you will transfer eventually migrate to Firebird. It has been far superior and and stable once I worked out the bugs. https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

Re: [libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Paul D. Mirowsky
table that has a correct data type and copy from Table-0 to Table-1. Hope this helps Paul Also, it is my understanding that there is currently still a limitation of 64Kb for the total insert length of any transaction, meaning that you have to be especially wary of the number, and length of any

Re: [libreoffice-users] Libreoffice office cloud version

2020-03-10 Thread Paul D. Mirowsky
You may want to look here: https://nextcloud.com/ On 3/6/20 12:51 PM, sterbl...@tutanota.com wrote: Rather than saying this is a question. This is more like expressing what I am looking for, after searching online. My search result doesn't find anything similar, so ask it here (and

[libreoffice-users] Re: Libre Writer Help download + Margin adjustment

2020-03-02 Thread Paul D. Mirowsky
t;) unless that is type of download you want. On 3/1/20 2:37 PM, charles meyer wrote: Hi Paul, I hope this email fiend you well. I downloaded the most recent version of Libre Office (.6.2. something ) running on Windows 10 Pro on a laptop. I need to download the help file which works with

Re: [libreoffice-users] Writer will not print envelopes

2020-02-06 Thread Paul D. Mirowsky
Long shot. 1. There is a possibility that printer dimension don't actually match the definition of envelope. This might causing 1 page print on 2 page envelope. This might result in 1st page blank and 2nd page with address do to width incorrectly defined. Does "Print Preview" show 1

Re: [libreoffice-users] RE: Using Libre Writer - with hardware questions

2020-01-27 Thread Paul D. Mirowsky
://askubuntu.com/questions/591488/how-do-i-run-memtest86 Go to a different computer and look for search engine listings of your laptop model having similar problems.  Youtube videos can tell you a lot about what may be happening. Google "YouTube Toshiba vertical banding" Hope this he

Re: [libreoffice-users] Using Libre Writer - with hardware questions

2020-01-24 Thread Paul D. Mirowsky
Submit your issue here. This forum has an amazing amount of knowledge and if they don't know, they will give you guidance. On 1/24/2020 3:09 PM, charles meyer wrote: I like using Libre Writer but have been confounded with a hardware issue with my laptop. Would anyone please suggest a

Re: [libreoffice-users] excel 3d maps tour workalike?

2019-11-14 Thread Paul D. Mirowsky
76585/will-calc-be-able-to-import-dat-from-kml-file-containing-a-collection-of-points-of-interest-from-google-mymaps/ Hope this helps. Paul On 11/9/2019 3:55 PM, Dave Stevens wrote: Excel's 3D map tour -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.

Re: [libreoffice-users] Transparency issue saving to .doc/docx

2019-11-05 Thread Paul D. Mirowsky
This may or may not work. You may want to look into creating a SVG incorporating underlying text with overlay images. Suggest you look at Inkscape for creating a _plain_ (not Inkscape) SVG.  https://inkscape.org/ On 11/5/2019 4:31 PM, Tim-L wrote: The problem is it gets up when I save

Re: [libreoffice-users] LibreOffce 6.2.4 won't start after upgrade on Debian 9.9

2019-06-24 Thread Paul D. Mirowsky
Try using the program selector icon.  See there is an icon there that will complete the loading of the program. Although the LibreOffice Icon may still exist, direct installation may not be updated to 'start' the program from that icon. The program selector is direct. Hope this helps. Paul

[libreoffice-users] Base Firebird reserved words

2019-05-22 Thread Paul D. Mirowsky
pening and/or using a query. Can someone confirm that Firebird keywords should never be used as field names. Thanks Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guid

Re: [libreoffice-users] No corresponding column type could be found for column 'ID'.

2019-05-16 Thread Paul D. Mirowsky
Hello Robert See below. Hello Robert See below. On 5/16/2019 2:53 PM, Robert Großkopf wrote: Hi Paul, When I want to append a Table from database one to database two, I get the message "No corresponding column type could be found for column 'ID'." The field "ID" fro

[libreoffice-users] No corresponding column type could be found for column 'ID'.

2019-05-16 Thread Paul D. Mirowsky
ding column type could be found for column 'ID'." It does not let me skip this warning and move to the next screen where I would usually uncheck the field and allow automatic key to be filled in second database. Any suggestions welcome. Paul -- To unsubscribe e-mail to: users+unsubscr...@global.

Re: [libreoffice-users] LO Basic: DialogLibraries contains no elements

2019-05-06 Thread Paul D. Mirowsky
Shot in the dark. If I understand it correctly, this function is case sensitive. Check spelling. Hope this helps On 5/5/2019 12:19 PM, Pusteblumi wrote: /DialogLibraries.LoadLibrary ("OOoLilyPond")/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Page number messed up in LO Writer 6.2.1/2 and 6.1.5

2019-04-10 Thread Paul D. Mirowsky
You may have "Field Names" under the " View" menu activated. Click it or Ctl+F9 to deactivate. Hope this helps. On 4/10/2019 6:08 PM, MR ZenWiz wrote: I've been LO Writer for a long time for, among other things, a few novels I am writing. Just now I noticed that the page number field in the

Re: [libreoffice-users] Re: Draw changes font when opening pdf text file.

2019-03-18 Thread Paul D. Mirowsky
I am using "Version: 6.1.5.2 (x64)". Supposedly, you can force font substitution. I have not tried it. Choose *Tools - Options'* /- LibreOffice - Fonts'   From: https://help.libreoffice.org/Common/Fonts/ You must click in the box next to "Apply replacement table" before you can

Re: [libreoffice-users] Impress window position

2019-03-14 Thread Paul D. Mirowsky
--- Original Message - From: Paul D. Mirowsky (p_mirow...@bentaxna.com) Date: 14/03/19 14:22 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Impress window position When you drag Impress over to the screen on right, does it remain there after clicking on OpenBoard? On 3/12/2

Re: [libreoffice-users] Impress window position

2019-03-14 Thread Paul D. Mirowsky
When you drag Impress over to the screen on right, does it remain there after clicking on OpenBoard? On 3/12/2019 4:22 AM, malcolm moore wrote: Sorry a bit sparce on information... It's openSUSE Tumbleweed KDE Plasma The screen is extended to the right Mal - Original Message -

Re: [libreoffice-users] Help files bad link

2019-03-06 Thread Paul D. Mirowsky
-0500 (Eastern Standard Time), Paul D. Mirowsky wrote: Sort of.     C:\Program Files (x86)\LibreOffice 4     C:\Program Files (x86)\LibreOffice 5         Are both empty. C:\Program Files\LibreOffice\help         Is not and "C:\Program Files\LibreOffice\help\en-US\text\swriter"

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread Paul D. Mirowsky
I checked this and all fields seem appropriate. I used the [Reset] button, but still results in Browser at "file:///C:/Users/paul/AppData/Local/Temp/lu109605km9jx.tmp/NewHelp1.html". Paul On 3/5/2019 10:46 AM, Graham Luffrum wrote: Some years ago I had the same problem as

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread Paul D. Mirowsky
sults on Firefox URL "file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html" and displays correctly in browser. Paul On 3/5/2019 10:36 AM, Tanstaafl wrote: Is it possible you have mix of 64 bit application and 32 bit Help (or vice versa)? On Tue Mar 05 2

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread Paul D. Mirowsky
Have now tried... [Toolbars]        Search "Help" which results in Get Help Online Helplines While Moving LibreOffice Help Selecting "LibreOffice Help" Selecting {Defaults} and said {Yes}. Results in Firefox tab with text "Help Page Redirection"

[libreoffice-users] Help files bad link

2019-03-01 Thread Paul D. Mirowsky
I have removed and re-installed "LibreOffice_6.1.5_Win_x64_helppack_en-US.msi". But when I use , it sends me to my browser at "file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html". Any ideas on how to fix this. Help does not show up in "Opti

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-17 Thread Paul D. Mirowsky
                        caused by                             'isc_dsql_prepare' In effect, in either edit mode it works correctly. The saved query always fails. Hope this helps Paul On 1/17/2019 12:58 AM, Robert Großkopf wrote: Hi Paul, Ok, things are narrowing down on this issue. I have a Qu

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Paul D. Mirowsky
the error when you double clicked on it, in design view and Run it and it works? Is that what you are saying? Thanks On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky wrote: Ok, things are narrowing down on this issue. I have a Query Design view in which I have a field Series set to 134. I remove

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Paul D. Mirowsky
SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION Thanks Paul On 1/16/2019 11:42 AM, Drew Jensen wrote: Howdy, Yes, I have a suggestion - there is a property in the Base file which is incorrectly set during the Migration Assistant run and must be fixed. The error message

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Paul D. Mirowsky
it. Result in: Error code: 1 firebird_sdbc error *Dynamic SQL Error *SQL error code = -104 *Invalid usage of boolean expression caused by 'isc_dsql_prepare' It appears that the run function is adding an operation that is not in Query Design view. Any suggestions? Thanks Paul On 1/15/2019 6:19 PM

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Paul D. Mirowsky
rd_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare' I'm sure it's buried somewhere. Any hints anyone? I am by no means an SQL expert, Thank you for being patient. Paul | On 1/16/2019 2:27 AM, Alexander Thurgood wrote: Le 16/01

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-15 Thread Paul D. Mirowsky
would not think this a possible error. Am I correct in this assumption? Thanks Paul On 1/15/2019 11:27 AM, Alexander Thurgood wrote: Le 15/01/2019 à 16:14, Paul D. Mirowsky a écrit : Hi Paul, SELECT "Equipment"."ID", "Equipment"."P_Model", "Equi

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-15 Thread Paul D. Mirowsky
removed them from the query. The error still occurs. I am taking this to mean that there is a boolean comparison happening that is not in the SQL generated by Base. Is this possible? Thanks Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-15 Thread Paul D. Mirowsky
See below... On 1/15/2019 10:37 AM, Robert Großkopf wrote: Hi Paul, Have a look at "Ions-IM"."Select" = TRUE Did the migrationtool set the field "Select" to a BOOLEAN-field? Yes "Equipment"."Series" = 134 Did the migrationtool impor

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-15 Thread Paul D. Mirowsky
, "Amps"."Reading" "Am-Reading", "Amps"."Type" "Am-Type", "Amps"."Series", "Amps"."Setting" FROM "Ions-IM", "Equipment", "Volts-High", "Amps" WHERE "

[libreoffice-users] Base/Firebird Queries broken

2019-01-14 Thread Paul D. Mirowsky
. Any hint as to where I'm going wrong. Thanks Paul -- 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

Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-23 Thread Paul D. Mirowsky
. https://www.ghostscript.com/ https://github.com/apple/cups If anybody knows, please reply to correct the above statements. Hope this helps Paul On 10/22/2018 11:52 PM, Frédéric wrote: Did you try saving as pdf in both linux and windows to see if there is any difference? It is similar

Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-22 Thread Paul D. Mirowsky
Did you try saving as pdf in both linux and windows to see if there is any difference? On 10/22/2018 5:07 PM, Frédéric wrote: Which version and what software are you using. Draw, Calc, Writer? It's in Calc, version 6.0 on Linux, 5.3 on Windows. -- To unsubscribe e-mail to:

Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong

2018-10-22 Thread Paul D. Mirowsky
Which version and what software are you using. Draw, Calc, Writer? On 10/21/2018 1:56 PM, Frédéric wrote: Hi, My graphs move vertically when I save my sheets to pdf. I spent hours searching why but cannot find any clue. All properties look fine (FrameRect, OriginalSize, BoundRect,

Re: [libreoffice-users] side by side tables

2018-09-27 Thread Paul D. Mirowsky
If I understand your question correctly Turn on and . This will make it easier to see what's happening. Read https://ask.libreoffice.org/en/question/60604/create-a-page-starting-with-2-columns-and-finishing-with-1-column/ This will result in even columns. Then in each column after

Re: [libreoffice-users] Issues with macro recorder??

2018-09-05 Thread Paul D. Mirowsky
I have only been successful at using keyboard commands. Sometimes interpretations in the code require correction. In general, it usually works though. On 9/4/2018 8:08 AM, Michael D. Setzer II wrote: Wondering if there is any documentation on things that don't work with the recorder. Just

Re: [libreoffice-users] Spell checking etc does not work

2018-08-28 Thread Paul D. Mirowsky
On 8/24/2018 1:02 PM, Ken Heard wrote: My OS is Debian Stretch.  My version of LibreOffice is 1:5.2.7-1+deb9u4 from the stretch-backports depository. The installed version of hunspell GB has the same as the version number as LO. The US version is 20070829-7. I can open the Spelling window

Re: [libreoffice-users] After upgrading to libreoffice 6.0.6, unable to save files to samba shares

2018-08-10 Thread Paul D. Mirowsky
You might try creating a odt on C drive.  Copy to your server and then see if it opens. Also, in Windows, check the permissions comparing LibreOffice 5 to 6 created documents. I assume that since 5 worked on the server, the linux permissions are correct. Hope this helps On 8/9/2018 5:02 PM,

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Paul D. Mirowsky
I don't know what happened, but I tried it in Chrome, Explorer and Firefox and had similar loading problems. Restarted machine and Firefox is working now. Probably related to NVidia driver, but who knows. Sorry about the false start. Enjoying the video now. Thanks Paul On 8/8/2018 1:14

Re: [libreoffice-users] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

2018-08-08 Thread Paul D. Mirowsky
FYI 11:08 AM EST YouTube video is not displaying. Results in message "If playback doesn't begin shortly, try restarting your device" in Firefox. Interestingly enough, if you move your cursor over the time line, it display image from video. Hope this helps. On 8/8/2018 7:44 AM, Tom

Re: [libreoffice-users] Glosses in linguistics

2018-06-11 Thread Paul D. Mirowsky
It might also be possible to use a "Customize" style of "Bullets and Numbering" with Paragraph styles. On 6/11/2018 12:20 PM, Paul D. Mirowsky wrote: I may be misunderstanding what you want to do, but you might be able to cheat a little by using a mix of Index

Re: [libreoffice-users] Glosses in linguistics

2018-06-11 Thread Paul D. Mirowsky
I may be misunderstanding what you want to do, but you might be able to cheat a little by using a mix of Index and Paragraph Styles. To Define Index Entries 1. Click in a word, or select the words in your document that you want to use as an index entry. 2. Choose *Insert - Table of

Re: [libreoffice-users] How many of you deal with the Linux Users Group [Facebook]?

2018-05-02 Thread Paul D. Mirowsky
HTML should good for screen readers. See: https://developer.mozilla.org/en-US/docs/Web/Accessibility/ARIA for how to use it. Although Writer have abilities... Support assistive technology tools (program restart required) Allows you to use assistive tools, such as external screen

Re: [libreoffice-users] using/printing of non-std paper formats

2018-04-19 Thread Paul D. Mirowsky
You may make your own version of a CUPS driver. See: CUPS PPD Extensions at https://www.cups.org/doc/spec-ppd.html It is a challenge, but can be done. Hope this helps. On 4/12/2018 8:23 AM, Paul Neuwirth wrote: Hello, (5.4.5.1,GNU/Linux,cups) I want to use paper formats, which

[libreoffice-users] Re: using/printing of non-std paper formats

2018-04-19 Thread Paul Neuwirth
On Thu, 12 Apr 2018 14:23:53 +0200 Paul Neuwirth <m...@paul-neuwirth.nl> wrote: > Hello, > (5.4.5.1,GNU/Linux,cups) I want to use paper formats, which are > not predefined in LibreOffice (8x12 and different custom labels > (autocutting device)). > I can set the page dim

Re: [libreoffice-users] Graphic Editing

2018-04-17 Thread Paul D. Mirowsky
The down and dirty methods. It depends on the pdf type, object or image based when imported into Draw. If there are actual individual objects in the file. Type and ungroup until there are no more groups left. Select and Delete objects. If an image type file. Place a rectangular

[libreoffice-users] using/printing of non-std paper formats

2018-04-12 Thread Paul Neuwirth
settings dialog. So the result is never correct. I already tried to set all configs "...FromPrinterSetup" to true, but no success. Any Ideas... web searched a lot, but could not find any usable information. Thank you Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libre

[libreoffice-users] Base: turn of header after 1st page

2018-03-01 Thread Paul D. Mirowsky
Hello Has anyone been able to use Base Reports and turn off the Header after the first page? Thanks Paul -- 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

Re: [libreoffice-users] 5.4.2 won't install on Windows 10

2017-10-18 Thread Paul D. Mirowsky
https://answers.microsoft.com/en-us/windows/forum/windows_7-security/error-the-system-administrator-has-set-policies-to/b5350e90-fe4b-4544-8549-20c6a7befb51 On 10/18/2017 3:50 PM, Steve Edmonds wrote: The system administrator has set policies to prevent this installation -- To unsubscribe

Re: [libreoffice-users] adding / using custom colours to LibreOffice

2017-10-17 Thread Paul D. Mirowsky
Is the exporter you are talking about? Is it available as an xpi? https://design.blog.documentfoundation.org/2017/03/29/libreoffice-extension-export-custom-palette/ On 10/9/2017 2:45 PM, Toki wrote: On 10/09/2017 04:47 PM, Gary Dale wrote: I volunteer with several organizations, some of

Re: [libreoffice-users] system sound + Libreoffice

2017-10-06 Thread Paul D. Mirowsky
Do a memory check immediately. See https://lifehacker.com/5531900/use-an-ubuntu-live-cd-to-test-your-pcs-memory Also try Writer with the live boot CD if it occurs under linux. Hope this helps. On 10/6/2017 5:11 AM, Thomas Blasejewicz wrote: Good evening I noted a very strange behavior.

Re: [libreoffice-users] word count in impress

2017-10-04 Thread Paul D. Mirowsky
If you are using Writer, export as text file. See "6 WC Command Examples to Count Number of Lines, Words, Characters in Linux" at https://www.tecmint.com/wc-command-examples/ If on Windows, also see "GNU utilities for Win32" at http://unxutils.sourceforge.net/ Hope this helps. Hope this

Re: [libreoffice-users] Reading from a USB device. Additional Realterm Info

2017-08-28 Thread Paul D. Mirowsky
The article below will probably help quite a bit setting up. https://nerdclub-uk.blogspot.com/2017/04/messing-about-with-midi-and-realterm-vs.html The parts on Realterm and MIDI starts about half way down the article. On 8/28/2017 11:38 AM, Paul D. Mirowsky wrote: You may want to take a look

Re: [libreoffice-users] Reading from a USB device.

2017-08-28 Thread Paul D. Mirowsky
. https://realterm.sourceforge.io/ I have not used it to analyze MIDI, but if there's data, it will see it. Hope this helps. Paul On 8/27/2017 9:47 AM, Marion & Noel Lodge wrote: I have a Studio Logic MIDI music keyboard which I have plugged into my PC via a USB cable. Windows has automatic

Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base

2017-07-06 Thread Paul D. Mirowsky
crashing after each installation. Hopefully, the culprit update package will show itself. So, I may be off for a while, but if I discover anything, I will post it here on this thread. I will keep your suggestion in mind as I am troubleshooting. Thanks. Girvin On 07/06/2017 07:54 AM, Paul D. Mirowsky

Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base

2017-07-06 Thread Paul D. Mirowsky
Just a shot in the dark. May want to look to see all proper groups are set. On 7/5/2017 6:56 PM, Girvin Herr wrote: On 07/05/2017 02:14 AM, Alexander Thurgood wrote: Le 05/07/2017 à 01:20, Girvin Herr a écrit : Hi Girvin, Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I

Re: [libreoffice-users] convert csv to xlsx - konwert man page

2017-06-22 Thread Paul D. Mirowsky
http://www.unix.com/man-page/debian/1/konwert/ On 6/22/2017 10:46 AM, Paul D. Mirowsky wrote: |iconv -f utf-8 -t ascii//TRANSLIT| This may allow you to pipe/redirect into your soffice command. There is also |konwert utf8-ascii| at https://sourceforge.net/projects/konwert/ However

Re: [libreoffice-users] convert csv to xlsx command line UTF8 coding problem

2017-06-22 Thread Paul D. Mirowsky
|iconv -f utf-8 -t ascii//TRANSLIT| This may allow you to pipe/redirect into your soffice command. There is also |konwert utf8-ascii| at https://sourceforge.net/projects/konwert/ However it is unclear how the command is used with a file name. I have not tried either, but may work for you.

Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

2017-04-27 Thread Paul D. Mirowsky
icolon. Save as a Calc file. Now you can play with ways to display data, make corrections data in wrong column and format printing. Hope this helps Paul On 4/27/2017 4:13 PM, charles meyer wrote: Hi Paul, I'm trying to keep this as simple as possible. In Windows 7, opening Windows Explorer to

Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

2017-04-25 Thread Paul D. Mirowsky
a bit of patience is greatly rewarded. Donate if you can. Hope this helps. Paul On 4/24/2017 1:32 PM, Paul D. Mirowsky wrote: Have you added the metadata from C:\Music\Sinatra\CapitolYears\MyWay to your files? On 4/24/2017 1:10 PM, charles meyer wrote: My learned and esteemed listmates

Re: [libreoffice-users] Libre Writer or Excel - File Name List - Pritning

2017-04-24 Thread Paul D. Mirowsky
Have you added the metadata from C:\Music\Sinatra\CapitolYears\MyWay to your files? On 4/24/2017 1:10 PM, charles meyer wrote: My learned and esteemed listmates, I wish to print the names of every artist with their respective album names and with each respective song tile (file named as

  1   2   3   4   5   6   7   >