Re: [libreoffice-users] Brandon Grotesque - font

[V Stuart Foote]

On 6/30/24 1:37 PM, charles meyer wrote:

Has anyone found any font in Libre Draw very similar (not kind of but
very close) to how Brandon Grotesque looks?

Google results suggested fronts not in LO.

Thank you,

Charles.


Brandon Grotesque is a license restricted font family by HVD Fonts 
distributed by Adobe.


Suggest download and *install locally* for use in LibreOffice one of 
these OpenFont Licensed alternatives:


Lato [1]
Josefin Sans [2]
Cabin [3]

With one of these installed, you can also use the LibreOffice Font 
'Replacement Table' functions
(found in Tools -> Options -> Fonts) as font replacement for documents 
arriving with Brandon Grotesque, or to define
Brandon Grotesque for use in a Para style (even though the font is not 
present locally) [4].


=-ref-=
[1] https://fonts.google.com/specimen/Lato
[2] https://fonts.google.com/specimen/Josefin+Sans
[3] https://fonts.google.com/specimen/Cabin
[4] 
https://help.libreoffice.org/latest/en-US/text/shared/optionen/01010700.html

--
Stuart

--
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] Q: configure “Remote Files” to access a SMB share on a Fritzbox

[Gabriele Bertolucci]

I have a Fritz!Box 7590 and LO 24.2.4 on ArchLinux.

I was able to use "Remote Files" using the configuration in the attached 
screenshots.

Try to follow it step by step and see if it was successfull.

-- 
Gabriele Bertolucci
[passa come me ad un'email sicura: https://pr.tn/ref/BT54ED5PY590]

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

[Heidi Lasher-Oakes]

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] Brandon Grotesque - font

[Tom]

On 6/30/24 1:37 PM, charles meyer wrote:

Has anyone found any font in Libre Draw very similar (not kind of but
very close) to how Brandon Grotesque looks?

Google results suggested fronts not in LO.

Thank you,

Charles.



Could you install the "Brandon Grotesque" font on your system?  I 
imagine LibreOffice would pick it up, if it's a TrueType or OpenType font.


Peace...

Tom


--
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] Exclusive NeoOffice Features

[toki]

All:

In as much as NeoOffice is currently _not_ under active development, and 
the licence has been changed to be compatible  with LibreOffice's 
licence,have the features that were exclusive to NeoOffice been included 
within LibreOffice?


jonathon

--
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 form from button

[Robert Großkopf]

Hi Edwin,


Is it possible to open to put a button in a form to open a different 
form from a linked field?


One possibility:
Create a table "tbl_Filter". Might be you are already using such a table 
for only one row. This table should contain a field like "Plant_ID". So 
you could save the identifier for the plant in this table.

Open the new form, which depends on a query like this:

SELECT * FROM "MyTable" WHERE "ID" = (SELECT "Plant_ID" FROM "tbl_Filter")

Might be a macro like this helps:

SUB OpenFormPlant(oEvent AS OBJECT)
   oForm = oEvent.Source.Model.Parent
   IF hasUnoInterfaces(oForm, "com.sun.star.form.XForm" ) THEN
  stID = oForm.getString(oForm.FindColumn("ID"))  
  oConnection = oForm.activeConnection()
  oSQL_Statement = oConnection.createStatement()
  stSql = "UPDATE ""tbl_Filter"" SET ""Plant_ID"" = '"+stID+"'"
  oSQL_Statement.executeUpdate(stSql)	 
ThisDatabaseDocument.FormDocuments.getByName("frm_PropagatingPlant").open

   END IF   
END SUB

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] Open form from button

[Edwin Humphries]

Hi all

Is it possible to open to put a button in a form to open a different 
form from a linked field?


I have a form that gives general information about the use of a plant in 
landscaping, and a quite different form that gives information about 
propagating that plant. I'd like to have a button to open the second 
form from the first.


--

Regards,
Edwin Humphries
Mobile: 0435 672 457

I acknowledge the traditional Wodi Wodi custodians, their elders and 
customs, of the Dharawal lands on which I live.


"At every moment he beholdeth a wondrous world, a new creation, and 
goeth from astonishment to astonishment, and is lost in awe at the works 
of the Lord of Oneness." Bahá'u'lláh
"... humans are interesting. With all the wonders there are in the 
Universe, they invented boredom." Terry Pratchett, Hogfather
"The most beautiful thing we can experience is the mysterious. It is the 
source of all true art and all science. He to whom this emotion is a 
stranger, who can no longer pause to wonder and stand rapt in awe, is as 
good as dead: his eyes are closed." Albert Einstein
"Stuff your eyes with wonder ... live as if you'd drop dead in ten 
seconds. See the world. It's more fantastic than any dream made or paid 
for in factories." Ray Bradbury

--
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] Brandon Grotesque - font

[Remy Gauthier]

Hello,

You can download the font from various websites:

https://dafontfamily.net/brandon-grotesque-font-free-download/
https://www.dafontfree.io/brandon-grotesque-font-free/

Once you have downloaded and installed the font, you will be able to
use it in LO. Note that some sites only offer versions for personal
use, so make sure your usage of the font is in line with the type of
licensing you get.
Regards,
Rémy.

Le dimanche 30 juin 2024 à 16:37 -0400, charles meyer a écrit :
> Has anyone found any font in Libre Draw very similar (not kind of but
> very close) to how Brandon Grotesque looks?
> 
> Google results suggested fronts not in LO.
> 
> 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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Brandon Grotesque - font

[charles meyer]

Has anyone found any font in Libre Draw very similar (not kind of but
very close) to how Brandon Grotesque looks?

Google results suggested fronts not in LO.

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

Re: [libreoffice-users] Update of Libreoffice portable

[aguador]

El jue, 27-06-2024 a las 22:04 +0200, Jarek Krcmar escribió:
> Good evening, it seems to me that Libreoffice version 24.2.4 is
> already 
> available. The program offers me an installation version, but I would
> like a portable version. Please do not know where to download it?
> Best 
> regards
> -- 
> Jarek
> 
Hi Jarek,

In the last sentence of this page:

https://www.libreoffice.org/download/portable-versions/

There is a link that leads to:

https://portableapps.com/apps/office/libreoffice_portable

Note that this is the "Fresh" version which the Document Foundation
does not recommend for production work. For production the Foundation
normally recommends the more "still" version, currently 7.6.7,
available at that first link above.

Best,
Roy

-- 
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] Update of Libreoffice portable

[Jarek Krcmar]

Good evening, it seems to me that Libreoffice version 24.2.4 is already 
available. The program offers me an installation version, but I would 
like a portable version. Please do not know where to download it? Best 
regards

--
Jarek

--
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] Calc auto complete from a list of cells

[John Kaufmann]

Dave,

On 2024-05-29 16:38, dboland9 wrote:

I was asked how to make an auto complete from a list of cells in another sheet 
in the same file. I thought the validation would work, but it only supports a 
scroll bar. That is fine for short lists, but not for hundreds of lines. Any 
suggestions on how to do this? I have seen it in some apps. ...


Trying to understand what is needed, I would ask if you can give an example of 
what you have seen in some apps.

Thanks,
John

--
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] Q: configure “Remote Files” to access a SMB share on a Fritzbox

[Albrecht Dreß]

Hi all,

I try to access files on the SMB share of a Fritzbox router using the “Remote 
Files” in Libreoffice, but unfortunately without success.

From the Linux command line, the following command opens the connection to the 
share:

   smbclient -U shareuser --password ** -W WORKGROUP -D Storage 
//fritz.nas/my.nas

In Libreoffice, I enter the following data in the “Remote Files” dialogue using 
“Add service”:
* Type: Windows share
* Host: fritz.nas
* Share: my.nas
* user and password: as above; enable Remember password
* Root: Storage

Selecting the “Service” entry, the “Remote Files” dialogue is still greyed out, 
no folders or LO files are displayed, and all I can do is to click “Cancel”.  
No error message or other information is displayed.

My Libreoffice version (installed from Debian Bookworm backports, but I have 
the same issue with the official macOS build):
  Version: 24.2.4.2 (X86_64) / LibreOffice Community
  Build ID: 420(Build:2)
  CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
  Locale: en-US (C); UI: en-US
  Debian package version: 4:24.2.4-1~bpo12+1
  Calc: threaded

How should the Service be configured to access the files on the share?  Any 
help will be highly appreciated!

Thanks in advance,
Albrecht.
--
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] Export to ePub

[Dave Howorth]

On Wed, 26 Jun 2024 12:42:22 +1000
Keith Bainbridge  wrote:

> I get that in calc. writer gives more options

Duh! Thanks Keith. I happened to have a spreadsheet open, so I looked
there and couldn't see the options. I just looked in writer and now see
it. I wonder why you can't export spreadsheets?

-- 
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] [SOLVED] Export to ePub

[Thomas Blasejewicz]

On 2024/06/26 4:44, aguador wrote:

Even though I'm using an older version on linux, 7.3.7.2, I still get
Try going to "Tools" to "Customize" (sorry, I have my interface in
Spanish, but that's what it normally would be) and in the popup for
"Menus", on the right "Categories", list all commands and scroll down.
There should be two EPUBs listed. Hovering over one will show "command:
uno:EportDirectToEBUB", the other simply "command: uno:ExportToEPUB"
(the own you are looking for which offers the options). Then, to the
right under "Destination" choose "File|Export as" from the drop down to
add the option (if not there)*. If it is there, you have just wasted
your time reading this, and I'm sorry.

Good afternoon and thank you everyone.
The trick with the Customize menus seems to work. I searched the 
available commands and found TWO named "ePub" - they look identical but 
have different functions. One is the "export ..." thing already visible, 
the other the "Export as ...", which I now added to the contents menu. 
Now, THIS problem has been solved. It "works", but Draft2Digitial still 
rejects the result, showing me a number of errors. Someone suggested to 
upload a .docx file. That does not work either. The publisher INSISTS on 
getting an "ePub3" file, but then complains about a million things. 
While I do not recall, what exactly I did, I finally got my file 
accepted. The publishers (automated) note says "Looks good", but in the 
same breath adds: "it would be better to use "ePub2", or else our highly 
advertised added services (like adding a TCO, copyright page etc.) will 
no longer be available." And the resulting ePub file looks, with all due 
respect, like s**t: all same font size, no headings, no TOC, very 
strange layout. What the h**l then is the merit of using epub3? Maybe I 
should look for a different publisher. 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] Export to ePub

[Keith Bainbridge]

On 25/6/24 20:57, Thomas Blasejewicz wrote:



Thank you, but I have looked already a hundred times.
There are TWO items
* File -> Export ...
* File -> Export as PDF ...
(-> The item "Export as..." is simply not there.)



I get that in calc. writer gives more options
--
All the best

Keith Bainbridge

keithr...@gmail.com
keith.bainbridge.3...@gmail.com
+61 (0)447 667 468

UTC + 10:00


--
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] Export to ePub

[Keith Bainbridge]

On 25/6/24 20:20, V Stuart Foote wrote:


Look again, on the Writer 'File' menu for the "Export As" entry. Not the 
"Export..." entry.


LO 7.4.7.2 on linux shows Export as epub or export directly as epub. 
export as epub gives a box to choose several options. export directly 
goes straight to save location window.

--
All the best

Keith Bainbridge

keithr...@gmail.com
keith.bainbridge.3...@gmail.com
+61 (0)447 667 468

UTC + 10:00


--
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] Export to ePub

[aguador]

El mar, 25-06-2024 a las 16:21 -0400, Tim Hoover escribió:
> > Try going to "Tools" to "Customize" (sorry, I have my interface in
> > Spanish, but that's what it normally would be) and in the popup for
> > "Menus", on the right "Categories", list all commands and scroll
> > down.
> > There should be two EPUBs listed. Hovering over one will show
> > "command:
> > uno:EportDirectToEBUB", the other simply "command:
> > uno:ExportToEPUB"
> > (the own you are looking for which offers the options). Then, to
> > the
> > right under "Destination" choose "File|Export as" from the drop
> > down to
> > add the option (if not there)*. If it is there, you have just
> > wasted
> > your time reading this, and I'm sorry.
> 
> On my Linux Debian 11 system, running LO 7.5.8, the 'Export as'
> option is also missing. However, using your method I was able to add
> it with one small change. Because the 'Export as' submenu was
> missing, in the tools > customize dialog, I had to click on the
> 'Insert' button, and select 'Add submenu'. Then I added the 'Export
> as' submenu, and then added the 'Epub', 'Epub direct', 'PDF', and
> 'PDF direct' to the created submenu.
> 
> --
> Tim Hoover
> 
> 
Good catch, Tim. I hope that solves the problem for Thomas. Roy

-- 
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] Export to ePub

[Tim Hoover]

> Try going to "Tools" to "Customize" (sorry, I have my interface in
> Spanish, but that's what it normally would be) and in the popup for
> "Menus", on the right "Categories", list all commands and scroll down.
> There should be two EPUBs listed. Hovering over one will show "command:
> uno:EportDirectToEBUB", the other simply "command: uno:ExportToEPUB"
> (the own you are looking for which offers the options). Then, to the
> right under "Destination" choose "File|Export as" from the drop down to
> add the option (if not there)*. If it is there, you have just wasted
> your time reading this, and I'm sorry.

On my Linux Debian 11 system, running LO 7.5.8, the 'Export as' option is also 
missing. However, using your method I was able to add it with one small change. 
Because the 'Export as' submenu was missing, in the tools > customize dialog, I 
had to click on the 'Insert' button, and select 'Add submenu'. Then I added the 
'Export as' submenu, and then added the 'Epub', 'Epub direct', 'PDF', and 'PDF 
direct' to the created submenu.

--
Tim Hoover


-- On Tue, 25 Jun 2024 21:44:50 +0200,  aguador wrote: 
> 
> El mar, 25-06-2024 a las 15:42 +0200, Philip Jackson escribió:
> > Hi Thomas,
> > 
> > On 25/06/2024 12:57, Thomas Blasejewicz wrote:
> > > On 2024/06/25 19:20, V Stuart Foote wrote:
> > > > On 2024-06-25 01:01, Thomas Blasejewicz wrote:
> > > > 
> > > > Look again, on the Writer 'File' menu for the "Export As" entry.
> > > > Not the "Export..." entry.
> > > > 
> > > Thank you, but I have looked already a hundred times.
> > > There are TWO items
> > > * File -> Export ...
> > > * File -> Export as PDF ...
> > > (-> The item "Export as..." is simply not there.)
> > > 
> > > but nothing else.
> > > and the Export as PDF ... options does NOT seem to have anything
> > > related to epub in it.
> > > As usual, I am probably missing something ...
> > > Thomas
> > > 
> > Even though I'm using an older version on linux, 7.3.7.2, I still get
> > all the options as shown in the image you referenced. And it displays
> > epub3 by default. So it's strange that your version doesn't have
> > this.
> > 
> > My W10 box has 7.6.6.3, and it too shows the same image with epub3
> > selected by default. To get it, I follow this path:  File > Export as
> > > Export as epub ...     and there it is, one of four options - 2 for
> > pdf and 2 for epub.
> > 
> 
> > 
> > Philip
> > 
> Thomas,
> 
> I too have the options you are looking for, but not sure why. The only
> thing I can think is that the option has not been made available on the
> File menu. So...
> 
> Try going to "Tools" to "Customize" (sorry, I have my interface in
> Spanish, but that's what it normally would be) and in the popup for
> "Menus", on the right "Categories", list all commands and scroll down.
> There should be two EPUBs listed. Hovering over one will show "command:
> uno:EportDirectToEBUB", the other simply "command: uno:ExportToEPUB"
> (the own you are looking for which offers the options). Then, to the
> right under "Destination" choose "File|Export as" from the drop down to
> add the option (if not there)*. If it is there, you have just wasted
> your time reading this, and I'm sorry.
> 
> Best of luck,
> Roy
> 
> * My versions of LO Writer have in the "File:Export as" destination
> come with four options: Export as pdf..., Export directly as pdf,
> Export as EPUB..., Export directly as EPUB.
> 
> -- 
> 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] Export to ePub

[aguador]

El mar, 25-06-2024 a las 15:42 +0200, Philip Jackson escribió:
> Hi Thomas,
> 
> On 25/06/2024 12:57, Thomas Blasejewicz wrote:
> > On 2024/06/25 19:20, V Stuart Foote wrote:
> > > On 2024-06-25 01:01, Thomas Blasejewicz wrote:
> > > 
> > > Look again, on the Writer 'File' menu for the "Export As" entry.
> > > Not the "Export..." entry.
> > > 
> > Thank you, but I have looked already a hundred times.
> > There are TWO items
> > * File -> Export ...
> > * File -> Export as PDF ...
> > (-> The item "Export as..." is simply not there.)
> > 
> > but nothing else.
> > and the Export as PDF ... options does NOT seem to have anything
> > related to epub in it.
> > As usual, I am probably missing something ...
> > Thomas
> > 
> Even though I'm using an older version on linux, 7.3.7.2, I still get
> all the options as shown in the image you referenced. And it displays
> epub3 by default. So it's strange that your version doesn't have
> this.
> 
> My W10 box has 7.6.6.3, and it too shows the same image with epub3
> selected by default. To get it, I follow this path:  File > Export as
> > Export as epub ...     and there it is, one of four options - 2 for
> pdf and 2 for epub.
> 

> 
> Philip
> 
Thomas,

I too have the options you are looking for, but not sure why. The only
thing I can think is that the option has not been made available on the
File menu. So...

Try going to "Tools" to "Customize" (sorry, I have my interface in
Spanish, but that's what it normally would be) and in the popup for
"Menus", on the right "Categories", list all commands and scroll down.
There should be two EPUBs listed. Hovering over one will show "command:
uno:EportDirectToEBUB", the other simply "command: uno:ExportToEPUB"
(the own you are looking for which offers the options). Then, to the
right under "Destination" choose "File|Export as" from the drop down to
add the option (if not there)*. If it is there, you have just wasted
your time reading this, and I'm sorry.

Best of luck,
Roy

* My versions of LO Writer have in the "File:Export as" destination
come with four options: Export as pdf..., Export directly as pdf,
Export as EPUB..., Export directly as EPUB.

-- 
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] template question.

[LO . Harald . Berger]

Hi Chris,

create a real document template in OTT format.

Generate your documents from this and save them as ODT, always!

Use Save as to create DOCX files that you want to pass on.

https://wiki.documentfoundation.org/Videos/Document_Templates_in_Writer

Find out here why this is the better way and there may otherwise be 
compatibility problems:


https://wiki.documentfoundation.org/Faq/General/118

I hope you get on with it. Good luck.

Kind regards
Harald

Am 25.06.2024 um 17:35 schrieb Chris J.:
I think I've noticed something. Is it true that DOCX files can't 
maintain page templates?



With the help of the kind people on this list, Robert in particular, 
I've made three paragraph templates and a page template. I've even 
saved them as templates. So far, so good,



Every editing service and publisher I've come across thus far want 
DOC/DOCX files. I have been saving every thing as DOCX because of 
this. However I noticed yesterday that while my paragraph template 
styles are saved in the DOCX files, my page temple is not. If I reopen 
the DOCX file the paragraph temples are there but the page template is 
not. This is reproducible. I have to reload the page template in 
Writer if I want it each time I reopen the DOCX file.



Am I doing something wrong? Or does DOCX just not do page templates? I 
haven't used MS O in a long time.



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

[libreoffice-users] template question.

[Chris J.]

Hi,


I think I've noticed something. Is it true that DOCX files can't 
maintain page templates?



With the help of the kind people on this list, Robert in particular, 
I've made three paragraph templates and a page template. I've even saved 
them as templates. So far, so good,



Every editing service and publisher I've come across thus far want 
DOC/DOCX files. I have been saving every thing as DOCX because of this. 
However I noticed yesterday that while my paragraph template styles are 
saved in the DOCX files, my page temple is not. If I reopen the DOCX 
file the paragraph temples are there but the page template is not. This 
is reproducible. I have to reload the page template in Writer if I want 
it each time I reopen the DOCX file.



Am I doing something wrong? Or does DOCX just not do page templates? I 
haven't used MS O in a long time.



Thank you.



--

Chris Johnson   rchristopherjohn...@gmail.com
Ex SysAdmin, now, writer/There isn't a single person on this planet
who is entitled to treat you like shit./
(Bobbie Blair Thompson)

--
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] Export to ePub

[Philip Jackson]

Hi Thomas,

On 25/06/2024 12:57, Thomas Blasejewicz wrote:

On 2024/06/25 19:20, V Stuart Foote wrote:

On 2024-06-25 01:01, Thomas Blasejewicz wrote:

Look again, on the Writer 'File' menu for the "Export As" entry. Not the 
"Export..." entry.


Thank you, but I have looked already a hundred times.
There are TWO items
* File -> Export ...
* File -> Export as PDF ...
(-> The item "Export as..." is simply not there.)

but nothing else.
and the Export as PDF ... options does NOT seem to have anything related to 
epub in it.
As usual, I am probably missing something ...
Thomas


Even though I'm using an older version on linux, 7.3.7.2, I still get all the 
options as shown in the image you referenced. And it displays epub3 by default. 
So it's strange that your version doesn't have this.

My W10 box has 7.6.6.3, and it too shows the same image with epub3 selected by 
default. To get it, I follow this path:  File > Export as > Export as epub ...  
   and there it is, one of four options - 2 for pdf and 2 for epub.

Curiously, and I hadn't noticed this before, when I use: File > Export ..., I 
can see in the file format drop down list an option for export to epub but no 
mention of epub3 so I suppose it's epub2.

In the past, before Writer supported a native epub export, we had to install an 
extension, Writer2xhtml, which used to work well. In those days, we accessed it by 
File > Export  and in the resulting dialog box, select file format from the 
drop down list { for example: EPUB3 [Writer2xhtml] (.epub) }.

I gave up using this because the extension didn't seem to be maintained for 
later versions of LO.  But I also wasn't impressed with the native Writer epub 
export either so I now use Sigil with its input extension for importing .odt 
files.  This is my preferred work flow these days. With Sigil, you retain 
complete control and if you've set up the styles well in Writer, they come out 
ok in Sigil. Sigil is a free software tool available for Windows, linux, Mac 
(both Intel and arm versions). But like with most things in life, there is a 
learning curve.

Another way you could try is to export your document from Writer as a Word 
.docx and then let Draft2Digital's converter take the strain.

Philip

--
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] Export to ePub

[V Stuart Foote]

On 2024-06-25 06:57, Thomas Blasejewicz wrote:

On 2024/06/25 19:20, V Stuart Foote wrote:

On 2024-06-25 01:01, Thomas Blasejewicz wrote:

Look again, on the Writer 'File' menu for the "Export As" entry. Not 
the "Export..." entry.



Thank you, but I have looked already a hundred times.
There are TWO items
* File -> Export ...
* File -> Export as PDF ...
(-> The item "Export as..." is simply not there.)

but nothing else.
and the Export as PDF ... options does NOT seem to have anything 
related to epub in it.

As usual, I am probably missing something ...
Thomas


Don't know what to tell you.

The "File" --> "Export As" --> "Export as EPUB..." entries are present 
on the 'Writer' main menu for both a 7.6.7 and a 24.2.4 installs on 
Windows I've on hand.


EPub is not an optional extension and the export filter is built-in to 
core for the TDF build releases.


Are you on a Linux distro?

Version: 7.6.6.3 (X86_64) / LibreOffice Community
Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; 
VCL: win

Locale: en-US (en_US); UI: en-US
Calc: CL threaded

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: 
win

Locale: en-US (en_US); UI: en-US
Calc: CL threaded

--
Stuart

--
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] Export to ePub

[Thomas Blasejewicz]

On 2024/06/25 19:20, V Stuart Foote wrote:

On 2024-06-25 01:01, Thomas Blasejewicz wrote:

Look again, on the Writer 'File' menu for the "Export As" entry. Not 
the "Export..." entry.



Thank you, but I have looked already a hundred times.
There are TWO items
* File -> Export ...
* File -> Export as PDF ...
(-> The item "Export as..." is simply not there.)

but nothing else.
and the Export as PDF ... options does NOT seem to have anything related 
to epub in it.

As usual, I am probably missing something ...
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] Export to ePub

[V Stuart Foote]

On 2024-06-25 01:01, Thomas Blasejewicz wrote:

...
Then there is a link to an image:
https://wiki.documentfoundation.org/File:7603EN_Writer_Dialog_EPUBExport.png

Problem:
THAT is NOT what I have on my screen.
Having a choice between epub versions and other options would be great, 
but I have only:

Choose File - Export As - Export as EPUB -> choose file + save as epub.
That is all.
If it is possible to get all the options shown in the image 
"https://wiki.documentfoundation.org/File:7603EN_Writer_Dialog_EPUBExport.png; 
would be a life saver. Maybe.




Look again, on the Writer 'File' menu for the "Export As" entry. Not the 
"Export..." entry.


There are two entries for EPUB. One is the dialog (with the ellipsis...) 
the other a quick export.


You'll want to use the dialog.

--
Stuart

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

[Robert Großkopf]

Hi Harvey,


Great stuff. Thanks. You are sooo helpful.:-)
Do you mean to move all the individual 46 rpm files tor the my_rpms
repo, or the 3 rpm folders? Or does it not matter?


All 46 rpm filses should be in folder. But seems you have solved that.

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] Export to ePub

[Thomas Blasejewicz]

Good afternoon
Windows 10, LO 7.6.6.3
I have published in the past a book in Japanese as an ebook.
Now I have revised it and want to upload the file, but the publisher 
(Draft2Digital) tells me, it HAS to be in epub3 for Japanese texts.


Well, I tried to find how to export odt files to epub and the 
documentation for 7.6 says:

file:///C:/Program%20Files/LibreOffice/help/en-US/text/shared/01/ref_epub_export.html?DbPAR=SHARED#bm_id3149532
"To access this command... From the menu bar:
"Choose File - Export As - Export as EPUB."
Then there is a link to an image:
https://wiki.documentfoundation.org/File:7603EN_Writer_Dialog_EPUBExport.png

Problem:
THAT is NOT what I have on my screen.
Having a choice between epub versions and other options would be great, 
but I have only:

Choose File - Export As - Export as EPUB -> choose file + save as epub.
That is all.
If it is possible to get all the options shown in the image 
"https://wiki.documentfoundation.org/File:7603EN_Writer_Dialog_EPUBExport.png; 
would be a life saver. Maybe.


Currently the publisher does not accept the odt file or an epub file (I 
tried a million times also with other software)


Is there a trick to get all those "Export as ..." options?
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] LOBase reports fail

[Harvey Nimmo]

Thanks, Paul. In the end, I was able to follow Robert Großkopf's
suggestions. All seems well now.

Cheers
Harvey

On Mon, 2024-06-24 at 15:01 -0400, Paul D. Mirowsky wrote:
> 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] LOBase reports fail

[Harvey Nimmo]

On Mon, 2024-06-24 at 21:04 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> download the three packages from LO: one for main program, one for 
> language and one for help.
> Unzip this packages in a folder.
> Create a folder "my_rpms" in you home directory for the *.rpm-files.
> Move all rpm-files from the unzipped packages to "my_rpms".
> Start Yast.
> Start Software-Repositories
> Add "my_rpms" as a repository, folder only without description …
> Start "Install Software"
> Unistall all the LibreOffice installations, which appear in Yast.
> Chose the new version from the new "repository" (your folder).
> Install and ignore the warnings "files might be corrupt". It always 
> apperas for every file in this folder.
> 
> Regards
> 
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert

Thanks again, Robert. Base reports are now working!!
I appreciate your support very much, as ever.

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

[Harvey Nimmo]

On Mon, 2024-06-24 at 21:04 +0200, Robert Großkopf wrote:
> Hi Harvey,
> 
> download the three packages from LO: one for main program, one for 
> language and one for help.
> Unzip this packages in a folder.
> Create a folder "my_rpms" in you home directory for the *.rpm-files.
> Move all rpm-files from the unzipped packages to "my_rpms".
> Start Yast.
> Start Software-Repositories
> Add "my_rpms" as a repository, folder only without description …
> Start "Install Software"
> Unistall all the LibreOffice installations, which appear in Yast.
> Chose the new version from the new "repository" (your folder).
> Install and ignore the warnings "files might be corrupt". It always 
> apperas for every file in this folder.
> 
> Regards
> 
> Robert
> -- 
Hi Robert,

Great stuff. Thanks. You are sooo helpful.:-)
Do you mean to move all the individual 46 rpm files tor the my_rpms
repo, or the 3 rpm folders? Or does it not matter?

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

[Robert Großkopf]

Hi Harvey,

download the three packages from LO: one for main program, one for 
language and one for help.

Unzip this packages in a folder.
Create a folder "my_rpms" in you home directory for the *.rpm-files.
Move all rpm-files from the unzipped packages to "my_rpms".
Start Yast.
Start Software-Repositories
Add "my_rpms" as a repository, folder only without description …
Start "Install Software"
Unistall all the LibreOffice installations, which appear in Yast.
Chose the new version from the new "repository" (your folder).
Install and ignore the warnings "files might be corrupt". It always 
apperas for every file in this folder.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] LOBase reports fail

[Harvey Nimmo]

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

[Harvey Nimmo]

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
> 
Thanks Robert. Reliable as always!
Cheers
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] LOBase reports fail

[Robert Großkopf]

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


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

[Robert Großkopf]

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


Please install LibreOffice directly from LibreOffice. Not only the 
packages from OpenSUSE, also the packages from Ubuntu won't show a report.


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] LOBase reports fail

[Harvey Nimmo]

On OpenSUSE Leap 156, I am running 

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

with LOBase connected by network to a mariadb as backend.
 
Currently reports in LOBase are all failing with SQL Status 1000.

"
[jni_uno bridge error] UNO calling Java method execute: non-UNO
exception occurred: java.lang.NoClassDefFoundError: Could not
initialize class org.jfree.report.JFreeReportBoot
java stack trace:
java.lang.NoClassDefFoundError: Could not initialize class
org.jfree.report.JFreeReportBoot
at
org.libreoffice.report.pentaho.PentahoReportEngine.(PentahoReport
Engine.java:34)
at
org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.c
reateReportJob(SOReportJobFactory.java:352)
at
org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.e
xecute(SOReportJobFactory.java:236)
 at /home/abuild/rpmbuild/BUILD/libreoffice-
24.2.1.2/bridges/source/jni_uno/jni_uno2java.cxx:783 at
/home/abuild/rpmbuild/BUILD/libreoffice-
24.2.1.2/dbaccess/source/ui/misc/linkeddocuments.cxx:330
"
 Does anyone know what could be wrong?

Cheers
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] vlookup help

[Michael D. Setzer II]

=On 22 Jun 2024 at 16:12, James wrote:


Date sent:60;Sat, 22 Jun 2024 16:12:13 -0400
To:0;LibreOffice-list 

From:James bjloc...@lockie.ca>
Subject:;[libreoffice-users] vlookup help


> I am having trouble with vlookup.
> I put a test file at:
> https://www.mediafire.com/file/puq9nuu982beicl/vlookup-test.ods/file
>
> The spreadsheet is:
> One $1 1%> Two $2 2%> Three $3 3%> current $2 2%60; #N/A


In D4 I put
=INDEX(A1:A3,MATCH(C4,$C$1:$C$3),1)
and that displays Two


If I understand what you are looking for. Match returns the row.


>
> C4 contains =VLOOKUP(B4,B1:C3,2,0) which works.> D4 contains 
> =VLOOKUP(C4,A1:C3,1,0) which displays #N/A but I want it to
> display whatever is in column A of the matching row.
> "Two" in this case.
> Whatenever I change B4, D4 should display the matching row of column A/
>
> --
> 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)60;
mailto:mi...@guam.net;
mailto:msetze...@gmail.com
mailto:msetze...@gmx.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] vlookup help

[Regina Henschel]

Hi James,

James schrieb am 22.06.2024 um 22:12:

I am having trouble with vlookup.
I put a test file at:
https://www.mediafire.com/file/puq9nuu982beicl/vlookup-test.ods/file

The spreadsheet is:
One    $1    1%
Two    $2    2%
Three    $3    3%
current    $2    2%    #N/A

C4 contains =VLOOKUP(B4,B1:C3,2,0) which works.
D4 contains =VLOOKUP(C4,A1:C3,1,0) which displays #N/A but I want it to 
display whatever is in column A of the matching row.

"Two" in this case.


VLOOKUP cannot access a column that is before the left-most column of 
the lookup-range, and the left-most column of the lookup-range is always 
the column, where the value is searched.



Whatenever I change B4, D4 should display the matching row of column A/



This can be done with a combination of MATCH with OFFSET or a 
combination of MATCH with INDEX.


For the combination of MATCH with OFFSET you need to add a row of labels 
before your data.


  ColA colB ColC
Row1  labelA   labelB   labelC
Row2  One  $1   1%
Row3  Two  $2   2%
Row4  Three$3   3%
Row5  current  $2   see below

formula in cell C5
=OFFSET(A1; MATCH(B5;B2:B4;0);0)

A1 is the reference cell. To its position OFFSET adds the row difference 
and the column difference. MATCH returns 2. Thus the returned value is 
from cell column A+0, row 1+2, that is from cell A3.



For the combination of MATCH with INDEX you need no label row.
  ColA colB ColC
Row1  One  $1   1%
Row2  Two  $2   2%
Row3  Three$3   3%
Row4  current  $2   see below

formula in cell C4
= INDEX(A1:C3;MATCH(B4;B1:B3;0);1)
Index uses the position row|col whereby the left-top cell in the 
reference area A1:C3 has the position 1|1. Thus position 2|1 is the cell A2.



The upcoming version 24.8 will have a function XLOOKUP. With that 
function the lookup range and the return range are separated.

=XLOOKUP(B4; B1:B3; A1:A3)


(My parameter separator is a semicolon. You need to adapt the formulas 
to use your parameter separator.)


Kind regards,
Regina





--
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] vlookup help

[James]

I am having trouble with vlookup.
I put a test file at:
https://www.mediafire.com/file/puq9nuu982beicl/vlookup-test.ods/file

The spreadsheet is:
One    $1    1%
Two    $2    2%
Three    $3    3%
current    $2    2%    #N/A

C4 contains =VLOOKUP(B4,B1:C3,2,0) which works.
D4 contains =VLOOKUP(C4,A1:C3,1,0) which displays #N/A but I want it to 
display whatever is in column A of the matching row.

"Two" in this case.
Whatenever I change B4, D4 should display the matching row of column A/

--
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] Please your help to download

[Regina Henschel]

Hi Jarek,

Jarek Krcmar schrieb am 21.06.2024 um 22:22:
Hello Libreoffice users, Today I found out that Libreoffice version 
24.2.4 is available. I want to download the portable version, but 
instead of the new version, I am offered an older version, namely 76.7. 
Could you please advise me which site should I visit to download the 
latest portable version? Regards


24.2.4 is too fresh, a portable version is not yet available. Currently 
you can get 24.2.3 as portable version. 
https://portableapps.com/apps/office/libreoffice_portable


Kind regards,
Regina


--
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] Please your help to download

[Jarek Krcmar]

Hello Libreoffice users, Today I found out that Libreoffice version 
24.2.4 is available. I want to download the portable version, but 
instead of the new version, I am offered an older version, namely 76.7. 
Could you please advise me which site should I visit to download the 
latest portable version? Regards

--
Jarek

--
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] inserting wrong envelope

[Fred James]

Libre Office 7.4.5.1
Mageia Linux 8

In Text (ODT) editor, I insert an envelope into a document ... I select 
#10 for the envelope ... I get a C5 ... I need a #10


What am I missing?  Thanks in advance for any help or guidance you may 
be able to offer

Regards
Fred James


--
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 Calc Enhancement Request

[Regina Henschel]

Hi Curtis,

LibreOffice has named ranges, data ranges and scenarios. It is likely, 
that LibreOffice has already a suitable feature. To be able to help you 
finding a tool, you need to describe in more details what do you want to do.


Kind regards,
Regina

Curtis Tarazi schrieb am 15.06.2024 um 15:09:

Hello Libreoffice,

This email is not meant to complain, I am a user of your suite, and I love all 
the applications you can use, and that they are all free. I see all the effort 
that all the creators put in, and I love libre office. I recommend it to other 
people as well.

I use Libreoffice calc, and it is almost as good as excel. There is an 
important feature missing however that I would like to request that you add. In 
excel you can make tables, and they are the same throughout all the sheets. You 
can use them in drop down lists, and other stuff. It is a very useful feature, 
and it's the only thing I think is missing in calc that could make it better 
than excel.

So if you read this email, and even take it into consideration for the next 
update, I will grateful. I think many other users will be as well.

Thank you for the amazing office suite that you have provided us with for free.

Kind regrads and gratitude,
Curtis

Sent with [Proton Mail](https://proton.me/) secure email.




--
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 Calc Enhancement Request

[Johnny Rosenberg]

Den lör 15 juni 2024 kl 16:36 skrev Curtis Tarazi :

> Hello Libreoffice,
>
> This email is not meant to complain, I am a user of your suite, and I love
> all the applications you can use, and that they are all free. I see all the
> effort that all the creators put in, and I love libre office. I recommend
> it to other people as well.
>

I think most people reading this are just users just like you and me, so
it's not ”our suite”. You can request new features where bugs are filed,
there's information about that somewhere at http://www.libreoffice.org/.


>
> I use Libreoffice calc, and it is almost as good as excel.
>

Very subjective. For me it's the other way around. Excel is missing some
essential features that I need from time to time, so it's all depending on
what you want to do with it. They are both missing features that the other
one has, and some features are better implemented in one of them than the
other and so on.

>
>
> There is an important feature missing however that I would like to request
> that you add. In excel you can make tables, and they are the same
> throughout all the sheets. You can use them in drop down lists, and other
> stuff. It is a very useful feature, and it's the only thing I think is
> missing in calc that could make it better than excel.
>

What are they called in Excel? Just ”tables”? I don't think I ever saw them
and I use Excel at work every day.


>
> So if you read this email, and even take it into consideration for the
> next update, I will grateful. I think many other users will be as well.
>

I'm not so sure many developers read this, but a few might, I guess.


Kind regards

Johnny Rosenberg


> Thank you for the amazing office suite that you have provided us with for
> free.
>
> Kind regrads and gratitude,
> Curtis
>
> Sent with [Proton Mail](https://proton.me/) secure email.
> --
> 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] Word won't open some .doc documents created in LO

[LO . Harald . Berger]

Hi Eric,

those who use LibreOffice should check the following settings in 
LibreOffice:

Tools > Options > Load/Save > General ODF-format version
try 1.2 Extended (compatibility mode)
or compare with someone for whom it works.

and than have a look at:
Tools > Options > LibreOffice Writer > Compatibility
compare with someone for whom it works.

Good luck!

Freundliche Grüße
Harald

Am 15.06.2024 um 19:01 schrieb Eric Beversluis:
I'm in a writers' critique group who distribute our monthly 
submissions in .doc format for the sake of a member who doesn't think 
his system can handle .docx. (But that's a different issue.)


One of our members composes his submission in LO Writer and saves as 
.doc (which several of us do). But for some reason some of us are 
having trouble opening that person's submissions in M$ Word (although 
they open fine in LO Writer). Yet the member who just uses Word is not 
having trouble opening the .doc file. (I suspect he has an older 
version of Word, but it's hard to get that information from him.)


When I create a .doc file in LO Writer, I don't have trouble opening 
it in Word.


The member whose .doc files we can't open tells me he's using Libra 
Office 24.2 on Windows. (I assume he means LibreOffice.) It appears 
that's a later version than the 7.3 I'm using on Windows.


So is this maybe a bug in 24.2? 



--
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] Word won't open some .doc documents created in LO

[Eric Beversluis]

I'm in a writers' critique group who distribute our monthly submissions 
in .doc format for the sake of a member who doesn't think his system can 
handle .docx. (But that's a different issue.)


One of our members composes his submission in LO Writer and saves as 
.doc (which several of us do). But for some reason some of us are having 
trouble opening that person's submissions in M$ Word (although they open 
fine in LO Writer). Yet the member who just uses Word is not having 
trouble opening the .doc file. (I suspect he has an older version of 
Word, but it's hard to get that information from him.)


When I create a .doc file in LO Writer, I don't have trouble opening it 
in Word.


The member whose .doc files we can't open tells me he's using Libra 
Office 24.2 on Windows. (I assume he means LibreOffice.) It appears 
that's a later version than the 7.3 I'm using on Windows.


So is this maybe a bug in 24.2?
--
Eric Beversluis
www.ericbeversluis.com
2x Honorable Mention--Writer's Digest Contest

--
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] Libreoffice Calc Enhancement Request

[Curtis Tarazi]

Hello Libreoffice,

This email is not meant to complain, I am a user of your suite, and I love all 
the applications you can use, and that they are all free. I see all the effort 
that all the creators put in, and I love libre office. I recommend it to other 
people as well.

I use Libreoffice calc, and it is almost as good as excel. There is an 
important feature missing however that I would like to request that you add. In 
excel you can make tables, and they are the same throughout all the sheets. You 
can use them in drop down lists, and other stuff. It is a very useful feature, 
and it's the only thing I think is missing in calc that could make it better 
than excel.

So if you read this email, and even take it into consideration for the next 
update, I will grateful. I think many other users will be as well.

Thank you for the amazing office suite that you have provided us with for free.

Kind regrads and gratitude,
Curtis

Sent with [Proton Mail](https://proton.me/) secure email.
-- 
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] Image descriptions not retained

[Thomas Blasejewicz]

On 2024/06/13 18:21, Philip Jackson wrote:

On 13/06/2024 05:23, Thomas Blasejewicz wrote:

On 2024/06/13 10:59, Thomas Blasejewicz wrote:

When you insert an image, the dialogue box where you select the image 
file has a small check box (bottom left) marked 'link'. If you want 
the image to be integrated permanently into your book text, this link 
box should NOT be checked.

Thank you.
Somebody else mentioned that too, but ...
in my version (7.6.6.3) I can not see any check box marked "link".
There is a Hyperlink tab, but except for 3 fields on top, the bottom 
half of the box is just a plain white area.


And yes, I came to the conclusion to have the images in a dedicated 
folder. That I did for some time already.
Apparently now I have to figure out something elegant to move the set of 
writer file+image folder around my computers.


I will report when I found something.
And when I find out, whether the ePublishers are satisfied with the results.

Good night for today
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] Image descriptions not retained

[Philip Jackson]

On 13/06/2024 05:23, Thomas Blasejewicz wrote:

On 2024/06/13 10:59, Thomas Blasejewicz wrote:


Now I am working on this file and make sure, every image gets a name and a 
description.
However, I remember clearly having given every image a name and save the file 
(every few minutes) in my office,
but when I opened the file at home, ALL these names and descriptions are gone.


Maybe I found the answer.
The file I was working on and save in regular intervals is located on something 
like Dropbox - so that I can access it on my computers at home and in the 
office.
Images are inserted using Ctrl+F5, retrieving the images from a folder holding 
all the relevant images.
But the image folder is on my local hard drive, whereas the file I am working on is on a 
"net drive".
So, maybe the writer file on the netdrive looks for the images, but cannot find 
them, since they are on the HDD.
The images themselves DO display just fine.

Do I need ONE folder containing both the writer file AND the image folder to 
move around?
What happens when I am finally done and want to store the finished work on my 
HDDs?


When you insert an image, the dialogue box where you select the image file has 
a small check box (bottom left) marked 'link'. If you want the image to be 
integrated permanently into your book text, this link box should NOT be checked.

If you have linked your images (instead of importing them permanently), you can undo 
the links using Edit > links to external files > break

The advantage of linking comes if the image is subject to future modification. 
In that case, when the image is modified, the document automatically displays 
the updated image.

In any case, with a major work like a book, it is good practice and saves a lot 
of possible troubles, to keep all the images in a sub-folder of the book 
project.

hth, Philip
--
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] Image descriptions not retained

[Thomas Blasejewicz]

On 2024/06/13 15:15, Robert Großkopf wrote:

Hi Thomas,

easiest way is to insert the images into Writer. You could edit this 
images with an external tool when inserted into Writer - no problem.


Linked images I would add in a subfolder of the Writer Document. So 
you could move the Writer document together with the subfolder to any 
other place and the links will work well (relative links).


Regards

Robert
Well, I used Ctrl+F5. I do NOT recall setting any linksnor do I see any 
in the image dialog box.
But, the writer file + all images are available regardless of whether I 
save the file on a net drive, HDD or USB stick.
What is missing though, are all entries under "Name, Text Alternative + 
Description".

But the ePub-lishers complain, when images have no name etc.

"a subfolder of the Writer Document" - how does that work?
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] Image descriptions not retained

[Robert Großkopf]

Hi Thomas,

easiest way is to insert the images into Writer. You could edit this 
images with an external tool when inserted into Writer - no problem.


Linked images I would add in a subfolder of the Writer Document. So you 
could move the Writer document together with the subfolder to any other 
place and the links will work well (relative links).


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] Image descriptions not retained

[Thomas Blasejewicz]

On 2024/06/13 10:59, Thomas Blasejewicz wrote:


Now I am working on this file and make sure, every image gets a name 
and a description.
However, I remember clearly having given every image a name and save 
the file (every few minutes) in my office,
but when I opened the file at home, ALL these names and descriptions 
are gone.



Maybe I found the answer.
The file I was working on and save in regular intervals is located on 
something like Dropbox - so that I can access it on my computers at home 
and in the office.
Images are inserted using Ctrl+F5, retrieving the images from a folder 
holding all the relevant images.
But the image folder is on my local hard drive, whereas the file I am 
working on is on a "net drive".
So, maybe the writer file on the netdrive looks for the images, but 
cannot find them, since they are on the HDD.

The images themselves DO display just fine.

Do I need ONE folder containing both the writer file AND the image 
folder to move around?
What happens when I am finally done and want to store the finished work 
on my HDDs?


Sorry for the trouble
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

[libreoffice-users] Image descriptions not retained

[Thomas Blasejewicz]

Good morning
I am writing / editing a book with a number of images. This is to be 
published as ePub.
I did that before and got an error, telling me "image description is 
missing".
Used F4 to open the image dialog and entered name and description under 
the "Option" tab, then clicked OK.


Now I am working on this file and make sure, every image gets a name and 
a description.
However, I remember clearly having given every image a name and save the 
file (every few minutes) in my office,
but when I opened the file at home, ALL these names and descriptions are 
gone.


May I ask, why that is and if there is something I can do?
This behavior is very annoying and counterproductive.

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] How to I enlarge to normal viewing

[Brad Rogers]

On Wed, 12 Jun 2024 10:04:22 -0700
Silvy Monroe  wrote:

Hello Silvy,

View/Zoom.

-- 
 Regards  _   "Valid sig separator is {dash}{dash}{space}"
 / )  "The blindingly obvious is never immediately apparent"
/ _)rad   "Is it only me that has a working delete key?"
Your life is like a schedule, you run to meet the bills
Life Kills - Human League


-- 
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] How to I enlarge to normal viewing

[Silvy Monroe]

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

[Vince@Verizon]

Be sure to include the *$* symbol in the Array.

Remember: the Index, *2*, represents the (second) column, which is 
referenced to the leftmost column within the (locked) Array, *$A$2:$B$4*.


NOTE: The data in column *A *need not be only a numeric value; the data 
may be text also.




Op 7 jun. 2024, om 19:11 heeft Ekerette Ekpo  het volgende 
geschreven:

How did you do it with vlookup? I tried it out and ended up with a #N/A in
cell B4.



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

[Rob Jasper]

=VLOOKUP(A4;$A$1:$B$3;2;0)

The last argument (0) makes VLOOKUP find an exact match to whatever is in A4.
This means that if A4 is empty, or contains a value that does not exist in the 
range it will respond with N/A



> Op 7 jun. 2024, om 19:11 heeft Ekerette Ekpo  het 
> volgende geschreven:
> 
> How did you do it with vlookup? I tried it out and ended up with a #N/A in
> cell B4.
> 
> On Thu, 6 Jun 2024, 22:33 James,  wrote:
> 
>> Thanks, got vlookup to do what I want. :-)
>> 
>> --
>> 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] calc

[Ekerette Ekpo]

How did you do it with vlookup? I tried it out and ended up with a #N/A in
cell B4.

On Thu, 6 Jun 2024, 22:33 James,  wrote:

> Thanks, got vlookup to do what I want. :-)
>
> --
> 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] calc

[James]

Thanks, got vlookup to do what I want. :-)

--
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] Libre office writer

[James]

Is the long list in any other file?
I think it is gone from Writer and you need to restore it from a backup.

translate.google.com

On 2024-06-05 18:31, Harry Stoller wrote:

Hello. During data recovery, I recovered Libre office writer. Almost
everything from it recovered. Some writing isn't how it used to be.
Like a long list of problem solving. After recovery, it made itself
short. Anything I can do to recover writing how it was before?

Some are in Chinese too. How do I translate?



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

[hymie!]

I believe what OP wants is  "Give me the contents of the cell at Column B,
Row the-number-that-appears-in-cell-A4"

I think it can be done with CONCAT but I wouldn't bet money on it.

--hymie!

On Thu, Jun 06, 2024 at 12:43:17PM +0200, Rob Jasper wrote:
> If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what 
> you want
> 
> 
> > Op 6 jun. 2024, om 05:33 heeft James  het volgende 
> > geschreven:
> > 
> > Say I have column A with the numbers 1, 2, 3:
> > A1 (1)
> > A2 (2)
> > A3 (3)
> > and column B with the numbers 11, 22, 33:
> > B1 (11)
> > B2 (22)
> > B3 (33)
> > 
> > Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch 
> > which row is referenced so I can see the effects of different choices).
> > 
> > Is there a calc function which can find which row I chose so I 
> > automatically populate row 4, column B?
> > Row 4, column A matches one of the rows 1-3...
> > 
> > -- 
> > 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] calc

[hymie!]

Ignore me, I think I misunderstodd your "vlookup" command which now
looks right to me.  Sorry.

--hymie!

On Thu, Jun 06, 2024 at 08:10:42AM -0400, hymie! wrote:
> I believe what OP wants is  "Give me the contents of the cell at Column B,
> Row the-number-that-appears-in-cell-A4"
> 
> I think it can be done with CONCAT but I wouldn't bet money on it.
> 
> --hymie!
> 
> On Thu, Jun 06, 2024 at 12:43:17PM +0200, Rob Jasper wrote:
> > If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what 
> > you want
> > 
> > 
> > > Op 6 jun. 2024, om 05:33 heeft James  het volgende 
> > > geschreven:
> > > 
> > > Say I have column A with the numbers 1, 2, 3:
> > > A1 (1)
> > > A2 (2)
> > > A3 (3)
> > > and column B with the numbers 11, 22, 33:
> > > B1 (11)
> > > B2 (22)
> > > B3 (33)
> > > 
> > > Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch 
> > > which row is referenced so I can see the effects of different choices).
> > > 
> > > Is there a calc function which can find which row I chose so I 
> > > automatically populate row 4, column B?
> > > Row 4, column A matches one of the rows 1-3...
> > > 
> > > -- 
> > > 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] calc

[Rob Jasper]

If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what you 
want


> Op 6 jun. 2024, om 05:33 heeft James  het volgende 
> geschreven:
> 
> Say I have column A with the numbers 1, 2, 3:
> A1 (1)
> A2 (2)
> A3 (3)
> and column B with the numbers 11, 22, 33:
> B1 (11)
> B2 (22)
> B3 (33)
> 
> Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch which 
> row is referenced so I can see the effects of different choices).
> 
> Is there a calc function which can find which row I chose so I automatically 
> populate row 4, column B?
> Row 4, column A matches one of the rows 1-3...
> 
> -- 
> 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] [SOLVED] Table of Contents, again

[Thomas Blasejewicz]

Good afternoon


On 2024/06/05 20:12, W. Robert J. Funnell, Prof. wrote:

Thomas -

In the 'Table of Contents, Index or Bibliography' dialogue window, in the 
'Type' tab, under 'Create From', is the 'Additional styles' box unchecked?

No, it was checked. I did that before. Apparently, you DO HAVE to check 
it and assign OTHER STYLES than
those of the headings. They are designed to provide some extra space, 
font size etc. for chapter headings.

Using them creates a total mess.
Where the inclusion of ALL paragraphs comes from I still have not 
figured out.


The solution to my basic problem:
Use / create other paragraph styles, in my case I tried "contents", set 
font size, indent etc. and I got a single-spaced TOC.


The LO manual says:
"*Additional styles
*You *_can _*add more paragraph styles to the TOC. This *_can _*be 
useful, for example, when you want to include the heading of an annex 
(appendix) in the TOC."


Apparently you MUST these extra paragraph styles to make the TOC work.
When I first tried to set up a TOC, clutching the manual, I did not give 
that wording a second thought, since there

are a lot of things you "can" but do not have to do.

Well, for the time being I solved the problem, hoping to remember it 
until the next time.

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

[libreoffice-users] Libre office writer

[Harry Stoller]

Hello. During data recovery, I recovered Libre office writer. Almost
everything from it recovered. Some writing isn't how it used to be.
Like a long list of problem solving. After recovery, it made itself
short. Anything I can do to recover writing how it was before?

Some are in Chinese too. How do I translate?
-- 
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] calc

[Brian Barker]

At 23:33 05/06/2024 -0400, James Lockie wrote:

Say I have column A with the numbers 1, 2, 3:
A1 (1)
A2 (2)
A3 (3)
and column B with the numbers 11, 22, 33:
B1 (11)
B2 (22)
B3 (33)

Column A Row 4 contains a reference to one of row 1, 2, or 3 (I 
switch which row is referenced so I can see the effects of different choices).


It's not clear what you mean by a "reference". I'm guessing you mean 
that A4 contains just one of the numbers (1, 2, or 3) that appear in 
your list, not a true reference, such as "=A1"? Otherwise the problem 
would be trivial.


Is there a calc function which can find which row I chose so I 
automatically populate row 4, column B?


Yup. In B4, enter:
=VLOOKUP(A4;A1:B3;2;FALSE)

VLOOKUP() looks for the value in A4 in the first column of the array 
A1:B3 (i.e. column A) and returns as its result the corresponding 
value in column 2 of the array (i.e. column B). The FALSE parameter 
indicates that the values in column A are not necessarily in 
ascending order. If you know they are in such order, you can use TRUE 
(or omit that parameter); that allows the program to calculate faster 
but also means that a value may be returned even if an exact match 
does not exist - which I'm guessing you wouldn't want.



Row 4, column A matches one of the rows 1-3...


You may want to look into the detail of how to handle cases where the 
value in A4 either does not appear in the list or even appears more than once.


I trust this helps.

Brian Barker


--
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] calc: all links broken in existing spreadsheet

[Robert Großkopf]

Hi Tom,


I just upgraded to:

Version: 7.6.7.2 (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.6.7-0ubuntu0.23.10.1~bpo22.04.1
Calc: threaded


From which version did you "upgrade".


All links in my major daily planner spreadsheet are now broken. 


Does appear any tooltip if you move the mouse over a link? Something 
like [Ctrl+Click]?


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] calc

[James]

Say I have column A with the numbers 1, 2, 3:
A1 (1)
A2 (2)
A3 (3)
and column B with the numbers 11, 22, 33:
B1 (11)
B2 (22)
B3 (33)

Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch 
which row is referenced so I can see the effects of different choices).


Is there a calc function which can find which row I chose so I 
automatically populate row 4, column B?

Row 4, column A matches one of the rows 1-3...

--
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] calc: all links broken in existing spreadsheet

[Tom Cloyd MS MA]

I just upgraded to:

Version: 7.6.7.2 (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.6.7-0ubuntu0.23.10.1~bpo22.04.1
Calc: threaded

All links in my major daily planner spreadsheet are now broken. The same 
is true for all other spreadsheets I've examined.


I have search online help for any information that would resolve the 
problem; none was found.


I have tried redefining a link; it achieves nothing.

This is a major disaster for me.

Any ideas how I can resolve this?

t.

--

~
“Love recognizes no barriers. It jumps hurdles, leaps fences, penetrates walls
to arrive at its destination full of hope.” ~ Maya Angelou
~
Tom Cloyd, MS MA LMHC (WA) | t...@tomcloyd.com
Psychological trauma & dissociative disorders, treatment, research, & advocacy
Spokane, Washington, U.S.A. | (435) 272-3332
https://www.gettraumainfo.com/ (professional)
Facebook: https://www.facebook.com/groups/645665272216298/
www.tomcloyd.com/ (personal)
~
System76 Galago Pro (galp5) laptop
Processors: 8 × 11th Gen Intel® Core™ i7-1165G7 @ 2.80GHz
RAM: 16 GB Dual Channel DDR4 at 3200 MHz
Storage: 500 GIB SSD
Operating System: Pop!_OS 22.04 LTS
Kernel Version: 6.2.6-76060206-generic x86_64
Gnome ver. 42.5
Windowing system: X11
Qt Version: 5.13.3
[updated 2023-05-09:1420]


--
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 Office and Evolution to mail merge contacts

[Robert Großkopf]

Hi Johnp,


I am having trouble finding the EvolutionLocal in the exchange
database. Any suggestions would be appreciated.

Just openes LO 24.2.3.2 in OpenSUSE 64bit rpm Linux. No problem to get 
an entry for Evolution local.


Which system and which version of LO do you use. Mine:

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] Using Libre Office and Evolution to mail merge contacts

[Johnp]

I am having trouble finding the EvolutionLocal in the exchange
database. Any suggestions would be 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] Table of Contents, again

[W. Robert J. Funnell, Prof.]

Thomas -

In the 'Table of Contents, Index or Bibliography' dialogue window, in the 
'Type' tab, under 'Create From', is the 'Additional styles' box unchecked?

- Robert


From: Thomas Blasejewicz 
Sent: Wednesday, June 5, 2024 04:56
To: libreoffice-users 
Subject: [libreoffice-users] Table of Contents, again

Good evening
I had much trouble with TOCs over last few months.
In a few instances I SOMEHOW managed to get almost what I wanted.

Now, working on a different file, completed the ePub version, try to set
up a TOC.
Heading 1 + Heading 2 properly set, as far as I can tell.
Tools -> Heading numbering set properly (I hope).

Still, inserting a TOC that is supposed to show Heading 1 + 2 includes
EVERY paragraph of the entire document.
Working for hour to set this straight, I still "do not get it".

Could someone please point me to the thing that needs fixed.
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] Table of Contents, again

[Robert Großkopf]

Hi Thomas,


Heading 1 + Heading 2 properly set, as far as I can tell.
Tools -> Heading numbering set properly (I hope).

Still, inserting a TOC that is supposed to show Heading 1 + 2 includes 
EVERY paragraph of the entire document.


Set some paragraphs to "Heading1" and "Heading2". Other paragraphs are 
"TextBody".

Set numbering for the headings as decribed above.
Created a TOC.
Couldn't see any other content than Heading1 and Heading2 in Toc.

I don't know what is gowing wrong with your document.

Using LO 24.2.3.2 on OpenSUSE Linux here.

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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] Table of Contents, again

[Thomas Blasejewicz]

Good evening
I had much trouble with TOCs over last few months.
In a few instances I SOMEHOW managed to get almost what I wanted.

Now, working on a different file, completed the ePub version, try to set 
up a TOC.

Heading 1 + Heading 2 properly set, as far as I can tell.
Tools -> Heading numbering set properly (I hope).

Still, inserting a TOC that is supposed to show Heading 1 + 2 includes 
EVERY paragraph of the entire document.

Working for hour to set this straight, I still "do not get it".

Could someone please point me to the thing that needs fixed.
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

[libreoffice-users] Link Endnote file with LibreOffice Writer

[Lubczynski, Maciek (UT)]

Support of LibreOffice Writer,

Following the reply of the Endnote support office (see below), it looks like 
the 64-bit LibreOffice 7.6.7 is not compatible with Endnote, correct?.

  1.
Is 32-bit LibreOffice 7.6.7 compatible with EndNote?
  2.
Is LibreOffice (32- or 64-bit) compatible with EndNote?
  3.
If answer to 1 and 2 is NOT, then what do you recommend to link my Endnote file 
with LibreOffice Writer?

Thanks in advance,

Maciek Lubczynski  (University Twente, The Netherlands)

--
Dear M,

Thank you for contacting Clarivate EndNote Support.

I understand that you have a query with regards to EndNote. I will certainly 
assist you with this.

Please allow me to look closely at your case and get back to you soon with a 
proper solution.

I appreciate your patience and understanding on this matter.

For a quick reference to common solutions, please visit our new EndNote FAQ.

Kindly note that our number has changed. Our new number can be found here 
(Please press Option 2 for EndNote).

Kind regards,

Danny
Customer Care Advisor - EndNote

clarivate.com  | Think forward™

Please consider the environment before printing this email

--
Copy of your original request sent to Clarivate Analytics:
Date of request: 6/4/2024
Case #: CM-240604-7265146
Subject: Libreoffice writer 7.6 and Endnote 9
Description:
You don't often get email from m.w.lubczyn...@utwente.nl. Learn why this is 
important


From: Lubczynski, Maciek (UT) 
Sent: Tuesday, June 4, 2024 11:12 AM
To: EndNote Product Support 
Subject: Re: Clarivate Case # CM-240604-7265146 : Libreoffice writer 7.6 and 
Endnote 9 [ ref:!00D4101O1D5.!500KY05rePJ:ref ]

Hi,

I am stuck trying to use my Endnote (X9) file with 64-bit Libreoffice 7.6.7 - I 
cannot click the bottom panel. I also cannot install manually the Endnote X9 
CWYM file EndNote.oxt  - see the declining message in the other screen dump

Does that mean that Libreoffice 7.6.7 is not supported? This is the version 
recommended by Libreoffice. If so, will the other Libreoffice version 24.2.3 be 
compatible with Endnote?

By the way I have 64-bit machine...

cheers,

Maciek

[cid:8a553ba3-6b11-4b99-a71c-3475bcf0f57e]

[cid:3e57a03d-049a-4442-b740-690f08dd19ad]


From: EndNote Product Support 
Sent: Tuesday, June 4, 2024 10:40 AM
To: Lubczynski, Maciek (UT) 
Subject: Clarivate Case # CM-240604-7265146 : Libreoffice writer 7.6 and 
Endnote 9 [ ref:!00D4101O1D5.!500KY05rePJ:ref ]

[1684234754937]

Dear M,

Thank you for contacting Clarivate EndNote Support.

I understand that you have a query with regards to EndNote. I will certainly 
assist you with this.

Please allow me to look closely at your case and get back to you soon with a 
proper solution.

I appreciate your patience and understanding on this matter.

For a quick reference to common solutions, please visit our new EndNote 
FAQ.

Kindly note that our number has changed. Our new number can be found 
here (Please press Option 2 for EndNote).

Kind regards,

Danny
Customer Care Advisor - EndNote

clarivate.com  | Think forward™

Please consider the environment before printing this email

--
Copy of your original request sent to Clarivate Analytics:
Date of request: 6/4/2024
Case #: CM-240604-7265146
Subject: Libreoffice writer 7.6 and Endnote 9
Description:
You don't often get email from m.w.lubczyn...@utwente.nl. Learn why this is 
important
Hi,

I am trying to link my Endnote9 file with Libreoffce writer 7.6. I read in 
Google that in Tools I have to go to Extension Manager, but it is not there. 
What am I supposed to do? How to link my Endnote database to Libreoffce writer 
7.6? Should I download other version of LibreOffice?

Best regards,

Maciek Lubczynski





--- Original Message ---
From: Lubczynski, Maciek [m.w.lubczyn...@utwente.nl]
Sent: 6/4/2024 3:42 PM
To: endnote.supp...@clarivate.com
Subject: Libreoffice writer 7.6 and Endnote 9


You don't often get email from m.w.lubczyn...@utwente.nl. Learn why this is 
important

Hi,

I am trying to link my Endnote9 file with Libreoffce writer 7.6. I read in 
Google that in Tools I have to go to Extension Manager, but it is not there. 
What am I supposed to do? How to link my Endnote database to Libreoffce writer 
7.6? Should I download other version of LibreOffice?

Best regards,

Maciek Lubczynski
[https://clarivateanalytics.my.salesforce.com/servlet/servlet.ImageServer?oid=00D4101O1D5=018KY02FjES=ext]

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

[Howard Barr]

Hello Michael

click and copy the contents of the cell then select the OLE >>QRcode and
paste it in.
Hope that helps.

On Mon, 3 Jun 2024 at 23:39, Michael Tiernan 
wrote:

> I'm wondering if I missed something.
>
> In "calc", the "Insert" -> "OLE Object" -> "QR and Barcode" option gives me
> a window that allows me to put "text" into the field which it then
> generates the graphic from.
>
> Did I miss it? How do I tell it to use the contents of a cell as the source
> of the graphic?
> (I have generated a series of values that I want to use to create a QR code
> for each one.)
> Thanks for everyone's time.
>
> --
> << MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan
>
> Non Impediti Ratione Cogatationis
> Women and cats will do as they please, and
> men and dogs should relax and get used to the idea. -Robert A. Heinlein
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
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] Use of QR/Barcode insertion.

[Michael Tiernan]

I'm wondering if I missed something.

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

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

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

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

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

RE: [libreoffice-users] Libreoffice Calc

[dboland9]

Sent with Proton Mail secure email.

On Thursday, May 30th, 2024 at 7:13 PM, Virgil Arrington  
wrote:

> I have found several of your emails in my junk email folder. I find that over 
> half of all emails from the LO list go to my junk folder.
> 
> Virgil
> 
> 
> From: ady adylo811...@gmail.com
> 
> Sent: Thursday, May 30, 2024 7:00:02 PM
> To: users@global.libreoffice.org users@global.libreoffice.org
> 
> Subject: Re: [libreoffice-users] Libreoffice Calc
> 
> > For some reason my questions are not getting posted. Hopefully the fourth 
> > attempt works.
> 
> 
> There are at least 2 emails from you in the public users mailing list;
> see the mailing list public archives. I am replying to one of them.
> 
> > Software: LO, Version 7.3.7.2, Linux (Mint)
> > 
> > I thought that LO Calc would let one start typing c, o, l and get 
> > coliflour. Is there some way to do this,or is it a feature request?
> 
> 
> The feature is called "AutoInput". In Calc, you can set it ON/OFF in
> menu Tools > AutoInput.
> 
> 
> In Calc, if you already have a value in one cell and you want to
> repeat the same value in another cell in the same column – it works
> better if the range has no empty blank cells in-between, but that's
> not a strict condition – then usually the behavior is as you
> described.
> 
> If you have "coliflour" (without quotation marks) in cell A1, and
> something else in cell A2, then in cell A3 you could start typing "c"
> (without quotation marks), then a prior (partial) value would be
> suggested, instead of having to type-in the complete value each time.
> 
> As of current versions, the feature works similar to a bash-like
> (auto)completion, but incidentally the feature was modified several
> times between LO 7.1 and 7.3, so if you are having problems with this
> I would suggest trying a newer version that you currently report
> (7.3.7.2).
> 
> See:
> https://help.libreoffice.org/latest/en-US/text/scalc/guide/auto_off.html?DbPAR=CALC
> 
> 
> https://help.libreoffice.org/latest/en-US/text/scalc/01/0613.html?=CALC
> 
> 
> HTH,
> Ady.
> 
Virgil,

Thanks for the reply.  I checked my spam folder, no LO there.  My expectation 
was that when I sen a note to the list for support, I would get a copy back.  
That didn't happen so I kept posting.  My apologies to anyone offended!

AutoInput only works for cells in the same column.  As I tried to explain, the 
lists of inputs are in another sheet to keep the input form cleaner looking.

So it looks like a very long scroll bar is the only option for now.

Thanks,
Dave


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

[aguador]

Hi Laura,

Collabora, a LibreOffice contributor, has a LibreOffice based suite for
Android. If you use the PlayStore it is available there
(https://play.google.com/store/apps/details?id=com.collabora.libreoffice=en_US
) --with some less than completely positive comments.

Collabora is/was available via f-droid, but it requires some doing from
what I have seen. A quick search will help with that.

Best,
Roy

El dom, 02-06-2024 a las 13:49 +1000, Keith Bainbridge escribió:
> There is LibreOffice viewer which opens a large spreadsheet quickly,
> and opened a .odt table, which was sent to me as .DOCX and converted
> on my PC.  Worth a try.   
> 
> I think the problem getting LO to run on android is the lack of
> people to develop it more than the ability of the current hardware.  
> -- 
> All the best
> 
> Keith Bainbridge
> 
> keithr...@gmail.com
> +61 (0)447 667 468
> 
> UTC+ 10:00
> 
> From my Aphone 
> 
> On 2 June 2024 9:31:49 am AEST, Mike Flannigan 
> wrote:
> > 
> > I didn't know tablets were so handicapped.
> > I guess I will stay away from those.
> > 
> > 
> > Mike
> > 
> > 
> > On 5/31/24 23:03, users+h...@global.libreoffice.org wrote:
> > > I use LibreOffice suite on my desktop pc and can find my way
> > > around it
> > > easily (sometimes I need to search your website for assistance).
> > > 
> > > I have recently bought a Lenovo P11 tablet (discontinued stock)
> > > and would
> > > LOVE to be able to use LibreOffice on it! It is frustrating that
> > > if I do
> > > not pay for Microsoft (I do not like their new operating system —
> > > or the
> > > expense!), I am unable to use my tablet to its full capacity. I
> > > cannot open
> > > any text documents on the tablet that I email myself from my pc!
> > > I cannot
> > > use any document software, unless I use Microsoft.
> > > 
> > > Please, please create an office Suite for tablets! I cannot be
> > > the only
> > > person that needs this in my life! At least the Writer element!
> > > 
> > > Thank you
> > > 
> > > Best wishes
> > > Laura
> > 
> > 
> > -- 
> > 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] LibreOffice suite

[Howard Barr]

https://www.collaboraoffice.com/

I use this on my Android phone and tablet and it is Open Source and free to
use.




On Sun, 2 Jun 2024, 12:53 Keith Bainbridge,  wrote:

> There is LibreOffice viewer which opens a large spreadsheet quickly, and
> opened a .odt table, which was sent to me as .DOCX and converted on my PC.
> Worth a try.
>
> I think the problem getting LO to run on android is the lack of people to
> develop it more than the ability of the current hardware.
> --
> All the best
>
> Keith Bainbridge
>
> keithr...@gmail.com
> +61 (0)447 667 468
>
> UTC+ 10:00
>
> From my Aphone
>
> On 2 June 2024 9:31:49 am AEST, Mike Flannigan  wrote:
> >
> >I didn't know tablets were so handicapped.
> >I guess I will stay away from those.
> >
> >
> >Mike
> >
> >
> >On 5/31/24 23:03, users+h...@global.libreoffice.org wrote:
> >> I use LibreOffice suite on my desktop pc and can find my way around it
> >> easily (sometimes I need to search your website for assistance).
> >>
> >> I have recently bought a Lenovo P11 tablet (discontinued stock) and
> would
> >> LOVE to be able to use LibreOffice on it! It is frustrating that if I do
> >> not pay for Microsoft (I do not like their new operating system — or the
> >> expense!), I am unable to use my tablet to its full capacity. I cannot
> open
> >> any text documents on the tablet that I email myself from my pc! I
> cannot
> >> use any document software, unless I use Microsoft.
> >>
> >> Please, please create an office Suite for tablets! I cannot be the only
> >> person that needs this in my life! At least the Writer element!
> >>
> >> Thank you
> >>
> >> Best wishes
> >> Laura
> >
> >
> >--
> >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] LibreOffice suite

[Keith Bainbridge]

There is LibreOffice viewer which opens a large spreadsheet quickly, and opened 
a .odt table, which was sent to me as .DOCX and converted on my PC.  Worth a 
try.   

I think the problem getting LO to run on android is the lack of people to 
develop it more than the ability of the current hardware.   
-- 
All the best

Keith Bainbridge

keithr...@gmail.com
+61 (0)447 667 468

UTC+ 10:00

From my Aphone 

On 2 June 2024 9:31:49 am AEST, Mike Flannigan  wrote:
>
>I didn't know tablets were so handicapped.
>I guess I will stay away from those.
>
>
>Mike
>
>
>On 5/31/24 23:03, users+h...@global.libreoffice.org wrote:
>> I use LibreOffice suite on my desktop pc and can find my way around it
>> easily (sometimes I need to search your website for assistance).
>> 
>> I have recently bought a Lenovo P11 tablet (discontinued stock) and would
>> LOVE to be able to use LibreOffice on it! It is frustrating that if I do
>> not pay for Microsoft (I do not like their new operating system — or the
>> expense!), I am unable to use my tablet to its full capacity. I cannot open
>> any text documents on the tablet that I email myself from my pc! I cannot
>> use any document software, unless I use Microsoft.
>> 
>> Please, please create an office Suite for tablets! I cannot be the only
>> person that needs this in my life! At least the Writer element!
>> 
>> Thank you
>> 
>> Best wishes
>> Laura
>
>
>-- 
>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] LibreOffice suite

[Mike Flannigan]

I didn't know tablets were so handicapped.
I guess I will stay away from those.


Mike


On 5/31/24 23:03, users+h...@global.libreoffice.org wrote:

I use LibreOffice suite on my desktop pc and can find my way around it
easily (sometimes I need to search your website for assistance).

I have recently bought a Lenovo P11 tablet (discontinued stock) and would
LOVE to be able to use LibreOffice on it! It is frustrating that if I do
not pay for Microsoft (I do not like their new operating system — or the
expense!), I am unable to use my tablet to its full capacity. I cannot open
any text documents on the tablet that I email myself from my pc! I cannot
use any document software, unless I use Microsoft.

Please, please create an office Suite for tablets! I cannot be the only
person that needs this in my life! At least the Writer element!

Thank you

Best wishes
Laura



--
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] LibreOffice suite

[Laura Campbell]

Good morning

I use LibreOffice suite on my desktop pc and can find my way around it
easily (sometimes I need to search your website for assistance).

I have recently bought a Lenovo P11 tablet (discontinued stock) and would
LOVE to be able to use LibreOffice on it! It is frustrating that if I do
not pay for Microsoft (I do not like their new operating system — or the
expense!), I am unable to use my tablet to its full capacity. I cannot open
any text documents on the tablet that I email myself from my pc! I cannot
use any document software, unless I use Microsoft.

Please, please create an office Suite for tablets! I cannot be the only
person that needs this in my life! At least the Writer element!

Thank you

Best wishes
Laura

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

[Virgil Arrington]

I have found several of your emails in my junk email folder. I find that over 
half of all emails from the LO list go to my junk folder.

Virgil


From: ady 
Sent: Thursday, May 30, 2024 7:00:02 PM
To: users@global.libreoffice.org 
Subject: Re: [libreoffice-users] Libreoffice Calc

> For some reason my questions are not getting posted. Hopefully the fourth 
> attempt works.

There are at least 2 emails from you in the public users mailing list;
see the mailing list public archives. I am replying to one of them.


> Software: LO, Version 7.3.7.2, Linux (Mint)
>
> I thought that LO Calc would let one start typing c, o, l and get coliflour. 
> Is there some way to do this,or is it a feature request?

The feature is called "AutoInput". In Calc, you can set it ON/OFF in
menu Tools > AutoInput.

In Calc, if you already have a value in one cell and you want to
repeat the same value in another cell in the same column – it works
better if the range has no empty blank cells in-between, but that's
not a strict condition – then usually the behavior is as you
described.

If you have "coliflour" (without quotation marks) in cell A1, and
something else in cell A2, then in cell A3 you could start typing "c"
(without quotation marks), then a prior (partial) value would be
suggested, instead of having to type-in the complete value each time.

As of current versions, the feature works similar to a bash-like
(auto)completion, but incidentally the feature was modified several
times between LO 7.1 and 7.3, so if you are having problems with this
I would suggest trying a newer version that you currently report
(7.3.7.2).

See:
 


 


HTH,
Ady.

--
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] Libreoffice Calc

[ady]

> For some reason my questions are not getting posted. Hopefully the fourth 
> attempt works.

There are at least 2 emails from you in the public users mailing list;
see the mailing list public archives. I am replying to one of them.


> Software: LO, Version 7.3.7.2, Linux (Mint)
>
> I thought that LO Calc would let one start typing c, o, l and get coliflour. 
> Is there some way to do this,or is it a feature request?

The feature is called "AutoInput". In Calc, you can set it ON/OFF in
menu Tools > AutoInput.

In Calc, if you already have a value in one cell and you want to
repeat the same value in another cell in the same column – it works
better if the range has no empty blank cells in-between, but that's
not a strict condition – then usually the behavior is as you
described.

If you have "coliflour" (without quotation marks) in cell A1, and
something else in cell A2, then in cell A3 you could start typing "c"
(without quotation marks), then a prior (partial) value would be
suggested, instead of having to type-in the complete value each time.

As of current versions, the feature works similar to a bash-like
(auto)completion, but incidentally the feature was modified several
times between LO 7.1 and 7.3, so if you are having problems with this
I would suggest trying a newer version that you currently report
(7.3.7.2).

See:
 


 


HTH,
Ady.

-- 
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] Libreoffice Calc

[dboland9]

For some reason my questions are not getting posted. Hopefully the fourth 
attempt works.

Software: LO, Version 7.3.7.2, Linux (Mint)

Problem: I was asked about autocomplete for cells in Calc. My response was to 
use a list of cells in Validity. Unfortunately, only a vertical scroll bar is 
available, which works fine for short lists, but not so great when the list is 
over 1000 cells in another sheet (same file though). I thought that LO Calc 
would let one start typing c, o, l and get coliflour. Is there some way to do 
this,or is it a feature request?

Thanks,
Dave

Sent with [Proton Mail](https://proton.me/) secure email.
-- 
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] Problem in inserting text area in writer

[MGR]

Hi !

if you want to attach a text area to a paragraph or to a character 
owning to a paragraph starting in previous page, this does not work. If 
you attach a text area to a paragraph or a character owning to a 
paragraph, the text is attached too to the page where the paragraph 
starts. So that if a paragraph is extended to the next page, you cannot 
attach the text area to a character owning to the second page. The text 
area jumps to the first page of the area.


Best regards.

MGR.


--
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] Spreadsheet Print Behavior

[Dave Liesse]

Hi, all.  I just ran into a problem that has never occurred before, and while I 
had a workaround for my immediate need I'm wondering if I'm just overlooking 
something.

First, the specs: LO v7.3.4.2, Windows 10 fully up to date.

I have some spreadsheets that a client prepared in Google Docs and converted to 
Microsoft Excel before sending to me.  I, of course, opened them in 
LibreOffice.  Because there are a couple of cells out to the right with 
information I don't need at the moment, I set a print range.  Also set the page 
style to print landscape, 1-page width.  When I print, though, only the first 
page prints.  If I also set it to print only 1 page vertically the whole thing 
will print but it's too small to read, even with my 20/10 near vision!

Just wondering if this is working as designed (although I would then wonder 
why), or if I'm simply overlooking something, or if it's a bug.  I've been 
working with this particular series of spreadsheets for some time and never had 
any problems, although this may be the first time any would have been more than 
one page long.  I don't recall this problem with any other documents ever, 
though.

Dave

-- 
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] Calc auto complete from a list of cells

[dboland9]

I was asked how to make an auto complete from a list of cells in another sheet 
in the same file. I thought the validation would work, but it only supports a 
scroll bar. That is fine for short lists, but not for hundreds of lines. Any 
suggestions on how to do this? I have seen it in some apps. I played with 
VLOOKUP, but it doesn't return a list. If there is no good way to do this, can 
it be a feature request?

Thanks,
Dave

Sent with [Proton Mail](https://proton.me/) secure email.
-- 
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] Table of contents problem

[Thomas Blasejewicz]

Good evening
I am clutching a printed section of the Writer manual dealing the TOC 
... but cannot make it work.
Searching the net, I did find a LOT of things, but the instructions 
there "... click xx and there you go" do not seem to work either.


Windows 10, LibreOffice 7.6.6.3
200-page document with heading 1 and heading 2 sections supposed to be 
entered automatically into the TOC.
I once HAD it, but removed it, because submitting the file to an ePub 
publisher should not have a TOC (that's what their manual said).


Now I am preparing a print version and would like to have it back.
Previously it was a 1.5-page long TOC consisting of said headings.
Now the same TOC is 16 (!) pages long with giant spaces between the 
items AND each item is listed twice.
I have been struggling with this for hours on end, but so far nothing I 
tried improved things.

If there is a trick to do this, please let me know.

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] center images anchored "as character"

[Thomas Blasejewicz]

On 2024/05/28 22:51, lo.harald.ber...@t-online.de wrote:

Hi Thomas,

create a new paragraph style as an offshoot of Default. The only 
change you make in it is the alignment to "Centered".

Thank you!
With a little luck, I might have solved the problem.
I will know, when I submit the file to the publisher ...

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

[libreoffice-users] spell check does not "ignore all"

[Thomas Blasejewicz]

And again (sorry!)
Windows 10, Libreoffice 7.6.6.3

I have had this problem for as long as I am using Libreoffice.
But spell checking a 240-page book makes things worse.

During the spell check, the checker comes across words not in the 
dictionary and I tell it, to "ignore all".

But the spell checker does not care about that instruction.
It flags the same term as a mistake EACH AND EVERY TIME it is found.
This applies also to the "reverse" = "correct all" option.
It never did that as far as I can remember.

However, it would be very nice and time-saving, if Libreoffice could 
listen to the instructions and automate the tasks.

What is is, that I am missing here?

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] center images anchored "as character"

[LO . Harald . Berger]

Hi Thomas,

create a new paragraph style as an offshoot of Default. The only change 
you make in it is the alignment to "Centered".


Once you have anchored your image "As character" (the it is left), 
double-click on the new paragraph style to center the image again.


Kind regards
Harald

Am 28.05.2024 um 15:44 schrieb Thomas Blasejewicz:
I am struggling to create a file suitable for publication as an ePub 
format book.
The publisher has all sorts of requirements and I just cannot get them 
right.

Windows 10, Libreoffice 7.6.6.3

One problem:
I am trying to meet the requirement of having images "in line with 
text" and centered.

From the publishers instructions:
"For best results, always be sure that your images are aligned “In 
Line with Text” and centered."


Well, when I anchor the image "as character" and then try to center 
them, the text of the entire book becomes centered.
When I anchor the image "to character", suddenly the captions etc. 
appear on the left side and not below, where they are supposed to be.

Anchoring to paragraph make things still worse.

Searching the net, the proposed answer to this problem was "anchor as 
character" + center.

What is the trick to center ONLY the image, but not the entire text?



--
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] style does NOT display the specified font size

[Thomas Blasejewicz]

One more question
(and another coming in a different post)
Again Windows 10, Libreoffice 7.6.6.3

I created a new style based on "default body text".
The style specifies Times Roman, italic, 12 pt size.
However in half or more of the instances where this style is applied, it 
shows the font in size 10.5.
The only way I could find to correct that, was to open up the property 
dialog and manually change the font size.

And that for over 30 instances.

What was wrong with this style?
The organizer was set to automatically update the style, but obviously 
did not do so.


I hope, knowing what was going on will help me with the next book.

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

[libreoffice-users] center images anchored "as character"

[Thomas Blasejewicz]

Good evening
I am struggling to create a file suitable for publication as an ePub 
format book.
The publisher has all sorts of requirements and I just cannot get them 
right.

Windows 10, Libreoffice 7.6.6.3

One problem:
I am trying to meet the requirement of having images "in line with text" 
and centered.

From the publishers instructions:
"For best results, always be sure that your images are aligned “In Line 
with Text” and centered."


Well, when I anchor the image "as character" and then try to center 
them, the text of the entire book becomes centered.
When I anchor the image "to character", suddenly the captions etc. 
appear on the left side and not below, where they are supposed to be.

Anchoring to paragraph make things still worse.

Searching the net, the proposed answer to this problem was "anchor as 
character" + center.

What is the trick to center ONLY the image, but not the entire text?

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] Error in Libre Office Calc for Windows

[V Stuart Foote]

Opened BZ tdf#161304, to eliminate the ~C accelerator conflict with the 
Cut shortcut.


https://bugs.documentfoundation.org/show_bug.cgi?id=161304

--
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] Error in Libre Office Calc for Windows

[Regina Henschel]

Hi Ian,

OLIPHANT IAN schrieb am 28.05.2024 um 11:46:

To whom it may concern.
  
I wish to report an error in Libre Office Calc. I do not have a Bugzilla account nor do I have any intention of creating one.
  
The error is minor but inconvenient for me as I use the function quite a lot.
  
If I wish to delete a column in Libre Office Calc I select the column and right-click. I get presented with an options menu including keyboard shortcuts with the letter underlined.
  
The underlined letter for Delete Columns is the letter C. This is the same as the underlined letter for Cut.


You can use the shortcut Strg+X for "Cut" without menü.

If you press C a second time in the menu, the selection goes to "Delete".

Underline letters depend on language. Which flavor of English do you use?

Kind regards,
Regina


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

[libreoffice-users] Error in Libre Office Calc for Windows

[OLIPHANT IAN]

To whom it may concern.
 
I wish to report an error in Libre Office Calc. I do not have a Bugzilla 
account nor do I have any intention of creating one.
 
The error is minor but inconvenient for me as I use the function quite a lot.
 
If I wish to delete a column in Libre Office Calc I select the column and 
right-click. I get presented with an options menu including keyboard shortcuts 
with the letter underlined.
 
The underlined letter for Delete Columns is the letter C. This is the same as 
the underlined letter for Cut.
 
In a previous version of Libre Office, the Delete Columns shortcut was the 
letter D. It is D for Delete Rows
 
You may like to investigate this.
 
Regards
 
Ian Oliphant
-- 
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