Re: [libreoffice-users] Scanning Documents

[Paul D. Mirowsky]

I am using:

# System Details Report
---

## Report details
- **Date generated:**  2024-11-08 16:35:21

## Software Information:
- **Firmware Version:**    A12
- **OS Name:** *Ubuntu 24.04.1 LTS*
- **OS Build:**    (null)
- **OS Type:** 64-bit
- **GNOME Version:**   46
- **Windowing System:**    X11
- **Kernel Version:**  Linux 6.8.0-48-generic

*Document Scanner 46.0
*

*Brother DCP-7065DN
*

I must click on "*Gear*" icon of *Document Scanner* and select "All 
pages from feeder" to scan multiple pages.


I also use "*gscan2pdf*" which may help you.

Simple Scan is basically a frontend for SANE - which is the same 
backend as XSANE uses. This means that all existing scanners will work 
and the interface is well tested.
I'm assuming that you had no problems installing Brother Software. My 
installation was not the easiest but your problem was not one I had.


Hope this helps


On 11/7/24 20:33, MR ZenWiz wrote:

On Thu, Nov 7, 2024 at 3:07 PM Fred James wrote:

Andre wrote:

Good day.  My name is Andre and I would like to know if someone could
point me in the right direction.


:

My OS is Magiea 8 and I use:...
simple-scan - Simple scanning utility 
Simple Scan is an easy-to-use application, designed to let users connect
their scanner and quickly have the image/document in an appropriate format
... hope that helps

I use Xubuntu 2404 and simple-scan as well.  It doesn't do a lot, but
it can scan single or multiple pages quite well. Few settings, and you
need to use different paper settings for platen vs feeder scans, but
it's easier than xsane or any other scanning software I've used.

HTH,

MRZ


--
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] question: how can I make the scrollbars wider on LibreOffice?

[Paul D. Mirowsky]

The best answer I've found is GTK dependent.

See 
https://askubuntu.com/questions/775201/how-do-i-get-a-bigger-static-scrollbar-aka-normal-scrollbar?newreg=2a3c498096a94eb1948b173ae3936f69


Hope this helps.


On 7/5/24 21:47, Heidi Lasher-Oakes wrote:

Hello,
I just subscribed to this forum tonight so I could ask this question.
I am a long-time user of Linux Mint and LibreOffice.  I have low vision, so
I use a large default font size and have my default screen magnification
set to 150%.  Recently, I did a clean upgrade to Linux Mint 21.3.  I was
easily able to adjust the scrollbar width on my browsers, but the
scrollbars in LibreOffice are so narrow that I can barely see them.
Increasing the screen magnification unfortunately doesn't change the width
of the scrollbars.  I spent most of the day today working in LibreOffice
Calc, and I must have missed both the vertical and the horizontal
scrollbars hundreds of times.  Very frustrating!  I have spent the evening
researching fixes for this, but the suggestions I found were all several
years old, and none of them seem to be working on Mint 21.3.  Can you
suggest a way to make the scrollbars wider globally across LibreOffice?


--
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] LOBase reports fail

[Paul D. Mirowsky]

I don't use rpm's but assume that command paths are unique and similar 
in executing commands.


Search for "soffice". You should find 2 paths and, therefor, 2 files 
named "soffice"


Run each "soffice" as program or executable.

Click on menus  to see which version.

Hope this helps till a better answer comes along.

Paul

On 6/24/24 11:18, Harvey Nimmo wrote:

On Mon, 2024-06-24 at 16:11 +0200, Robert Großkopf wrote:

Hi Harvey,


LibreOffice Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded

Seems many LO version packed by a Linux distribution will fail to
execute any report. Don't know why.

Please install the original from LibreOffice. It will work.

Regards

Robert
--
Homepage:https://www.familiegrosskopf.de/robert


...I've screwed up the installation because I don't know what I'm
doing...;-(

I downloaded from LO, extracted the files and entered in the terminal

~/Downloads/LibreOffice_24.2.4.2_Linux_x86-64_rpm/RPMS> sudo rpm -Uvh
*.rpm

I now have two versions installed, 24.2.1.2(old) and 24.2.4.2-2(new)
and I do not know how to activate the second one. I can guess, I could
use YaST to delete the old one to start with, but what can go wrong?
And I have no idea how to activate the new one in Gnome.

What do you suggest?

Regards
Harvey



--
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] Printer not showing in LO print dialog

[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 the Brother black&white 
laser printer. Then I open Setting->Printers. It shows the Brother b&w 
(which is set to be the default printer). I go back to LO Writer and 
now the Brother b&w shows.


This has happened a number of times. Any ideas?

I'm running Fedora 39 on Dell XPS 13 9315.
Brother HL L2350DW
Brother MFC 6890CDW

Thanks.

--
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] Labels created in Writer shifts downward while printed

[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 3/22/24 20:13, Hartman Tam wrote:

Hello all,

I'm creating some labels in Writer. After it being printed, each label 
shifted downward gradually. This happens with and without any 
formatting. I have checked I have my label setup correctly. I also 
tried disabled my printer's scaling but doesn't help. My printer is 
Brother MFC-L2710DW. Did I miss anything? How can I solve this?


LibreOffice version:

 * Version: 7.3.7.2 / LibreOffice Community
 * Build ID: 30(Build:2)
 * CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
 * Locale: en-GB (en_GB.UTF-8); UI: en-GB
 * Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4
 * Calc: threaded Jumbo

The label I'm using: https://www.amazon.co.uk/gp/product/B093TM72T7

Thanks,
Hartman


--
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] Address from Evolution Address Book defined but not displayed

[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, the Field Assignment table is missing a second 
street address for personal or business addresses.


The Field Assignments do have a single "Street" to allocate 
"addr_line1", but not "Street 2" to allocate "addr_line2"


This suggests what happens next.

When importing address information from Evolution Email Client Address 
Book, "addr_line2" and "work_addr_line2" field headers display, but 
fields are empty.


Please confirm this is true.

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

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

[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 and then the old 
version is gone from menu.


I imagine Thunar is similar.

Hope this helps.


On 9/28/23 15:51, MR ZenWiz wrote:

I updated all my LO installs to use 7.6.2 and verified my links and
Thunar "open with"s to ensure they go to the 7.6 install.

However, they all show 7.5.5.2 when I click  -> About.

What's going on here?

Thanks.

Mark


--
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] Address Book Conundrum

[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 created from a 
calc spreadsheet, assigned via the Address Data Source Wizard. In a 
freshly installed version of LibreOffice (7.6.0.3) it's no longer 
available as it requires the "base" component that is not present.


It has required Base also in the past, but many people didn't 
recognize this. You connect from Writer thruogh Base to Calc.


Why isn't Base available for your installation. I never git an 
installation without Base component (OpenSUSE 64bit rpm Linux here).


Regards

Robert

--
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] Address Book Conundrum

[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 book created from a calc 
spreadsheet, assigned via the Address Data Source Wizard. In a freshly 
installed version of LibreOffice (7.6.0.3) it's no longer available as 
it requires the "base" component that is not present.


Have I missed something in a Release Note, or is there a functional 
alternative?


Peter HB


--
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] problems on Ubuntu

[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 Office files, though not with Writer, which
is what I use the most.

When I open a spreadsheet, the icon appears in the margin, but I cannot
actually open the document and get it to display. It must be a setting I
have somehow changed, for I used to be able to open up a spreadsheet, but
not any more.

Clearly, the file is somewhere, but I am not getting it to open up and
display on the screen.


--
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] Is anyone using Libreoffice SYNCHED to Google drive or One drive or Soho Drive or similar online / cloud drives ?

[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 Google drive or One drive or Soho Drive 
or similar online / cloud drives ?When I save a Libre office sheet, that should 
be auto saved to Google drive or One Drive ..or ...I am NOT talking of backup 
end of day or end of hourI am talking of cloud drive
Pls helpPls pointTIA
regardsSubu


--
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] weirdness in save dialogue box

[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 Edmonds wrote:
I have just opened an older file, sometimes the file Name field is 
not blank when I "Save As" with older files until I edit and re-save.
This time the full name with extension does show. If I open Writer to 
an Untitled document and "Save As" the Name field is pre-filled with 
"Untitled" (no extension).


In Tools>Options>LO>General there is an option Open/Save Dialogues, I 
don't know if this setting would affect Mike's result.


I don't think so.

I've just been playing again with the problem. First up, I deleted 
~/.config/libreoffice/ to try to get a clean(er) start. (Not that this 
seems to have affected anything.)


There's a file JUNK.odt in my home directory, and which behaviour I 
get actually seems to vary randomly. I've tried even opening this 
document just the once and doing repeated 'Save As' + Cancel, and the 
behaviour occasionally changes from one to the other, sticking there 
for a while before switching back. Sometimes the 'Name' box in the 
dialogue says "JUNK.odt" [with the odt selected) and sometimes just 
"JUNK" [selected].


Checking on my laptop, which seems to be running an older version 
6.something (I think it's runnjing the previous Mint version), the 
same sort of behaviour is observable.


This is seriously weird, and very confusing for my wife, who regularly 
needs to send out .docx files to her contacts; in the mode where 
"JUNK.odt" is the style, she has to manually change the odt to docx, 
which should not be necessary.




--
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] LO Draw Newbie

[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 helps.

On 7/2/23 13:39, Vince@Verizon wrote:

Hi:

I am using Windows10x64bit Home on DELL desktop and LO 7.3.2.2 (x64) / 
LibreOffice Community.


I have never made any use of the LO Draw module in the past, and 
wonder if it is suitable for creating a 2-dimension drawing that shows 
room layout with dimensions, to scale if possible.


My immediate need is to create a document/drawing of the household 
room dimensions, e.g., square footage dimensions, as if I needed to 
paint the ceiling or the walls or needed to lay down carpeting or hard 
wood flooring, or calculate/show square footage of lawn areas, etc.


Is LO Draw the appropriate module for me to learn? Or, is there some 
other program that is simpler to learn and to use?


Up till now I have been making a hand sketch of the area of interest, 
scan the sketched layout, create a PDF and then type/enter dimensions 
as text annotations within the PDF. I think there might be a simpler 
method.


I look forward to receiving suggestions/comments from the LO Draw 
community users. In the meantime, I will be reading the LO Draw Users 
Guide.


Regards,

VinceB.



--
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] How to select the screen that the Impress presenter console displays on?

[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 use LibreOffice on Fedora Linux. I 
have a computer with 4 monitors. If I set one  monitor 2 (the  middle 
one, where my web cam is) to be the primary display in the NVidia 
software in Fedora, that's the screen the presenter console with notes 
displays on. Then I go into slide show settings, select the screen I 
want to display the slide deck on, and then share that screen for 
training over WebEx or Zoom or whatever the client uses.


Soon, I have to use Windows because I have a client that requires that 
I use GoToWebinar, which requires a Windows only client application. 
Grudgingly, I installed Windows on this machine, and I used the NVidia 
settings tool to set the middle screen (screen 2) to be the primary 
screen, just like I do in Linux. But for some reason, when I fire up 
LibreOffice Impress, the presenter console launches on screen 1, which 
is to my left. I've tried to set the primary display to other screens, 
but Impress doesn't change which screen it displays on. It's always 
screen 1.


Is there any way to force the presenter console to display on screen 
2? I've combed through all the docs I can find, and I've never seen 
anything about how to set which screen the presenter console displays 
on. I may just be searching using the wrong terms.


Anyone know how to do 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

Re: [libreoffice-users] Help with Impress

[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.  However, I am having 
an extremely difficult time with LibreOffice Impress. After saving 
after every new slide, LibreOffice crashes on me.   I send the crash 
report, restore the program, then I have to reposition the last slide 
(What was slide 13, is now slide 12). My presentation is only 15 
slides.  In other words, LibreOffice crashed 15 times!


    I am using LibreOffice vs 7.4.2.3 on a Windows 10 vs 10.0.19044 
laptop.


    I want to do a presentation on LibreOffice using Impress, but not 
with that nonsense.




--
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] hardening libreoffice 7.0.4 - Secure Installation

[Paul D. Mirowsky]

Hello Alvaro

I will attempt to help you and do not profess to be an expert.

If you treat all security as layers, each one is as important the next 
and all of them are points of failure.


That being said, the easiest breach is at the inner layers.

As for LibreOffice, start here: 
https://www.bleepingcomputer.com/news/security/libreoffice-addresses-security-issues-with-macros-passwords/


Do your research well in RED HAT/Linux and network secured environments 
and you will be no worse off then the rest.


Statistically, we all in the same boat.

There are those who can point out singular evidence of foul play, but I 
suspect very few who can point out more than a few.


Just because someone is able to pull an the same ace of hearts from a 
deck of cards does not mean know they know all the other cards.


Be vigilant about CVE's. 
See:https://en.wikipedia.org/wiki/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



On 10/31/22 08:41, Alvarito wrote:

   Dear Sir,

My name is Alvaro Hinojosa, in order to user your
software, I need to install LibreOffice in a high secure environment
(Linux RedHat), is there any documentation or guides about libreoffice
most secure settingsThanks
Thanks in advance

A


VOUCHER CONNETTIVITÀ per P.IVA e PMI: internet a canone 0 per 48 mesi. ATTIVA 
ORA
  
https://casa.tiscali.it/promo/?u=https://promozioni.tiscali.it/voucher_business/?r=TS0A00025&dm=link&p=tiscali&utm_source=tiscali&utm_medium=link&utm_campaign=voucherbusiness&wt_np=tiscali.link.footermail.voucherbusiness.btb..



--
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] Issue with automating a simple process.

[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 creates the files with about 600 lines.

Have a spreadsheet that then has external links to import
data to cell A5:V600 from one and AA5:AV600 for other.
That works fine..

I added conditional formatting that compares the data
between two groups to hightlight lines that are added or
deleted between to sets of data. That also works fine at
that point.

Problem is: If I open the spreadsheet again, it reimports
the data and in process wipes out all reference to the
range A5:AV5xx and AA5:AV5xx leaving just cells
between groups. Tried setting range to A1:AV600, but
again, it seems importing information wipes out the
conditional formatting.

I can manually go in and change the ranges back to
A1:AV600 and that restores the formatting..

Tried recording a macro for that, but result is nothing
was recorded.
Also, trying to record the importing manually does seem
to work either.

Tried to create a Range name thinking that might keep it,
but conditional formatting does except range names or
absolute addresses??

Perhaps it can't be done.

But process is much better than original manually getting
two sets of data to line up with manuall inserting cells.
Has about 46 records that are add/delete between data
sets.

Perhaps there is something I'm missing.
  
++

  Michael D. Setzer II - Computer Science Instructor
(Retired)
  mailto:mi...@guam.net 
  mailto:msetze...@gmail.com

  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
++





--
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] Cannot save file

[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 Edge as test 1 and from Chrome as 
test 2. WITH success (today).


I have edited this message: to WITH suc.

From: 
https://ask.libreoffice.org/t/libreoffice-locks-clipboard-ctrl-c-ctrl-v-not-working/21431/12




On 3/2/22 03:14, Thomas Blasejewicz wrote:

Good afternoon
Another incomprehensible behavior arose.

I open a new document, copy text from a text file and try to save the 
document as .odt.

Yet, nothing happens.
I tried to save the document in different locations, but that does 
not change anything.
Creating a document in the same way in Word (which I rarely use) 
causes no problems.


How can I fix this very annoying behavior.
Thank you
Thomas




--
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] Cannot save file

[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 
Formatting]


Is it possible that the source file has locked text?



On 3/2/22 03:14, Thomas Blasejewicz wrote:

Good afternoon
Another incomprehensible behavior arose.

I open a new document, copy text from a text file and try to save the 
document as .odt.

Yet, nothing happens.
I tried to save the document in different locations, but that does 
not change anything.
Creating a document in the same way in Word (which I rarely use) 
causes no problems.


How can I fix this very annoying behavior.
Thank you
Thomas




--
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] Cannot save file

[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 behavior arose.

I open a new document, copy text from a text file and try to save the 
document as .odt.

Yet, nothing happens.
I tried to save the document in different locations, but that does not 
change anything.
Creating a document in the same way in Word (which I rarely use) 
causes no problems.


How can I fix this very annoying behavior.
Thank you
Thomas




--
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] missing printer formats

[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 10 years, until a hardware 
problem forced me to a Curtains 10 device.


On this new machine, I have LO 7.1.7.2 (x64).

As you can tell, my needs are relatively elemental, as LO4 served me 
well all those years. The number of regressions reported on this site 
damps down any possible lust for unnecessary upgrades.


Now that I have been forced upwards, I have hit a brick wall, and this 
is one of several reasons why I am reluctant to install "upgrades" as 
they are offered.


I have the same two printers that I have used for years: a Brother 
HL-6180-DW, and an Epson XP-630. The Brother continues to work, 
offering me some 20+ paper formats in its dialogue.


The Epson, however, which I need for colour printing, shows only 5 
paper choices: 2 sheet sizes, 2 index cards, and a "Japanese Postcard" 
at 3.93 x 5.83 inches. That last is interesting, and I have no idea 
where it came from (or why), but I can ignore it.


I am obviously missing many formats, some useful, some not, but in 
particular there are no envelopes offered. My immediate need is for 
the American #10 envelope.


I have several hundreds of files on hand, all formatted for the #10 
envelope, but there is no obvious way to select that format for the 
XP-630.


LO will graciously allow me to print in B/W on the Brother, but not in 
the required colour on the Epson.


I have spent most of the afternoon plowing through the 7.1 manual, the 
"help", and various on-line sources, without even finding out how I 
might generate the #10 anew as a "custom" format. That would be an 
absurdly redundant effort since this format is well-known, but it also 
indicates my inability to set up any truly custom format for this 
machine.


I am also ignorant enough so as to not know whether these formatting 
instructions are supposedly read off the hardware by the Curtains 10 
system, or by LO, or are inherent in LO, or are programmed from an 
external Epson source, &c.


The answer to my problem ought to be simple enough, but since I can't 
figure it out, any help/tips would be appreciated.


t.r. jackson / wagt...@comcast.net




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 I see in 7.3.0.3
https://pcloscloud.com/index.php/s/cD3TzctTCrk7WgY


"Print in reverse order" also true from  for:

Version: 7.1.8.1 / LibreOffice Community
Build ID: e1f30c802c3269a1d052614453f260e49458c82c
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded


--
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] Libreoffice impress presentation - metropolis - exported as PDF, doesn't display correctly on some devi

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


On 5/17/21 4:27 PM, Daffy Duck wrote:

Seem to have the same result :(

I wonder if I just have to ditch metropolis?

On Mon, 2021-05-17 at 15:39 +1000, Michael D. Setzer II wrote:

On 16 May 2021 at 18:27, Daffy Duck wrote:

Subject:[libreoffice-users] Libreoffice impress
presentation - metropolis - exported as PDF, doesn't
display correctly on some devices
From:   Daffy Duck 
To: users@global.libreoffice.org
Date sent:  Sun, 16 May 2021 18:27:18 -0500


I made a presentation with impress, used Metropolis theme.

I then exported it as PDF.

The problem is, some, when opening on such things as iphones, get the
text cut off, like the top part of the text is not showing, etc.

Others, until they turn the phone sideways, it doesn't display the text
correctly.

How do I make sure the text looks correct for all, or at least most,
users on different devices?

Note an expert, but something you might try.
Open file, and go to File/Properties/Fonts
There are two check boxes for embedding fonts.
Don't know if either or both would make a difference.
Might be some font that you used isn't included on these
devices and they are using a different font that throws
everything off?
Not sure why this isn't listed under the PDF options as a
choice?
Had a spreadsheet I exported that had this issue with
some fonts, and believe this fixed it? But it was long ago..
Worth a try. Worst thing, it makes no difference. File will
be bigger since fonts will be included.



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


++
  Michael D. Setzer II - Computer Science Instructor
(Retired)
  mailto:mi...@guam.net
  mailto:msetze...@gmail.com
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
++





--
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] Write Closed but Windows 10 won't provide safe to remove flash drive

[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 does not go away, delete it.
2. Run Windows 10 Task Manager and look for any surviving LibreOffice
   programs running. If yes, kill the program, then see if it is safe
   to remove drive.

If either of these work for you, see "How to Report Bugs in LibreOffice 
at https://wiki.documentfoundation.org/QA/BugReport


These are the two things I found that caused LibreOffice to not let go 
of a file.


Hope it helps.


On 3/6/21 4:36 PM, charles meyer wrote:

This is both a Writer question and a Windows 10 issue.

I close Libre Writer and all the other  programs I had  opened but when I
click the flash drive icon in the "system tray" (lower right) to receive
the Safely remove the flash drive it keeps displaying  that I need to close
programs.

I've check each program along the toolbar (on the bottom) and none are open
but it still won't give the OK to pull the flash drive out.

I've Googled this and reads both that you can just pull the flash drive out
as its plug and play and others say the flash drive will stop working oif
you keep pulling it out with the "Safe to Remove" message.

Your thoughts and suggestions are greatly appreciated.



--
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] Language setting in Calc

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


https://help.libreoffice.org/4.4/Common/Selecting_the_Document_Language

On 2/19/21 5:43 AM, Thomas Blasejewicz wrote:

Good evening
In my line of work (translator) I often forced to use MS Office files.
Right now I am working with an Excel worksheet.
I am not allowed to change file name, format or anything else am only  
supposed to enter

the German translation of a Japanese text into the designated columns.

Fine so far.
The original file is so formatted that there are font settings for  
English and Japanese.
When I work at home (right now) I select the relevant columns and  
change the language setting to German.
But when I go to my little work place and open the same file there,  
the language in those columns is back to English.
I changed it in my office to German again, but once I am home and  
start working here, it is back to English again.


Is there a way to tell Excel files to use a specific language AND STAY  
THAT WAY?


It would reduce unnecessary stress significantly.

Thank you.
Thomas



--
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: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

[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* short of the deer.

The engineer goes second. He pulls out his engineer's pad and book of 
projectile assumptions. After a few minutes he’s ready, he takes aim, 
and fires.


The bullet lands 20m passed the deer. The statistician leaps in the air 
shouting, “We got it!”



The error is always in the middle.

Thanks to all the engineers and IEEE and to my father who was one.


On 1/28/21 5:42 PM, John Kaufmann wrote:

On 2021-01-28 16:47, John Kaufmann wrote:

What is sychropopular?  Do you mean synchrophasor? ...


My profound apologies to the list for that. I have no idea how this 
list was added to the distribution of that reply to an (HMTL) mail 
from IEEE Power and Energy Society.




--
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] Epson XP-820 paper size setup

[Paul D. Mirowsky]

I am using Ubuntu 20.04, debian/Bullseye should be similar.

In browser, type URL "localhost:631"

Click on "Administration" Tab. Click on "Manage Printers" button.

Click on the printers name you want.

Click on "Administration" menu button and select "Set Default Options".

At "Media Size" either select size you are looking for or define 
"Custom" size.


Select "Custom" to print.

It may not be perfect because you may have to do a specialized select 
whenever you want to print this size, but usually does 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 PM, Gary Dale wrote:

I'm running Debian/Bullseye

!!



--
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] Epson XP-820 paper size setup

[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 thing is driving me crazy. I need to 
print to a 244mm x  149mm envelope sometimes. This should load through 
the rear paper slot which is provided for this purpose. However I 
can't tell Writer to use this size. The envelope is defined as that 
size but I can only select one of a list of paper sizes for that 
printer in the Print dialogue.


I have the same problem when I try to load the envelope into a paper 
tray. I can tell the printer what size it is but that still doesn't 
show up in Writer when I try to print.


To make things weird, a number of the paper sizes are given as "User 
Defined: 9.999in x 9.999in" but I have no idea how they got there - 
although some seem to be standard sizes (photos, envelopes, etc.).


Through trial and error (one or more errors per trial), I've come 
close to getting an envelope to print reasonably without spraying ink 
outside the paper range. However, the envelope document only vaguely 
resembles what is printed. And I have to go through this again if I 
try to print to a different paper size.


Is there a way I can tell Writer to use the paper size of the document 
so that it actually prints the way I set it up?




--
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] Copying data from Calc to Base...

[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 to Base.  Here is what I have done so far.


Calc - created spreadsheet
A = ID (Default format)
B = Name (Default format)
C = Location (Default format)
D = Date - First (Format as DD MMM )
E = Date - Last (Format as DD MMM )

Base:
Created a database named Reactors and created fields:
ID Interger [INTEGER]
Name   Text [VARCHAR]
Location Text [VARCHAR]
Gender Text [VARCHAR]
No. Number [NUMERIC]
Date - First Date [DATE]
Date - Last Date [DATE]

Opened spreadsheet and highlighted columns  (as listed above)
(as a test I chose only Rows 1-6)

Chose Copy and navigated to Database and clicked to Paste

From Menu presented, chose Append data (the default option)
clicked Next and unticked ID
clicked Create and following error message was displayed

Warning.  Wrong data type:java.lang.IllegalArgumentException.

Searched both Internet (in general) and LibreOffice website (in 
particular) but found nothing to help.


Obviously I am doing something wrong but I am unable to find the 
error.All help will be very welcome.


Zed




--
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] Presentation - video record

[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 screen on your Mac
 o https://support.apple.com/en-us/HT208721

There is also the ability to use Impress and export as SVG. While I have 
only used one page to do this, all objects 'fly in' correctly using 
Firefox version 77.0.1 (64-bit) on Ubuntu. I assume this means all other 
controls work.


Hope this helps.


On 6/16/20 6:35 PM, Cuyahoga Falls wrote:

On 6/16/2020 2:14 PM, charles meyer wrote:

I'm trying to coordinate a presentation with Libre Presentation.

Can Presentation record screens on your laptop like MS Power Point?

If so, could you please share those steps?

Thank you.

Charles.



I don't think Presentation can do it natively. I use free third party 
programs to accomplish this. In Windows, I use a free program called 
ShareX, which works just fine.


You can also do it through Zoom and include your own picture in a 
corner of the screen through its screen share feature.


In Linux, I use Kazam.

Virgil




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 they add a  
that would allow changes to line type and color mixed in with the text 
option.


Sorry, couldn't help.

On 6/3/20 5:11 PM, seedpress wrote:

Thanks for the suggestion. Unfortunately  the "" option
only allows formatting of fonts. The dashed indicator line referred to in my
question remains unaffected by any changes to font size or style.



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
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] Writer Comments Have Faintly Printed Indicator Lines

[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 a comments feature in
LibreOffice writer. As you may know, each comment in the right margin of the
document has dashed lines that go out to a “carrot” indicator in the main
body of the document. When I enable the print option “comments in the
margins,” the printed comments’ dashed lines are too faint and thin to read
easily.

I can’t find a way to increase the thickness of the dashed lines to make
them more legible. I’ve tried adjusting the font size within the comments,
but the dashed line thickness remains fixed.

I’m printing with a black-and-white only laser printer. The grayscale of the
printed dashed lines varies according to the color of the comment. So, I can
darken them a little by cycling through the colors and picking a darker one.
That helps readability somewhat, but the dashed comment lines are still too
thin.

I have to cycle through the colors using a clumsy trick detailed in various
places, for example: https://askubuntu.com/questions/60116...

Is there an easier way to select a comments background color in the newest
version of LO?

I’m running LO Version: 6.4.3.2 (x64), on Win 10.



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
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] Open .csv by specifying column widths on command line

[Paul D. Mirowsky]

Calc template files end in .ots

Although I used Writer to make my macros, Writer does not export CSV 
files correctly, or should I say without spaces as Calc does, I guess 
you will have to make your macros in Calc. (Version: 6.3.5.2).


Hope this helps.

On 4/8/20 1:30 PM, edonkey2001-libreoff...@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 is that LibreOffice opens two files:
- a new file based on my template, which contains no data
- my csv file, without applying my template to 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] Open .csv by specifying column widths on command line

[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: 
https://ask.libreoffice.org/en/question/150565/execute-macro-in-calc-from-terminal/



Also, this simple Sub:



|SubFindSheet(aNumber)MsgBox"Here is the number "&aNumber EndSub|

run from terminal as:

|libreoffice6.0"macro:///Standard.Module1.FindSheet(4)"|

or on some systems:

|soffice "macro:///Standard.Module1.FindSheet(4)"|

displays the proper variable and message in a message box.

Another note, when executing the macro from terminal and all of LO is 
closed, you will briefly see the LO splash screen displayed.






Thanks Brian for your reply, unfortunately that does not help me.

What I'm looking for is a way to work with csv files with minimum hassle.
I do not need features such as column widths, other formatting etc. to be saved 
in the file(s).
I just need to specify the way LO displays csv files when they are opened (as 
command line arguments so I can automate that).

Your proposed workaround would require manual adjustments, on a file by file 
basis, and each time they are opened.
These manual steps are what I'm looking to avoid. Else I could just resize the 
columns and enable wrapping every time and be done 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

Re: [libreoffice-users] Problem with print dialogue

[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 experimental-features
"['scale-monitor-framebuffer']" |
 *

Restart the computer.

  * Open /Settings/ -> /Devices/ -> /Displays/
  * Now you should see 25 % step scales, like 125 %, 150 %, 175 %.
Click on one of them and see if it works.

Quote from: 
https://askubuntu.com/questions/1029436/enable-fractional-scaling-for-ubuntu-18-04


I do not know if it has reduction settings.

It may be possible to set a separate workspace using the above, but I'm 
no expert.


Anybody else?


On 4/7/20 10:03 PM, John Sweeney wrote:

I have this version of libre office: Build ID: 1:6.4.2-0ubuntu0.18.04.3

I cannot see the OK button on the print dialgoue because the dialogue is
too big for my screen and there is no scroll bar nor can i change the
dialogue's size. It is very frustrating.

Can anyone help?

Thanks,

John Sweeney




--
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] Open .csv by specifying column widths on command line

[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 your reply, unfortunately that does not help me.

What I'm looking for is a way to work with csv files with minimum hassle.
I do not need features such as column widths, other formatting etc. to be saved 
in the file(s).
I just need to specify the way LO displays csv files when they are opened (as 
command line arguments so I can automate that).

Your proposed workaround would require manual adjustments, on a file by file 
basis, and each time they are opened.
These manual steps are what I'm looking to avoid. Else I could just resize the 
columns and enable wrapping every time and be done 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

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

[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

https://wiki.documentfoundation.org/Documentation/FirebirdMigration

Glad to help.

On 3/19/20 11:31 AM, bunk3m wrote:

Thank you Alex, Paulo and Drew.
I didn't realize there were so many "bugs" still to work out.
I'll stick with HSQLDB for now.
I trust there will eventually be a way to migrate to the new DB in the
future?

On Thu, 19 Mar 2020 at 10:10, Alexander Thurgood 
wrote:


Le 19/03/2020 à 13:32, bunk3m a écrit :

I would only recommend using embedded Firebird if you're comfortable
with all of its still numerous bugs, and are happy to get your hands
dirty correcting data types, lengths, etc and possibly corrupted data.

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 VARCHAR data
that you have in your spreadsheet.

If you have Unicode characters in any cell, you might also get an import
failure because these are coded over 4 bits per character, which can
rapidly cause the automatically created insert statement to exceed the
64KB limit, and again, fail.


My advice would be to stick to embedded HSQLDB until, or unless, you are
comfortable with such limitations.


Alex




Thank you Alex and Drew.
I'll try your suggestions today.
I appreciate your help!

One more question if I might.
If I understand correctly, HSQLDB is being replace by Firebird.  So I'd
like the engine to be Firebird so I don't end up with an issue in the
future.
How does one know that Firebird is being used?

On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood <

alex.thurg...@gmail.com>

wrote:


Le 19/03/2020 à 01:57, bunk3m a écrit :

As Drew has said, you can use your existing flat file in several ways :

1) Go via the empty ODB file method to drag the linked XLSX sheet from
your first ODB file to the second, empty ODB file and then follow the
import wizard.

2) Create an empty ODB file and keep it open. Open your XLSX sheet
directly in LO Calc. Select all of the data including column headers,
that you want to import.
Drag and drop this selected data onto your open ODB.
Use the import wizard options to configure the way you want the data to
be imported into a new table that will be created as a result of the
drag and drop maneuver.

Be aware that the import wizard isn't perfect, depending on the version
of LO you are using, it might cause you a bit of grief, so double-check
afterwards that it has done what you wanted (within the confines of what
it can actually do, of course). You might find that some post-import
database alteration statements might be necessary.


Alex





--
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: Base created from xlsx file - move to proper DB

[Paul D. Mirowsky]

See below...

On 3/19/20 10:10 AM, Alexander Thurgood wrote:

Le 19/03/2020 à 13:32, bunk3m a écrit :

I would only recommend using embedded Firebird if you're comfortable
with all of its still numerous bugs, and are happy to get your hands
dirty correcting data types, lengths, etc and possibly corrupted data.


Always look at the resulting table to see if it's fields are defined 
correctly and display correctly when looking at table data.


Make sure columns are defined with proper data type such as date or time 
in your spreadsheet.


Until the resulting table is as close to your intended field type, keep 
making a new table.


Understanding through re-iteration will help you see the pitfalls.

If you can't get the import to the correct data type, import in such a 
way as to have complete data from spreadsheet field.


At this point, from within Base, you may be able to make a new 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 VARCHAR data
that you have in your spreadsheet.

If you have Unicode characters in any cell, you might also get an import
failure because these are coded over 4 bits per character, which can
rapidly cause the automatically created insert statement to exceed the
64KB limit, and again, fail.


My advice would be to stick to embedded HSQLDB until, or unless, you are
comfortable with such limitations.



--
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] Libreoffice office cloud version

[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 appreciate any suggestions if any similar service 
existed).

I am looking for something like Google doc, sheet but purely libreoffice 
version where I can do online collaborative editing, sharing doc, and so on. I 
understand there are services like MS sharepoint, Google doc, and so on. But I 
am more interested in using open source software, and I know some of my friends 
who also want to use such service as well, though I understand that might not 
be big enough request in triggering to create such service. But anyway that'd 
be nice to see such service that people can use.

And thanks community's effort to create such kind of software!
  





--
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: Libre Writer Help download + Margin adjustment

[Paul D. Mirowsky]

Hello Charles

Suggest you go to a more current stable version, 6.3.5.

https://www.libreoffice.org/download/download/

Allow download to begin. On that page, click on "LibreOffice built-in help".

If that doesn't work, then, after downloading the package, use browser 
to go back to same page and click on the green link that says ":


 * Help for offline use: *English (US)*
   

   (Torrent
   
,
   Info
   
)

Do not use(Torrent 
, 
Info 
) 
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 Libre Writer.

Would you pls share the direct link to that download?

Also, I can't seem to find where you adjust margins in Writer.


Menu  and change Left/Right margins.

This is also the place for changing 'Orientation' from Landscape to 
Portrait.




It used to be under Edit or File>Page Layout.

I have "text" words in an Excel spreadsheet file. I copy and the paste 
them into a Libre Write new document but about 1/3 of those words goo 
off the page to the right so I can't read them.


Sorry, but I am not familiar with how Excel copies to Writer.

What I always do when copying from an uncommon format is clear it and 
use the software's format.


Highlight incorrectly formatted text, then Menu Formatting>




I don't know how to reach Landscape (from Portrait) to read 
the words/text better (like you can in Print) - is there a way to do 
that in Writer?


Thanks so much.

Charles.


--
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] Writer will not print envelopes

[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
   or 2 pages for envelope?
2. Go to , "Options" tab to try "Use only paper size from
   printer preference".
3. Check "Properties" for your Brother printer and see if there is an
   option for "Other Pages" and that it is set correctly.

By the way, I noticed you did not mention what operating system you are 
using.


Hope this helps.

On 1/31/2020 5:36 AM, williamdrescher wrote:

Win10
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee

I insert an envelope into a document.  When I then print the document the
first page (the envelope) prints as a blank page.  The rest of the document
prints just fine.

Any suggestions or thoughts?

bill



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
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: Using Libre Writer - with hardware questions

[Paul D. Mirowsky]

This sounds more like a hardware problem then a LibreOffice/software 
problem.


Some manufacturers have built in hardware diagnostics, run them if 
available.


If you have the ability to add a external monitor to the laptop.

Although it varies from *laptop* to *laptop*, some can turn on the 
*external monitor* by hitting the *Function Key* (*Fn*) plus the F5 
*key*. On the *Toshiba*, continually hitting *Fn*-F5 , skips between 
the various *monitor* options including *screen* duplication and 
*screen* extension.

https://www.google.com/search?ei=cAQvXub9LKqd_Qb5nKbwBg&q=toshiba+laptop+external+monitor+function+key&oq=toshiba+laptop+second+monitor+key&gs_l=psy-ab.3.0.0i22i30.427589.447202..449066...5.2..0.189.2795.35j3..01..gws-wiz...0i71j0i273j0i131i273j0j0i131j0i67j0i131i67j0i22i10i30j33i22i29i30j33i160j0i13.VDP2nfMeXEU

This information can be confirmed from your laptop owners manual.

If you have the ability to create a Linux OS disk like Ubuntu, boot it 
and see the screen problem goes away. This may help to confirm a Windows 
driver problem.


https://tutorials.ubuntu.com/tutorial/try-ubuntu-before-you-install#0

It also will allow you to do a memory check.

https://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 helps.

Paul


On 1/25/2020 4:58 PM, charles meyer wrote:

I've been encouraged to post here re: my hardware travails!

Here goes...

I booted up my older Toshiba laptop running Windows 7 which for years had
been working fine.

Then, one day I booted up and got these vertical color bands where you
couldn't see anything else bu the bands.

  I then re-booted and opened Word 2003 (as Libre Office take a longer time
to open and the laptop would just shut Word
   down, then when I re-booted it would shut the laptop down while I was
writing in Word.

Then, I tried opening Libre Writer and it just froze – never opened so
   I had to press the power button to re-boot.


   I moved the laptop power adapter from the power strip to the UPS then
   moved the laptop so it’s connected directly into a wall outlet in
   another room. Still no good. I then powered the laptop in an outlet in
   the top outlet (not the bottom one even though the last testing showed
   the outlet (top/bottom)were both fine.

I then brought the laptop to work and got the same results when trying to
run it.

Someone said I might have to delete all my video drivers and r-install them.

I have no idea where to find those drivers on my laptop, nor which ones to
delete nor where I would find the correct replacement video drivers nor if
that's even a correct solution.

I've got 3 GB Ram running.

It's a nice 17" screen so I don't want to toss the laptop and it ran for 3+
hours at a friend's work space - with 4 programs open at the same time -
Publisher, GIMP, the Brave browser running a YouTube  video and another
program to test the laptop and it all worked fine.

Thanks for your thoughts/ suggestions.



--
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] Using Libre Writer - with hardware questions

[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 knowledgeable forum where I could post what's
happening with my laptop to troubleshoot so I can get it stabilized to use
Libre Writer?

Tom's Hardware has been disappointing.

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

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

[Paul D. Mirowsky]

While not sure of video out capability, you may want to look at these 
extensions.


https://extensions.libreoffice.org/extensions/geomap

or https://extensions.libreoffice.org/extensions/geooo

or working with Google Maps KML (XML) format in Calc.

 *

   created map & entered some points of interest

 *

   created & downloaded KML file

 *

   changed extension from |kml| to |xml|

 *

   Opened Calc

 *

From menu |Data->XML Source...| this started dialog

 *

   Under |Source File| clicked icon to select .xml file

 *

   Once selected |Map to Document| was filled with field names

 *

   Selected |..Placemark| section ( subsequently selects all entries below)

 *

   In |Mapped Cell:| section used icon to select cell where data would
   start

 *

   Returned to dialog & selected |Import| button

The above is from 
https://ask.libreoffice.org/en/question/176585/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.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] Transparency issue saving to .doc/docx

[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 it back to DOCX or DOC.  I have 2 
transparent background images that overlap each other to solve a visual 
need.  The problem is half the time the images lose their transparent 
backgrounds and cover up the underlying text.



#2
They are logo and a high def images that do not work well to break up 
and then realign them in some way to into a odd shaped space. It would 
be very hard to cut up the images so their borders are wavy and curved 
to match the free spaces.




2. Transparency

Consider breaking the image up, where the resulting pieces won't overlay
your text. That is, instead of leaving a border image with text 
appearing
inside it, place the border as multiple images, so that no text can 
"fall
behind" because the images never overlay.  This will require 
exporting the
image and cutting it, or placing the image multiple times and 
cropping it.

If you go the route of cropping the image within LO Write/MS Word, the
resulting document gets large and lags performance.






--
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] LibreOffce 6.2.4 won't start after upgrade on Debian 9.9

[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

On 6/20/2019 1:37 PM, Allen Seelye wrote:

Good afternoon,

I am running Debian 9.9 and the system us fully up-to-date. I tried up
upgrade LibreOffice this morning, and now it will not start.

If I start it from the desktop, the splash screen comes up and the
progress bar moves about 1/3 of the way, then it goes away and nothing
happens.

If I start it from the command line with "libreoffice6.2 --writer", the
same thing happens only the terminal spits out "Application error".

-I've tried logging into the system with a brand new user, same results.
-I've checked to make sure there are no LibreOffice processes running.
-I've done "apt purge LibreOffice*" and verified that anything
LibreOffice is removed from the system, rebooted, then installed and
rebooted again, same problem.
-Tried installing the old version again, no good.

I'm at a loss now. It was working this morning, and told me there was a
new version available, which is what started all of this.

Any ideas?



--
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] Base Firebird reserved words

[Paul D. Mirowsky]

I have recently been battling with the change to Firebird.

When using query, I would continuously get some form of 
'isc_dsql_prepare' errors.


As it turns out, I repeatedly used "Select" as a field name within "Tables".

Changing the field names from "Select" to "Selection" has eliminated all 
of the 'isc_dsql_prepare' errors.


I checked the reserved words for Firebird 2.5 and 3.0.  "Select" is a 
reserved keyword in 2.5.


My suspicion is that there is some kind of misinterpretation during the 
analysis of field name vs keyword when opening 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 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] No corresponding column type could be found for column 'ID'.

[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" from the Firebird-table must be autovalue.
The receiving firebird database two is ID primary key, AutoValue = yes, 
Length = 10


I you will import the table, which all contains text-fields, the wizard
will start. First you have to add the targettablename the content of the
fields should be added to. Mark also "First row will show fieldnames"
(don't know how it is called in English).


Up to this point everything works.

Table name is set correctly and Append Data is checked (circle filled 
with blue)


"Use first line as column names" is already check marked and cannot be 
changed.


Click on "Next" and then message shows "No corresponding column type 
could be found for column 'ID'."


Cannot continue past this message.

  Then goto next and mark all
fields of your importtable except "ID", if this content created new and
shouldn't be moved to the targettable. Switch with the arrow-buttons on
the right the field of the targettable, which should be filled by the
content of your importtable. The field ID of the targettable could be at
the same position as the field of the importtable, because you have
deselected the field ID from the importtable.

Hope this will work for you.

Regards

Robert

--
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] No corresponding column type could be found for column 'ID'.

[Paul D. Mirowsky]

Windows 7 64 bit, Version: 6.2.3.2 (x64)

I have two databases.

Both have "ID" defined as the first field in the databases.

The first database is an import of text files that is unregistered. I 
believe it is Firebird, but do not know how to confirm this. The header 
to the text file has "ID" in the first line, first position and all its 
fields are blank.


Example:

ID;Model;Tube;Position;Date;Time;Ions;Select;Series;Settings
;1-1612-0023-192;1-1617-0009-1759;1.1;2019-05-14;3:32:00 PM;  503075;0;135;100

"ID" field was defined as "Text [ VARCHAR ]" automatically at Import and 
does not define "ID" as a key field.


The second database is firebird registered.

"ID" is defined as "Integer [ INTEGER ]".

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'."


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.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] LO Basic: DialogLibraries contains no elements

[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? 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] Page number messed up in LO Writer 6.2.1/2 and 6.1.5

[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 header no longer
contains the page number itself, it contains the shaded text "Page
Numbers".

This is new as of LO 6.2.1 and 6.2.2, and kind of defeats utterly the
ability to use this field for page numbering.

I tried deleting it and re-inserting, both with Insert -> Page Number
and Insert -> Field -> Page Number.  Same result.

I have attached a brand new .ods document with the same problem - all
I did was insert the page number in a fresh header.  See also the
attached screen image.

For S&G, I reinstalled LO 6.1.5, but it does the same thing with the
older files, and also with a brand new file.

I'm running this on Xubuntu 18.04.2 in a VB VM (here at work - I'll
check again when I get home).

WTH?

Mark Richter, Senior Staff Engineer
http://www.linkedin.com/in/markrichter1
Registered Linux User #472807 http://counter.li.org/
FSF Member #12694 http://www.fsf.org
LO recurring contributor



--
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: Draw changes font when opening pdf text file.

[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 select the substitute fonts.


Hope this helps.


On 3/18/2019 9:44 AM, Malcolm Jaros wrote:

It occurs to me that Draw does not recognise, or does not have, the font used 
for the original document and substitutes one that it does have.
My problem is that the original, serif, font is being substituted by a 
monopitch font.
Regards, MalJaros

- Original Message -
From: "Malcolm Jaros" 
To: "Global Users@" 
Sent: Monday, March 18, 2019 3:27:05 PM
Subject: [libreoffice-users] Re: Draw changes font when opening pdf text file.

I do apologize for not pointing out that I am using 6.2.1.2 on Ubuntu 18.04

Regards, MalJaros


From: "Malcolm Jaros" 
To: "Global Users@" 
Sent: Monday, March 18, 2019 3:24:12 PM
Subject: Draw changes font when opening pdf text file.

Greetings All.
I would like to add a few words to the text embedded in a pdf file.
When the file is opened in Draw the text is displayed, and subsequently saved, 
in a different font from the that in the original file.
This unfortunately changes the line length and hence the page layout, which 
makes the amended copy unusable.
How can I prevent this?
Regards, MalJaros




--
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] Impress window position

[Paul D. Mirowsky]

In Impress under "Slide Show Settings" you should find



Multiple Displays

By default the primary display is used for slide show mode. If the 
current desktop is displayed on more than one display, you can select 
which display to use for full screen slide show mode. If the current 
desktop spans only one display, or if the multi display feature is not 
supported on the current system, you cannot select another display.



  Presentation display

Select a display to use for full screen slide show mode.

If the system allows the user to span a window over all available 
displays, you can also select "All displays". In this case the 
presentation is spanned over all available displays.


From: 
https://help.libreoffice.org/Impress/Slide_Show_Settings#Multiple_Displays


Try this.

Hope it helps.


On 3/14/2019 11:13 AM, malcolm moore wrote:


Impress is on the left screen and I set the slideshow up to display on the 
right so the left is in presenter mode
The full screen presentation goes over everything. If I click on OpenBoard it 
comes to the front but as soon
as you advance to the next slide Impress goes over the top again

Ta

Mal



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

From: Tom Davies (tomc...@gmail.com)
Date: 11/03/19 18:18
To: malcolm moore (st-malcolm.mo...@whsg.info)
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Impress window position

Hi :)
Errr, which OS platform?  Is it some version of Linux (such as Ubuntu,
Mint, Redhat or something) or is it some flavour of Windows (such as Xp,
Vista, Win7, Win8, Win8.1 or Win10 or something?) or is it a Mac or BSD or
something else?

Also do you know if the the 2 screens are really treated as 1 very large
screen?  We can probably help with that if we knew which platform, or
better still which specific OS.

Good luck and regards from a Tom :)



On Mon, 11 Mar 2019 at 08:58, malcolm moore 
wrote:


Is it possible to get Impress  to go full screen for a presentation
without going
over the top of everything - here is the scenario - I have 2 screens, one
is an
interactive whiteboard and I am running OpenBoard. When I start a
presentation
it goes full screen and covers the OpenBoard 'control' panel. If I bring
the OpenBoard
to on top when I move to the next slide Impress goes over the top again
and
hides OpenBoard

Ta

Mal






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



--
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] Impress window position

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

From: Tom Davies (tomc...@gmail.com)
Date: 11/03/19 18:18
To: malcolm moore (st-malcolm.mo...@whsg.info)
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Impress window position

Hi :)
Errr, which OS platform?  Is it some version of Linux (such as Ubuntu,
Mint, Redhat or something) or is it some flavour of Windows (such as Xp,
Vista, Win7, Win8, Win8.1 or Win10 or something?) or is it a Mac or BSD or
something else?

Also do you know if the the 2 screens are really treated as 1 very large
screen?  We can probably help with that if we knew which platform, or
better still which specific OS.

Good luck and regards from a Tom :)



On Mon, 11 Mar 2019 at 08:58, malcolm moore 
wrote:



Is it possible to get Impress  to go full screen for a presentation
without going
over the top of everything - here is the scenario - I have 2 screens, one
is an
interactive whiteboard and I am running OpenBoard. When I start a
presentation
it goes full screen and covers the OpenBoard 'control' panel. If I bring
the OpenBoard
to on top when I move to the next slide Impress goes over the top again
and
hides OpenBoard

Ta

Mal






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




--
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] Help files bad link

[Paul D. Mirowsky]

Sorry about that.

Windows 7 Professional Service Pack 1 (64 Bit)

There are files in:

    C:\Program Files\LibreOffice" which are the default for 64 bit 
programs.


    and

    C:\Program Files\LibreOffice\help\en-US


In 

    LibreOffice 6.1.5.2

    LibreOffice 6.1 Help Pack (English (United States))



On 3/6/2019 8:51 AM, Tanstaafl wrote:

That didn't answer the question...

Do you have the 32bit or 64bit version of the application and/or Help
installed?

Look in the Programs and Features control panel to see what versions are
installed.

On Tue Mar 05 2019 10:50:22 GMT-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" has HTML files.

When  on "main.html" results on Firefox URL
"file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html"
and displays correctly in browser.

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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Help files bad link

[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 you using LibreOffice on Windows.
It was solved by checking that the user interface language (Tools ->
Language settings -> User interface) was the same of that of the Help file
that you installed.

As an aside this problem doesn't arise under Linux as both the user
interface and the help are installed separately and will automatically have
the same language.  This is not the case with the Windows version and hence
someone not in the know can install LibreOffice in say the UK and
automatically have the user interface set to UK English.  If then the help
file for say US English is installed it will not be available.

Graham


On Tue, 5 Mar 2019 at 16:05, Paul D. Mirowsky 
wrote:


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" at URL
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"

I'm am not sure of the context of the {Defaults} button, but am assuming
it does not mean correcting the URL because it doesn't.

Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:

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 "Options - LibreOffice - Paths".  Maybe it
should.

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://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] Help files bad link

[Paul D. Mirowsky]

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" has HTML files.


When  on "main.html" results 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 2019 10:03:45 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:

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" at URL
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"

I'm am not sure of the context of the {Defaults} button, but am assuming
it does not mean correcting the URL because it doesn't.

Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:

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 "Options - LibreOffice - Paths".  Maybe it
should.

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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Help files bad link

[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" at URL 
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"


I'm am not sure of the context of the {Defaults} button, but am assuming 
it does not mean correcting the URL because it doesn't.


Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:
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 "Options - LibreOffice - Paths".  Maybe it 
should.


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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Help files bad link

[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 "Options - LibreOffice - Paths".  Maybe it should.

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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Paul D. Mirowsky]

Ok, this is what happened.

Opening the "2 Amps to Volts-High by Series"

    By main "Queries", right click and choose "Edit"

        In view, changed 134 to '134'

            Message: Warning    The entered criterion cannot be 
compared with this field.


        Remove 134 from Series and hit enter.

             results in all records

        Add 134 to Series and hit enter.

             results in just 134 Series records.

        Query Design 

    Double left click on query name "2 Amps to Volts-High by Series"

        Message: The data content could not be loaded.

                        Error code: 1

             firebird_sdbc error:
                        *Dynamic SQL Error
                        *SQL error code = -104
                        *Invalid usage of boolean expression
                        caused by
                        'isc_dsql_prepare'

By main "Queries", right click and choose "Edit in SQL view..."

        Remove AND "Amps"."Series" = '134'

             results in all records

        Add AND "Amps"."Series" = '134'

             results in just 134 Series records.

        Remove Add AND "Amps"."Series" = '134' and add Add AND 
"Amps"."Series" = 134


             results in just 134 Series records.

Saved the query in multiple states

When ever I save the Query and double left click from main Query window 
on "2 Amps to Volts-High by Series"


    Results in error message:

               firebird_sdbc error:
                            *Dynamic SQL Error
                            *SQL error code = -104
                            *Invalid usage of boolean expression
                            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 Query Design view in which I have a field Series set to 134.

I remove the 134 and press enter.

Run Query (F5)

It works.

Save it at this point. Don't switch back. Does this work?

Then try
"Equipment"."Series" = '134'
instead of
"Equipment"."Series" = 134
before.

Regards

Robert


--
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] Base/Firebird Queries broken

[Paul D. Mirowsky]

When editing the query, it works using RunQuery (F5)

After editing and it is working, I save the Query.

Then clicking on the saved Query from main Query window results in error 
again.


On 1/16/2019 1:06 PM, Drew Jensen wrote:

So, can you open that Query definition, the one that raised 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 the 134 and press enter.

Run Query (F5)

It works.

Add back in 134 to Series field.

It works

Save it and save the database.

Double click on the query to run 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, Paul D. Mirowsky wrote:

I am receiving the following error when opening a query.


firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

The table names are: Amps   Volts-High

The two tables involved both have one boolean field each, so I 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://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] Re: Base/Firebird Queries broken

[Paul D. Mirowsky]

Hello Drew

I assumed that you are answering the question on error 104.

I changed the file as per your instructions to

db:parameter-name-substitution="true"

, but error 104 is still there.

Do I have to go back to my original file a migrate again with this fix 
or am I fixing


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 looks like this is what is biting you.

The fastest way to fix it is at follows:
Close the base file and exit LibreOffice.
Rename the base file from .odb to .zip
Now open the file with your favorite zip tool.
You fill find a file named content.xml in the root of the file.
Open that with a text editor.
Search for this string: db:parameter-name-substitution="false"
Edit that so that it reads db:parameter-name-substitution="true"
Save your changes.
Close the zip file, it should ask if you want to update the file with the
change and answer yes.
Change file name back to .odb and you should be good to go.

Best wishes,

Drew

On Wed, Jan 16, 2019 at 11:27 AM Paul D. Mirowsky 
wrote:


Found this at

https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1

|SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
  >= 2.1 Only problem is, when run as "Execute SQL Statement" menu item,
it errors as

1: firebird_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/2019 à 00:19, Paul D. Mirowsky a écrit :

Invalid usage of boolean expression

This bug perhaps ?



http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel

Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 ?


Alex


--
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] Base/Firebird Queries broken

[Paul D. Mirowsky]

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 the 134 and press enter.

Run Query (F5)

It works.

Add back in 134 to Series field.

It works

Save it and save the database.

Double click on the query to run 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, Paul D. Mirowsky wrote:

I am receiving the following error when opening a query.


firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

The table names are: Amps   Volts-High

The two tables involved both have one boolean field each, so I 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://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: Base/Firebird Queries broken

[Paul D. Mirowsky]

Found this at 
https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1


|SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION 
>= 2.1 Only problem is, when run as "Execute SQL Statement" menu item, 
it errors as
1: firebird_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/2019 à 00:19, Paul D. Mirowsky a écrit :

Invalid usage of boolean expression


This bug perhaps ?

http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel

Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 ?


Alex



--
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: Base/Firebird Queries broken

[Paul D. Mirowsky]

I have replaced blanks with underscores in field names in tables.

I have removed alias named fields from queries.

It did not appear to make a difference.

I should note that tables Amps, Volts-High and  Volts-In have the same 
or more field names.


As each table name is prefixed to a field, I 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",
"Equipment"."P_Model_No", "Equipment"."Power Meter",

Check that the space in the field "Power Meter" isn't causing an issue.

There was a known bug about spaces being misinterpreted by the parser.



"Equipment"."Series", "Equipment"."Power Meter 2", "Equipment"."Power_No
2", "Equipment"."Power Meter 3", "Equipment"."Power_No 3",

Same here for "Power Meter 2" and "Power Meter 3"




"Ions-IM"."Ions", "Ions-IM"."Select", "Ions-IM"."Series",

Also check that the field name "Select" in Ions-IM.Select isn't being
misinterpeted.



"Volts-High"."Time", "Volts-High"."Reading" "Vo-Hi-Reading",

What is "Vo-Hi-Reading" - is this supposed to be an ALIAS ? Maybe check
whether that is correctly supported.


"Volts-High"."Type" "Vo-Hi-Type", "Volts-High"."Series",

Same here with "Vo-Hi-Type"



"Volts-High"."Setting", "Amps"."Reading" "Am-Reading", "Amps"."Type"

Same here with "Am-Reading"



"Am-Type", "Amps"."Series", "Amps"."Setting" FROM "Ions-IM",
"Equipment", "Volts-High", "Amps" WHERE "Ions-IM"."Series" =
"Equipment"."Series" AND "Volts-High"."Series" = "Ions-IM"."Series" AND
"Volts-High"."Date" = "Ions-IM"."Date" AND "Volts-High"."Time" =
"Ions-IM"."Time" AND "Amps"."Series" = "Volts-High"."Series" AND
"Amps"."Date" = "Volts-High"."Date" AND "Amps"."Time" =
"Volts-High"."Time" AND "Equipment"."Series" = 134 AND
"Ions-IM"."Select" = TRUE ORDER BY "Ions-IM"."Date" ASC,
"Ions-IM"."Time" ASC, "Ions-IM"."Ions" ASC

Not sure about how many left join conditions you can currently have.
That would probably need checking by removing them one-by-one until you
get something that works.


As Robert has mentioned, perhaps the migration didn't convert the data
types correctly, so your comparisons in the join conditions are no
longer working.


Good luck !


Alex



--
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] Base/Firebird Queries broken

[Paul D. Mirowsky]

I am receiving the following error when opening a query.


firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

The table names are: Amps   Volts-High

The two tables involved both have one boolean field each, so I 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://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: Base/Firebird Queries broken

[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 import the field as a INTEGER field?

Not quite. Series is set to Number [Numeric]


There is no function in the query, only 4 tables connected ...
The only possibility to find the reason why Firebird couldn't execute
the query at this moment is to delete some parts of the query and try if
it will work without this parts.

By the way: There are only tables connected in theis query, not a view
connected with tables?
Not sure what you mean. These queries are developed to be linked to a 
Writer document as test data documentation. It is used to check the 
quantity of readings per unit at two each. Incorrect quantities of 
records prove data missing or inaccurate on import to Base.


Regards

Robert


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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Paul D. Mirowsky]

Here is the query...

SELECT "Equipment"."ID", "Equipment"."P_Model", 
"Equipment"."P_Model_No", "Equipment"."Power Meter", 
"Equipment"."Power_No", "Equipment"."Ion Meter", "Equipment"."Ion_No", 
"Equipment"."Series", "Equipment"."Power Meter 2", "Equipment"."Power_No 
2", "Equipment"."Power Meter 3", "Equipment"."Power_No 3", 
"Equipment"."Vendor_PO_No", "Ions-IM"."Model", "Ions-IM"."Tube", 
"Ions-IM"."Position", "Ions-IM"."Date", "Ions-IM"."Time", 
"Ions-IM"."Ions", "Ions-IM"."Select", "Ions-IM"."Series", 
"Volts-High"."Time", "Volts-High"."Reading" "Vo-Hi-Reading", 
"Volts-High"."Type" "Vo-Hi-Type", "Volts-High"."Series", 
"Volts-High"."Setting", "Amps"."Reading" "Am-Reading", "Amps"."Type" 
"Am-Type", "Amps"."Series", "Amps"."Setting" FROM "Ions-IM", 
"Equipment", "Volts-High", "Amps" WHERE "Ions-IM"."Series" = 
"Equipment"."Series" AND "Volts-High"."Series" = "Ions-IM"."Series" AND 
"Volts-High"."Date" = "Ions-IM"."Date" AND "Volts-High"."Time" = 
"Ions-IM"."Time" AND "Amps"."Series" = "Volts-High"."Series" AND 
"Amps"."Date" = "Volts-High"."Date" AND "Amps"."Time" = 
"Volts-High"."Time" AND "Equipment"."Series" = 134 AND 
"Ions-IM"."Select" = TRUE ORDER BY "Ions-IM"."Date" ASC, 
"Ions-IM"."Time" ASC, "Ions-IM"."Ions" ASC


I have several others that continue to work correctly.  I am going to 
try to see if the failure applies to a particular table(s).


Thanks

Paul

On 1/15/2019 3:06 AM, Alexander Thurgood wrote:

Le 15/01/2019 à 00:23, Paul D. Mirowsky a écrit :


Any hint as to where I'm going wrong.

Without the query definition, it is going to be like gazing into a
crystal ball...all sorts of things might not work in the same way, the
time values, the date values (especially if there are calculations),
subselects, unions, joins, etc...


Alex



--
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] Base/Firebird Queries broken

[Paul D. Mirowsky]

I have shifted one of my database to Firebird using the advanced 
'migration' tool as a test.


One query I am testing is a join of 4 tables.

Series
Series
Series
Series

Date
DateDate

Time
TimeTime

Criterion: Series 134, Select True

I do have Alias fields, but understand from net search that they are 
disregarded by Firebird.


I have waited 5 minutes for the query to process, but it only results in 
a blank screen or not responding.


Windows 7 64 bit. LibreOffice Version: 6.1.3.2 (x64)

The query did work with HSQLDB.

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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Paul D. Mirowsky]

This is a shot in the dark.

Look for lines defined as narrower in height and resize them.

It would not be surprising that PDF's produced by OSX have some portion 
of the Print PDF definition that recognizes control codes in one way is 
not under Windows/Linux PDF Printer definition for LibreOffice.  It may 
also be that substituting fonts may change behavior.


I suggest using installing cups-pdf under linux to see if this resolves 
the difference.  Apple controls cups-pdf and might be a work around.


I may be wrong here, but I think LibreOffice uses Ghostscript and OSX 
uses CUPS.

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 on Windows and Linux but different on OSX. I would like 
to say that it is probably not related to PDF because the print 
preview shows the same issue.





--
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] vertical placement of charts while saving to pdf is wrong

[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: 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] vertical placement of charts while saving to pdf is wrong

[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, VisibleArea, Position, Size). I
do not know where to search. No help on internet either.

Am I the only one?

I tried to make an simple example but cannot reproduce exactly what I
have on my big file. One think I noticed is the following, when I
click on the chart, I can see the 8 blue handles and also the coutour
of the chart as dashed line and the dashed contour is not superimposed
with the blue handles but shifted by a few lines up (see attached
image). Normally they match.

I have the impression that the charts are shifted when I duplicate a
worksheet...

Kind regards,

F




--
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] side by side tables

[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 "Insert manual column break from the Insert menu".


Tested on Win7 with LibreOffice Version: 5.4.7.2 (x64)

It is very likely that you can automate this function by  
for a Menu of your own.


Hope this helps.


On 9/26/2018 1:42 AM, Gary Collins wrote:

Hi
Ive found out how to resize tables so they dont take up the full page width 
(though to be honest i usually find it easier and more flexible to simply 
include an additional  empty column to right and left and adjust widths as 
required) but what i would really like to be able to do is to have two (or 
perhaps more) tables juxtaposed horizontally. Is there a way to align tables 
horizontally (without resorting to frames, which i tend to find are a right 
pain in the proverbials)?
Im currently using version 5.2.2.2 build 1:5.2.2-0ubuntu2.1
Thanks
Gary




--
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] Issues with macro recorder??

[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 tried again and most of it worked, but some issues came up.

First, entered a formula, and it worked in the recording, but in playing the
macro it failed. Was able to modify the lines, and got it to work.

dim args7(0) as new com.sun.star.beans.PropertyValue
args7(0).Name = "StringName"
args7(0).Value = "=if(I1=""Life"";""12/18"";i1)"

Had to add the double quotes versus how it was recorded.

Second issue was it deleted two different columns. When recording clicked
on the column with mouse, and deleted each column. Record didn't record
anything of clicking on the columns, but just the delete command. Added a
goto cell and got that to work as well.

dim args16(0) as new com.sun.star.beans.PropertyValue
args16(0).Name = "ToPoint"
args16(0).Value = "$h$1"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args16())

rem --
dispatcher.executeDispatch(document, ".uno:DeleteColumns", "", 0, Array())

dim args17(0) as new com.sun.star.beans.PropertyValue
args17(0).Name = "ToPoint"
args17(0).Value = "$L$1"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args17())

rem --
dispatcher.executeDispatch(document, ".uno:DeleteColumns", "", 0, Array())


++
  Michael D. Setzer II - Computer Science Instructor (Retired)
  mailto:mi...@guam.net
  mailto:msetze...@gmail.com
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
++

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS

ROSETTA  65755566.519455 | ABC  16613838.513356
SETI109507116.947618 | EINSTEIN141355143.499240





--
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] Spell checking etc does not work

[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 with F7. At the top of the window is a 
place to indicate text language, which when the window opens says 
.  The two options are English (UK) or English (USA).  Preceding 
each option is a blue check mark with in a small font the letters ABC. 
When I click on one or other of these options nothing happens; the 
selection box still says .  So I cannot check spelling, or have 
hyphenated words.


Comments/suggestions anybody?

Regards, Ken



 on text.
 on "Styles"
 on "Edit Style"
On "Font" tab.
Check what is next to "Language" at bottom.
If blank, change to preferred language.

This was the only way I could get spell check to work.

Hope this helps.


--
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] After upgrading to libreoffice 6.0.6, unable to save files to samba shares

[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, Howard Fleming wrote:

Good afternoon,

I have run into an interesting issue with a small network I maintain.

Server is CentOS with Samba services (up to date with patches and 
updates).


When using Libreoffice 5.x, I am able to open, create, edit and save 
files on the network without any issues.


After upgrading Libreoffice to 6.0.6, anytime I go to edit an existing 
file on the network, I get:


The lock file could not be created for exclusive access by LibreOffice 
due to missing permission to create the lock file on that file 
location or lack of free disk space.


Neither of the above conditions exist.  If I continue and open the 
file as read only, when I try to save it on the network I get:


This file cannot be edited, possibly due to missing access rights. Do 
you want to edit a copy of the document?


If I attempt to save the file in the same location, but with a 
different file name, I get:


Error saving the document Untitled 1:  Object not accessible.  The 
object cannot be access due to insufficient user rights.


If I then attempt to save the document to the local drive (C), it 
works as expected.


So far in searches have not found anything referencing this issue 
except for one tech document on Novell.


This ONLY affects Libreoffice, MS office on the same machine does not 
have any issues.


I have rolled Libreoffice back to version 5 on one machine that having 
this issue, and it opens and saves files without any issues.


Any suggestions?

Thanks,
Howard







--
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] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

[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 PM, Eddie wrote:

I watched it just fine on Vivaldi 1.15, Windows 10. I'm stoked about
the new icon sets!

On Wed, 8 Aug 2018 11:13:07 -0400
"Paul D. Mirowsky"  wrote:


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 Davies wrote:

Hi :)
Mike Saunders and the rest of the marketing team (and translators)
have made a video showing the new features in LibreOffice 6.1.0.

https://www.youtube.com/watch?v=JvoCpnwGNFU

I think some of the new features are things that have been asked
about quite recently- and might mean we have better answers for
those questions now.

Be wary though !!  This is the .0 release and it's only just been
releasedtoday so this is THE point at which the most unexpected and
unlikely breakages of functionality may occur !  It is also the
BEST time to try out he new version AWAY from your regular install
preferably on a system you don't rely on for work or in a sandboxed
area (Gnu&Linux has MANY different ways of creating safe-areas to
try things out in).

It is THE time that the most devs are focusing on this new release
so it's the best time to find bugs or features that have gone wonky
and post bug-reports about them.

This is also a good time to join the QA Team to help them with
filing&admin tasks, and perhaps asking bug-reporters for relevant
information that might help the devs handle their request and
generally help with first responses.

Good luck and regards from
a Tom :)




On Wed, 8 Aug 2018 at 11:13, Mike Saunders <
mike.saund...@documentfoundation.org> wrote:
  

On 07/08/2018 16:01, Mike Saunders wrote:

2) There is a new video for LibreOffice 6.1; I'll provide the
updated URL tomorrow just before launch.

Here it is:

https://www.youtube.com/watch?v=JvoCpnwGNFU

Mike

--
To unsubscribe e-mail to: l10n+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/l10n/ 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] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

[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 Davies wrote:

Hi :)
Mike Saunders and the rest of the marketing team (and translators) have
made a video showing the new features in LibreOffice 6.1.0.

https://www.youtube.com/watch?v=JvoCpnwGNFU

I think some of the new features are things that have been asked about
quite recently- and might mean we have better answers for those questions
now.

Be wary though !!  This is the .0 release and it's only just been
releasedtoday so this is THE point at which the most unexpected and
unlikely breakages of functionality may occur !  It is also the BEST time
to try out he new version AWAY from your regular install preferably on a
system you don't rely on for work or in a sandboxed area (Gnu&Linux has
MANY different ways of creating safe-areas to try things out in).

It is THE time that the most devs are focusing on this new release so it's
the best time to find bugs or features that have gone wonky and post
bug-reports about them.

This is also a good time to join the QA Team to help them with filing&admin
tasks, and perhaps asking bug-reporters for relevant information that might
help the devs handle their request and generally help with first
responses.

Good luck and regards from
a Tom :)




On Wed, 8 Aug 2018 at 11:13, Mike Saunders <
mike.saund...@documentfoundation.org> wrote:


On 07/08/2018 16:01, Mike Saunders wrote:

2) There is a new video for LibreOffice 6.1; I'll provide the updated
URL tomorrow just before launch.

Here it is:

https://www.youtube.com/watch?v=JvoCpnwGNFU

Mike

--
To unsubscribe e-mail to: l10n+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/l10n/
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] Glosses in linguistics

[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 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 Contents and Index - Index Entry*, and
    do one of the following:

  * To change the text that appears in the index, type the text that
    you want in the *Entry*box. The text that you type here does not
    replace the selected text in the document.
  * To add an index mark to similar words in your document, select
    *Apply to all similar texts*.
  * To add the entries to a custom index, click the *New User-defined
    Index* icon, enter the name of the index, and then click *OK*.


Then...



    To Apply a Different Paragraph Style to an Index Level

 1. Right-click in the index or table of contents, and then choose
    *Edit Index or Table of Contents*.
 2. Click the *Styles* tab.
 3. Click an index level in the *Levels* list.
 4. Click the style that you want to apply in the *Paragraph Style* 
list.

 5. Click the assign button *<*.
 6. Click *OK*.

From: 
https://help.libreoffice.org/Writer/Defining_Index_or_Table_of_Contents_Entries 
and 
https://help.libreoffice.org/Writer/Formatting_an_Index_or_a_Table_of_Contents


Hope this helps.


On 6/8/2018 3:52 PM, John Jason Jordan wrote:

Linguists frequently need to write glosses. Here are a couple examples
using Spanish as the source language and English as the language that
the author is writing in:

Todos iremos   a   la playa.
All.m.pl  go.1.pl.fut  to  the.art.sg.fem  beach
'We will all go to the beach.'

Juan no sabía    qué    hacer.
John neg.  know.1.sg.imperf  what  do.inf
'John didn't know what to do.'

(Note that there are rules for how the gloss abbreviations are supposed
to be abbreviated and used, and for the sake of simplicity in the above
examples I did not always follow them rigorously.)

Glosses are typically three lines, as in the above examples. Each
component of the first two lines must be lined up. Here in e-mail I
tried to do this with the space bar, but the results may not appear
perfectly as I intended for all people on this list. They don't even
appear lined up for me because I use a proportional font in my mail
client.

The only way I know to get this right is to use tabs, but the tab
spacings have to be changed for each gloss. If you have a lot of
glosses in your paper tabs will quickly become a serious pain.

I searched the Help, but came up empty-handed. Any suggestions?







--
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] Glosses in linguistics

[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 Contents and Index - Index Entry*, and
do one of the following:

  * To change the text that appears in the index, type the text that
you want in the *Entry*box. The text that you type here does not
replace the selected text in the document.
  * To add an index mark to similar words in your document, select
*Apply to all similar texts*.
  * To add the entries to a custom index, click the *New User-defined
Index* icon, enter the name of the index, and then click *OK*.


Then...



To Apply a Different Paragraph Style to an Index Level

 1. Right-click in the index or table of contents, and then choose
*Edit Index or Table of Contents*.
 2. Click the *Styles* tab.
 3. Click an index level in the *Levels* list.
 4. Click the style that you want to apply in the *Paragraph Style* list.
 5. Click the assign button *<*.
 6. Click *OK*.

From: 
https://help.libreoffice.org/Writer/Defining_Index_or_Table_of_Contents_Entries 
and 
https://help.libreoffice.org/Writer/Formatting_an_Index_or_a_Table_of_Contents


Hope this helps.


On 6/8/2018 3:52 PM, John Jason Jordan wrote:

Linguists frequently need to write glosses. Here are a couple examples
using Spanish as the source language and English as the language that
the author is writing in:

Todos iremos   a   la playa.
All.m.pl  go.1.pl.fut  to  the.art.sg.fem  beach
'We will all go to the beach.'

Juan no sabíaquéhacer.
John neg.  know.1.sg.imperf  what  do.inf
'John didn't know what to do.'

(Note that there are rules for how the gloss abbreviations are supposed
to be abbreviated and used, and for the sake of simplicity in the above
examples I did not always follow them rigorously.)

Glosses are typically three lines, as in the above examples. Each
component of the first two lines must be lined up. Here in e-mail I
tried to do this with the space bar, but the results may not appear
perfectly as I intended for all people on this list. They don't even
appear lined up for me because I use a proportional font in my mail
client.

The only way I know to get this right is to use tabs, but the tab
spacings have to be changed for each gloss. If you have a lot of
glosses in your paper tabs will quickly become a serious pain.

I searched the Help, but came up empty-handed. Any suggestions?




--
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] How many of you deal with the Linux Users Group [Facebook]?

[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 readers, 
Braille devices or speech recognition input devices. The Java Runtime 
Environment must be installed on your computer before you can enable 
assistive support.



https://help.libreoffice.org/Common/Accessibility

It is not clear to me how well HTML export works

See: https://developer.mozilla.org/en-US/docs/Web/Accessibility/ARIA for 
how to use it.


Sorry if I've duplicated, but this is long list of e-mails.



On 5/2/2018 9:08 AM, Virgil Arrington wrote:

On 05/02/2018 08:07 AM, toki wrote:

In order of accessibility:
* Plain text;
* MS Doc;
* MS Docx;
* RTF;
* ODT;


jonathon


Interesting list. I've always liked working with plain text files.

Do you have any information/opinion about various forms of markdown
files (i.e. Markdown, RestructureText, AsciiDoc).

This semester, I played with making slide presentations using AsciiDoc
and its "slidy" backend.

The source file might look something like:

===
Title
===

Slide Title
--

* A Bulleted item

** A nested bulleted item with *boldface* type.
** Another nested bulleted item with _italicized_ text.

Another Slide Title
--


After creating the document, I run it through AsciiDoc's converter and
it creates a very simple slide presentation in HTML format. However, the
source file remains plain text. Would a screen reader get tripped up by
the various formatting tags (* A Bulleted item; _italics_, *boldface*)?

Virgil




--
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] using/printing of non-std paper formats

[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 are
not predefined in LibreOffice (8x12 and different custom labels
(autocutting device)).
I can set the page dimensions manually (e.g. in Writer), but no way  to
use the corresponding (in ppd defined) paper formats in the printer
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.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] Graphic Editing

[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 block/frame as an overlay.

Hope this helps.


On 4/16/2018 12:48 PM, charles meyer wrote:

Hi Folks.



I’m trying to figure out the best way to delete/edit a graphic.



I imported a 2 page PDF into Libre Draw (5.1.1.3).



It’s not clear how I can delete content (in a column shape) on the first
page of the PDF leaving the rest of the content on that first page intact.



I tried drawing a box around that column and clicking the Scissors icon
but it did not cut nor delete that content.



Can you pls. share the necessary steps?



Thank you.



Charles.




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

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

[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://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] 5.4.2 won't install on Windows 10

[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 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] adding / using custom colours to LibreOffice

[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 whom have standard
colours that I would like to add to the LibreOffice colour palette.

For those that insist on creating colour palettes from within LibO:
* Install the _Colour Palette Exporter_ extension;
* Create the desired palette by modifying the font colour of a paragraph
style;
* Export the resulting palette;

Those who prefer to do things the easy way:
* Fire up a text editor;
* Start writing the appropriate xml code;
* Save the palette;

My recommendation is that if organisation branding includes predefined
colours for charts, then the filename has to be standard.soc, otherwise
use Organisation_Name_Branding.soc .

Distribute the palette to the organization.
Include instructions on how to correctly install the palette.

Installation instructions differ according to one's specific platform.
(For at least one Linux distro, colour palettes can not be customized,
unless you have support contract with the distro vendor.)

jonathon




--
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] system sound + Libreoffice

[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.
Although I have set Windows (10) system sounds to "no sound",
in more or less frequent intervals the systems starts beeping (e.g.,  
when switching to Caps Lock).


This happens ***ONLY*** when I am using Libreoffice.
It used to go away, when I reset the "no sound".
By now, this does not work any longer. The computer annoyingly keeps  
"beeping me crazy".


Is there a trick to stop that behavior???

Thank you
Thomas





--
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] word count in impress

[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 helps
On 10/2/2017 12:13 PM, Thomas Blasejewicz wrote:

Good evening
It happens once in a while .. I have to work (translate) PPT files for  
which I use Impress and then need to know the number of words.

In the entire file.
So far I could not figure out, whether there is a way to count all  
words in an Impress file.
(A similar question posted on the net somewhere was "closed, because  
it is irrelevant" ???)


Today I found, that one can get a word count in the real PPT by  
looking at properties.


Is there such a trick for Impress?

Thank you.
Thomas




--
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] Reading from a USB device. Additional Realterm Info

[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 at Realterm

Realterm is an engineers terminal program specially designed for 
capturing, controlling and debugging binary and other difficult data 
streams. It is the best tool for debugging comms.


Post-Processing capture file is just one of many things it can do.

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 automatically installed the appropriate
driver/s.  I am attempting to read the MIDI input from the keyboard as I
want to see if I can use a Macro to modify the sound before it goes 
to the
speaker.   (Actually I want to try to programmatically mix sine waves 
like

a Hammond Organ does - it may not be possible, but I'd like to give it a
try!)

I installed a trial version of Device Monitoring Studio,   see
https://www.hhdsoftware.com/device-monitoring-studio    which enables 
me to

trap the raw data from the keyboard, and I'm able to identify which keys
are pressed or released, and also the keyboard sliders' movements and
slider positions.  For my purposes, that is all I need to extract 
from the

MIDI stream.

I then went on the Web to see if I could find examples of Macro code 
that
would enable my program to emulate what I had been able to do with 
Device

Monitoring Studio.  It turns out that USB coding is very complex and the
only examples I could find were in C, C++ or Visual Basic, none of 
which I

have, or have ever worked with.

I then had a look at LibreOffice 5.3 SDK API.  I believe that is the API
that Base uses, and over several years I have developed a number of
databases using macros that make calls to the API. One API service I 
found
was,  com.sun.star.io.pipe,  which looks as though it might be what I 
need,
but I don't know if it would work with a USB port, and I could not 
find any

macro code examples that might point me in the right direction.

So my questions are -
1.  Does anyone know if it is possible to read from a USB port using a
LibreOffice macro utilising the API?  If so can you point me to some
example code (preferably in Basic)?
2.  Failing that, is there a simple application on the market that 
can read
a USB MIDI stream into a buffer or file?  I think Device Monitoring 
Studio
can do that, but it is expensive and has far more features than I'll 
ever

need.

Any help in this regard would be much appreciated

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com







--
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] Reading from a USB device.

[Paul D. Mirowsky]

You may want to take a look at Realterm

Realterm is an engineers terminal program specially designed for 
capturing, controlling and debugging binary and other difficult data 
streams. It is the best tool for debugging comms.


Post-Processing capture file is just one of many things it can do.

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 automatically installed the appropriate
driver/s.  I am attempting to read the MIDI input from the keyboard as I
want to see if I can use a Macro to modify the sound before it goes to the
speaker.   (Actually I want to try to programmatically mix sine waves like
a Hammond Organ does - it may not be possible, but I'd like to give it a
try!)

I installed a trial version of Device Monitoring Studio,   see
https://www.hhdsoftware.com/device-monitoring-studiowhich enables me to
trap the raw data from the keyboard, and I'm able to identify which keys
are pressed or released, and also the keyboard sliders' movements and
slider positions.  For my purposes, that is all I need to extract from the
MIDI stream.

I then went on the Web to see if I could find examples of Macro code that
would enable my program to emulate what I had been able to do with Device
Monitoring Studio.  It turns out that USB coding is very complex and the
only examples I could find were in C, C++ or Visual Basic, none of which I
have, or have ever worked with.

I then had a look at LibreOffice 5.3 SDK API.  I believe that is the API
that Base uses, and over several years I have developed a number of
databases using macros that make calls to the API. One API service I found
was,  com.sun.star.io.pipe,  which looks as though it might be what I need,
but I don't know if it would work with a USB port, and I could not find any
macro code examples that might point me in the right direction.

So my questions are -
1.  Does anyone know if it is possible to read from a USB port using a
LibreOffice macro utilising the API?  If so can you point me to some
example code (preferably in Basic)?
2.  Failing that, is there a simple application on the market that can read
a USB MIDI stream into a buffer or file?  I think Device Monitoring Studio
can do that, but it is expensive and has far more features than I'll ever
need.

Any help in this regard would be much appreciated

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.com




--
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: LO 5.2.6 crashes when logging in to mysql with Base

[Paul D. Mirowsky]

Nothing specific, but it is an edge case sometimes missed when 
updating/adding other linux software.


Have you seen 
https://ask.libreoffice.org/en/question/79135/how-do-i-set-up-a-odbc-connector-for-mariadb-in-base/



On 7/6/2017 1:11 PM, Girvin Herr wrote:
Thanks for your response. groups? In what way? Anything specific I 
should be aware of from your experience? Does something with LO 
require a special group, like k3b "suggests" a "burner" group, which I 
would need to be a member of to burn CDs? I just checked the group 
file and didn't see anything out of the ordinary or any group I should 
be a member of and am not.


Since this problem seems ubiquitous across many LO versions and across 
other user accounts on my machine that I tested, I am now doubting 
this issue is a LO problem. Although it may be a problem which only LO 
encounters, since no other apps, including AOO, are having any 
problems. I am going off to do some troubleshooting with another 
similar computer which has not been updated yet since the end of 
March. Hopefully, it will work and I can incrementally install the 
security updates one at a time while retesting LO for 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 wrote:

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 try 
to log
in to Mariadb to access my database, LO crashes hard. This worked 
fine
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the 
Java

config under Options and it is fine. I tried deleting the profile
directory and starting from scratch. It still crashed. LO also 
crashes

when I use the "Test Connection" button in the database configuration
dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Could be several things, although off the cuff, LO5.2.x was known to
crash in certain circumstances with JDKu112, so either:
- revert back to LO5.1.x or else
- try updating your JDK to a much more recent one and see if that 
makes

a difference with LO5.2.x, or else
- move to LO5.3.x and a current JDK.


Why do I mention a Java problem ? Because the devs changed the version
number recognition pattern for JDK/JVM instantiation somewhere between
5.1 and 5.2, and this is what caused crashing for some. This was fixed
in 5.3. Of course, it could all be specific to your Slackware setup...

Alex



Alex,
Thanks for your prompt response. I have been working on this problem 
all morning. I first upgraded jdk-8u112 with jdk-8u131 with the same 
results. I then tried LO 5.2.7.2 with the same results. I then tried 
LO 5.3.4.2 with the same results. I then upgraded the MySQL 
Connector from 5.1.40 to 5.1.42 with the same results. Nothing I do 
seems to affect whatever is causing LO to crash. I also started LO 
from a console to see if LO spit out any pertinent messages when it 
crashed - none.


Whatever is happening here, it is broad. I even tried to use my 
OpenOffice Base odb file with the same LO results. Now this file 
works fine in AOO.


There are two datapoints I had not thought of when I posted my 
message yesterday. One is that I successfully edited and printed a 
report on 6/19/17 with LO 5.2.6.2. So, it was working at that time.


The other is that I upgraded glibc from version 2.23 build 1 to 2.23 
build 2 yesterday, before I noticed LO crashing. But I tried 
returning to the old glibc version and LO still crashed, so I doubt 
glibc was the cause. The other Slackware packages that I changed 
yesterday are: bind, irssi, mozilla-firefox, openvpn, sudo, the 
Linux kernel, httpd, libcgroup, libcrypt, mkinitrd, 
mozilla-thunderbird, nasm, and pkg-config. None of these should have 
affected LO, but...


There is something else going on besides Base crashing. I was 
checking the "Tools" | "Options" with nothing loaded and when I got 
to the bottom item, "Internet" | "MediaWiki", LO crashed when I 
selected it. I wasn't even close to MySQL or Base at the time.


BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux and 
Java, 8GB RAM, and 10% of 1TB disk space used. So it shouldn't be a 
lack of resources. Besides, as I said, OpenOffice is still running 
fine. My problem with using AOO, is that it does not have the Base 
Report Generator I need to print my reports.


Hope this helps narrow this problem down. I am about to issue a bug 
report on this. It is certainly repeatable, if frustrating.

Thanks.
Girvin











--
To unsubscribe e-mail 

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

[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 try to 
log

in to Mariadb to access my database, LO crashes hard. This worked fine
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java
config under Options and it is fine. I tried deleting the profile
directory and starting from scratch. It still crashed. LO also crashes
when I use the "Test Connection" button in the database configuration
dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Could be several things, although off the cuff, LO5.2.x was known to
crash in certain circumstances with JDKu112, so either:
- revert back to LO5.1.x or else
- try updating your JDK to a much more recent one and see if that makes
a difference with LO5.2.x, or else
- move to LO5.3.x and a current JDK.


Why do I mention a Java problem ? Because the devs changed the version
number recognition pattern for JDK/JVM instantiation somewhere between
5.1 and 5.2, and this is what caused crashing for some. This was fixed
in 5.3. Of course, it could all be specific to your Slackware setup...

Alex



Alex,
Thanks for your prompt response. I have been working on this problem 
all morning. I first upgraded jdk-8u112 with jdk-8u131 with the same 
results. I then tried LO 5.2.7.2 with the same results. I then tried 
LO 5.3.4.2 with the same results. I then upgraded the MySQL Connector 
from 5.1.40 to 5.1.42 with the same results. Nothing I do seems to 
affect whatever is causing LO to crash. I also started LO from a 
console to see if LO spit out any pertinent messages when it crashed - 
none.


Whatever is happening here, it is broad. I even tried to use my 
OpenOffice Base odb file with the same LO results. Now this file works 
fine in AOO.


There are two datapoints I had not thought of when I posted my message 
yesterday. One is that I successfully edited and printed a report on 
6/19/17 with LO 5.2.6.2. So, it was working at that time.


The other is that I upgraded glibc from version 2.23 build 1 to 2.23 
build 2 yesterday, before I noticed LO crashing. But I tried returning 
to the old glibc version and LO still crashed, so I doubt glibc was 
the cause. The other Slackware packages that I changed yesterday are: 
bind, irssi, mozilla-firefox, openvpn, sudo, the Linux kernel, httpd, 
libcgroup, libcrypt, mkinitrd, mozilla-thunderbird, nasm, and 
pkg-config. None of these should have affected LO, but...


There is something else going on besides Base crashing. I was checking 
the "Tools" | "Options" with nothing loaded and when I got to the 
bottom item, "Internet" | "MediaWiki", LO crashed when I selected it. 
I wasn't even close to MySQL or Base at the time.


BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux and Java, 
8GB RAM, and 10% of 1TB disk space used. So it shouldn't be a lack of 
resources. Besides, as I said, OpenOffice is still running fine. My 
problem with using AOO, is that it does not have the Base Report 
Generator I need to print my reports.


Hope this helps narrow this problem down. I am about to issue a bug 
report on this. It is certainly repeatable, if frustrating.

Thanks.
Girvin





--
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] convert csv to xlsx - konwert man page

[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 it is unclear how the command is used with a file name.

I have not tried either, but may work for you.

Hope this helps


On 6/22/2017 2:53 AM, Uwe Brauer wrote:

Hi

I run from the command line

/usr/bin/soffice --headless --convert-to xlsx test.csv

Which works nicely with ASCII code, however if the csv contains UTF8
the coding fails, the same is true for the ods format.
What can I do?

I am not sure whether the attachments pass the SPAM filter so here is
the mini csv
,
|
| Apellido,Nombre,DNI,Gr
| Díaz ,Pepe,123456,F
`

Thanks

Uwe Brauer











--
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] convert csv to xlsx command line UTF8 coding problem

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

Hope this helps


On 6/22/2017 2:53 AM, Uwe Brauer wrote:

Hi

I run from the command line

/usr/bin/soffice --headless --convert-to xlsx test.csv

Which works nicely with ASCII code, however if the csv contains UTF8
the coding fails, the same is true for the ods format.
What can I do?

I am not sure whether the attachments pass the SPAM filter so here is
the mini csv
,
|
| Apellido,Nombre,DNI,Gr
| Díaz ,Pepe,123456,F
`

Thanks

Uwe Brauer








--
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] Canon USA Printer Support are using LibreOffice? boot repair

[Paul D. Mirowsky]

Go to https://sourceforge.net/projects/boot-repair-cd/files/

Download the appropriate 32 or 64 bit iso and create a CD, NOT A DVD.

Suggest ImgBurn if on Windows. http://www.imgburn.com/

If it does boot, use default repair.

If it does not, research online the hot-key for your computer that 
allows 'boot from CD" or "Select Boot Drive" option during boot.


If this does not work, it is very common for newer computers to boot to USB.

Make bootable USB stick with iso image.  See https://unetbootin.github.io/

There are many methods for this in the internet, research until you find 
the method you will be most comfortable with.


Once the boot has been repaired, see https://wiki.ubuntu.com/RecoveryMode

Select  "network" and then "dpkg".

If dpkg starts to work and fails, restart machine and repeat until it 
has nothing left to fix.


Hope this helps.



On 5/27/2017 11:05 AM, Tim-L--Elmira-NY wrote:

I have the other way around.

During an upgrade for Ubuntu, the computer crashed and messes up 
GRUB.  So now I have a 1TB drive with access to only 1/4 of it. The 
problem is the DVD cannot be set as a boot option.  BIOS has a weird 
way to set devices to be bootable.  My other laptop's BIOS is easier.  
Of course its DVD boot commands will not work with the new ASUS's 
BIOS.  So with this problem I cannot run the repair disk, since it 
requires to be booted via the CD/DVD drive.


The laptop had been able to boot to from the DVD, which was the way I 
added Ubuntu in the first place.


If I cannot find the correct BIOS commands - or maybe the GRUB 
commands - to boot the repair disk, I would remove the hard drive and 
repair the drive via another Ubuntu laptop.  The only problem with 
that, I would loose my 4 year warranty.



On 05/20/2017 07:51 PM, Virgil Arrington wrote:
Last year, I accidently erased Win10 in an attempt to create a dual 
boot with Mint 18. It was totally my fault. Now, I'm kind of glad I 
did it. So far I haven't missed it.


Virgil


Sent from my Verizon, Samsung Galaxy smartphone


 Original message 
From: Tim-L--Elmira-NY 
Date: 5/19/17 12:49 PM (GMT-05:00)
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Canon USA Printer Support are using 
LibreOffice?


On 05/18/2017 07:24 PM, Steve Edmonds wrote:


On 13/05/17 10:48, Tim-L--Elmira-NY wrote:

On 05/12/2017 02:44 PM, James Knott wrote:

On 05/12/2017 02:31 PM, Tim-L--Elmira-NY wrote:
I would love to get it verified, but it would be a good marketing 
coo

for LO if a big company like Canon uses LibreOffice.

I used to work for a company that used OpenOffice (this was before
LibreOffice was available).  I suspect the only reason they did was
because they were so d@mn cheap, they wouldn't pay for MS Office.  ;)


Well cheap or not, it is nice to have as many big companies using
LibreOffice as possible.

I bet there are a lot of people out there, and on these lists, that
are using LO not because of being "cheap".  It is nice to have a free
office suite but I prefer LO over MS Office. Just like I prefer to
use Linux over Win10 because of all of the viruses and other nasties
that Windows have, while Linux do not have these things infect their
systems.



And the suggestion that the latest crypt virus may have been
introduced to computers through a document macro makes me more
comfortable using LO without MSO on any win PCs.
Steve

Well, if you look at the CNN Headline News, they have stated that MS has
a patch for this virus, but wanted to charge some users for it. The
on-air comment seems to say that since MS had the patch, they should
have sent it out to ALL MS Windows users.  Plus, it the patch was
installed, most computers would not have been infected.

Fro me, I use Linux so I do not have the security problems as MS Windows
users.  I do have Win10, but rarely use it.  Most times I just go to the
Win 10 partition to run the update app.



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








--
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] Libre Writer or Excel - File Name List - Pritning

[Paul D. Mirowsky]

The easiest way I can think of is:

Do <"Accessories"> and left-click on Prompt>

Change to the directory that includes the "Music" folder using CD command.
Enter this command..
dir Music /S /B >"C:\Users\your-name-here\Desktop\Music-file-list.txt"

It should output a file on your Desktop named Music-file-list.txt

Open Music-file-list.txt with LibreOffice Writer.
Highlight "C:\Users\your-name-here\Music\" and -Find and Replace- With 
blank Replace line and no "Other Options".
Since I don't know where you "Music" folder is, the highlighted text 
maybe different, but will begin with C: and end with Music\.


This should leave you with something like...

Sinatra\CapitolYears\MyWay

Now -Find and Replace-
Find\
Replace ;

If we're lucky and there are no semi-colons in your Song names, we 
should be safe.


This should leave you with something like...

Sinatra;CapitolYears;MyWay


Insert a blank line on the very first line and type...
"Artist";"Album";"Song"

Do  Music-file-list-processed.txt
Make sure "Save as type:" is set to "Text (.txt) (*.txt)"
Do not overwrite your original file as a safety precaution.

Close Writer.

Right click on "Music-file-list-processed.txt" from your Desktop.
Open with LibreOffice Calc.
When Text Import screen comes up, make sure "Separator Options" has a 
check-mark next to Semicolon.


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 my Music folder I can see all the
artists names  and their respective sub-folders.

When I l click on each artist's sub-folder I can then see either their
album name(s) in their sub-folders and then when I open the album
sub-folders I can see all the songs listed under that album (in .mp3 or
.wav format).

Ex, First folder - Abba - last folder - ZZ Top.

Since there are no albums under some of the artists there will just be song
titles,

But for those with albums - ex. Sinatra > Album titled Capitol Years (as a
sub-folder under Sinatra)  there wil then be songs listed by tile under the
sub-folder (album).

This info is not stored in a Libre Calc or Excel file not in a Libre Writer
nor MS Word file.

They are just listed in Windows Explorer.

I simply want to print a list of every artist (by name, alphabetically)
with each of their respective albums (by name, if applicable) and then all
of each artist's songs (by name, alphabetically).

Will MusicBrainz Picard <http://picard.musicbrainz.org do that or is that
application not designed for what I'm trying to accomplish?

Thanks much.

Charles.

From: "Paul D. Mirowsky" 
To: users@global.libreoffice.org
Date: Tue, 25 Apr 2017 10:46:45 -0400
Subject: Re: [libreoffice-users] Libre Writer or Excel - File Name List -
Pritning
Two programs to help fill and export metadata.


MusicBrainz Picard <http://picard.musicbrainz.org> is a cross-platform
(Linux/Mac OS X/Windows) application written in Python and is the official
MusicBrainz <http://musicbrainz.org> tagger.

https://picard.musicbrainz.org/






--
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] Libre Writer or Excel - File Name List - Pritning

[Paul D. Mirowsky]

Two programs to help fill and export metadata.


MusicBrainz Picard <http://picard.musicbrainz.org> is a cross-platform 
(Linux/Mac OS X/Windows) application written in Python and is the 
official MusicBrainz <http://musicbrainz.org> tagger.


https://picard.musicbrainz.org/


With *Mp3tag* you can export file and tag information of your audio 
collection to files with user-defined file formats. You can either use 
one of the predefined export configurations to export file information 
to Excel via the CSV export configuration, let Mp3tag create a nicely 
looking HTML playlist with one of the html export configurations or you 
create an export configuration by yourself where you can freely decided 
on the file format and the layout.


An export configuration consists of a unique name, a filename for the 
exported file and the definition of the file format. The file format is 
defined by you, so it's possible to create, e.g., HTML, XML, CSV, batch 
file or LaTeX output.


Mp3tag features a simple template language which can be used to loop 
over artists, albums and arbitrary other tag fields. The tag and file 
informations are represented by placeholders, which are replaced when 
doing the export. You can find an overview of all valid placeholders and 
an example at /Configuration, Export/ 
<http://help.mp3tag.de/options_export.html>.


http://help.mp3tag.de/main_export.html

I have not used Mp3tag, but it should work as claimed.

Picard is excellent, but 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,

I wish to print the names of every artist with their respective album 
names
and with each respective song tile (file named as such – e.g. My Way) 
under

that album name (sub-folder).

I’ve saved these files as such:

Artist name (mostly in alphabetical descending order – A – Z) each a
separate folder.

Ex. Frank Sinatra (the folder)

Under that artist’s name (folder) is often (but not always) a sub-folder
with an album name

Ex. The Capitol Years

Under each album (or artist alone if an album had not been created for
that artist) are all the songs.

Ex. My Way
  Love and Marriage
  New York New York
 Etc.

In many instances there will be no album listed as there may be only one
song under that artist.

Ex. Elvis
   Return to Sender

Summary: This is how it looks on my hard drive?

C:\Music\Sinatra\CapitolYears\MyWay
…along with other songs (as .mp3 or .wav files) listed in the Folder
(Capitol Years) under the Folder (Sinatra).

I’ve already had one external hard drive die suddenly with music on 
it. I

want to, at the very least, have a list of all my music on this external
hard drive so when it dies I’ll have all the music list printed.

Is there an *easy* way to do this in Windows 7 (32 bit)?


I downloaded the ptdirprn-setupexe from KAREN’S Directory Printer (
https://karenware.com/ - to a flash drive and then copied and pasted it
into C:\Download folder on my desktop hard drive.

It’s 1,266 kb but when I tried to open it under my Admin user (it 
prompted
that for an install) I get the error message - ”Installer integrity 
check
has failed. Common causes include an incomplete download and damaged 
media.

Contact the installer’s author to a obtain a new copy. More info at
http:/nsis.sf.nsis_error.

I downloaded that same file three times and each time got the same error
message.

I then downloaded -
https://www.pendriveapps.com/create-a-list-of-songs-album-printer - 
and it

only displays some of the artists (less then 1/3) and not alphabetically
and not their albums – just a very haphazard list.

I’d very much appreciate your suggestions about any freeware which could
generate a full music list of artists, albums and song tittles for
printing.

Thank you!

Charles.







--
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] Libre Writer or Excel - File Name List - Pritning

[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 such – e.g. My Way) under
that album name (sub-folder).

I’ve saved these files as such:

Artist name (mostly in alphabetical descending order – A – Z) each a
separate folder.

Ex. Frank Sinatra (the folder)

Under that artist’s name (folder) is often (but not always) a sub-folder
with an album name

Ex. The Capitol Years

Under each album (or artist alone if an album had not been created for
that artist) are all the songs.

Ex. My Way
  Love and Marriage
  New York New York
 Etc.

In many instances there will be no album listed as there may be only one
song under that artist.

Ex. Elvis
   Return to Sender

Summary: This is how it looks on my hard drive?

C:\Music\Sinatra\CapitolYears\MyWay
…along with other songs (as .mp3 or .wav files) listed in the Folder
(Capitol Years) under the Folder (Sinatra).

I’ve already had one external hard drive die suddenly with music on it. I
want to, at the very least, have a list of all my music on this external
hard drive so when it dies I’ll have all the music list printed.

Is there an *easy* way to do this in Windows 7 (32 bit)?


I downloaded the ptdirprn-setupexe from KAREN’S Directory Printer (
https://karenware.com/ - to a flash drive and then copied and pasted it
into C:\Download folder on my desktop hard drive.

It’s 1,266 kb but when I tried to open it under my Admin user (it prompted
that for an install) I get the error message - ”Installer integrity check
has failed. Common causes include an incomplete download and damaged media.
Contact the installer’s author to a obtain a new copy. More info at
http:/nsis.sf.nsis_error.

I downloaded that same file three times and each time got the same error
message.

I then downloaded -
https://www.pendriveapps.com/create-a-list-of-songs-album-printer - and it
only displays some of the artists (less then 1/3) and not alphabetically
and not their albums – just a very haphazard list.

I’d very much appreciate your suggestions about any freeware which could
generate a full music list of artists, albums and song tittles for
printing.

Thank you!

Charles.




--
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] Setting the hash for time stamping when create PDF

[Paul D. Mirowsky]

Hello Vesselin

I apologize for my previous reply. Did not catch the caveat at the 
bottom of the page.


*Notice*: The main limitation on OpenOffice 5 is that you can't change 
the hash used "SHA1" that really shouldn't be used for security 
related purposes like signing documents. There are external 
applications better for this purpose.

Paul


On 4/9/2017 5:49 PM, Vesselin Kolev wrote:

Dear All,

Since I cannot find a complete answer of my question neither in the
LibreOffice Documentation nor on the Internet, I decided to forward it
to this mailing list.

Is there any way (even through external Java class) to specify the hash
algorithm when requesting TSA based time stamp? At the present
LibreOffice creates a time stamp request based on SHA1. But this hash
algorithm is considered obsolete. Hence that automatically turns the
time stamped PDF into insecure ones. Note that the same problem occurs
with all signature produced by LibreOffice in general - no possibility
to specify the parameters for creating the signature.

Thank you very much in advance for your response!

Best regards,

Vesselin Kolev






--
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] Setting the hash for time stamping when create PDF

[Paul D. Mirowsky]

You may want to use a separate program to secure your document that 
meets the specification you want.


See https://freetsa.org/guide/libreoffice-time-stamping.html

Hope this helps

Paul


On 4/9/2017 5:49 PM, Vesselin Kolev wrote:

Dear All,

Since I cannot find a complete answer of my question neither in the
LibreOffice Documentation nor on the Internet, I decided to forward it
to this mailing list.

Is there any way (even through external Java class) to specify the hash
algorithm when requesting TSA based time stamp? At the present
LibreOffice creates a time stamp request based on SHA1. But this hash
algorithm is considered obsolete. Hence that automatically turns the
time stamped PDF into insecure ones. Note that the same problem occurs
with all signature produced by LibreOffice in general - no possibility
to specify the parameters for creating the signature.

Thank you very much in advance for your response!

Best regards,

Vesselin Kolev






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