[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

Dan == Dan Lewis elderdanle...@gmail.com writes: ` On 02/11/2013 09:18 AM, Uwe Brauer wrote: Uwe Brauer How do you define an intrinsic database? I do not understand the term. Well in my understanding there are two possibilities, - either Base can

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

Alexander == Alexander Thurgood alex.thurg...@gmail.com writes: Le 11/02/13 15:18, Uwe Brauer a écrit : Hi Uwe, Now I want to edit the relation and I am offered the possibility to add more fields. So I select the notes file in either table but I receive the following error

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

Alex == Alex Thurgood alex.thurg...@gmail.com writes: On 02/11/2013 11:31 PM, Uwe Brauer wrote: Hi Uwe, As I said, in another mail, when I connect the data base to mysql via ODBC then I can set more relations, but they are not saved.. I take it that you are using

[libreoffice-users] Re: LO 4.0: intrinsic database: relations only between primaries keys?

Dan == Dan Lewis elderdanle...@gmail.com writes: Perhaps you need to learn more about primary keys, foreign keys, and the relationship that must exist between them. Another topic that would help is normalizing tables. Still another topic is constraints that must be applied

[libreoffice-users] libre office: 4.1.2.3 hebrew, no niqqud support anymore

they are not displayed. Is this a bug or something changed in the configuration? thanks Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

[libreoffice-users] how to insert enumerated comments.

Hello Ms word 2003 inserts comments which are automatically numbered. I cannot find a similar feature in libreoffice (3.4) nor can I find a extension which does this. Does anybody know about it? Thanks Uwe Brauer BTW when I open a word document with such comments the numbers

[libreoffice-users] Re: problems with the spell checker

Tim == Tim Lloyd tim.ll...@gmx.com writes: Hi, This list does not accept attachments. However, if you nip over to the nabble interface: Http://nabble.documentfoundation.org/Users-f1639498.html That does accept attachments so you can post there. Thanks, meanwhile I found out

[libreoffice-users] insert empty (check) box: bound to a key

Hello I insert a check box, by using insert-symbol and then I select the symbol in question. Can I bind this to a key, say shift+insert inserts already the check box. I presume I have to write a macro? Thanks Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] zoom in and out bound to a key

miss? thanks Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org

[libreoffice-users] Re: zoom in and out bound to a key

Mark == Mark Bourne libreoffice-ml.mbou...@spamgourmet.com writes: A couple of possibilities... Thanks for your answer. 1. Your operating system might do something with those shortcut keys, and not pass them on to LibreOffice. Other shortcut keys I have set work fine (I am on

[libreoffice-users] problem with import of excel file, cells contain new lines

this is cumbersome. So the question is whether there exist any formating function which could resolve the issue. I attach an (shorted) example of the problem and would appreciate any help. Regards Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

[libreoffice-users] writer: display changes, only from a given date

Hi I have record changes and display changes activated (libreoffice 4 or 5 in Kubuntu). But in that case, all modifications are displayed. Is there a way just to display the changes say of today? Thanks and regards Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: scalc interchange ods between english and spanish

xample.xlsx What does not work, is the command line converter of LO, /usr/bin/soffice --headless --convert-to xlsx test.csv the decimals are fine but the non ascii chars are encoded incorrectly. See my message sent some weeks ago. Regards Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr...@global

[libreoffice-users] saving as csv newline inserted

29954A ",0.55,0.75,1.3 The reason is that in the first column there is a after name a space which is translated to a newline when exporting. How can I get rid of this unwanted newline? I tried to format the cells but it seemed not to have worked. Thanks Uwe Brauer -- To unsubscribe e-mail to:

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

is the mini csv , | | Apellido,Nombre,DNI,Gr | Díaz ,Pepe,123456,F ` Thanks Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

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

>>> "Michael" == Michael D Setzer writes: > In the help it list options for infilter and filter options for > convert-to. Don't know if you would need one or both, and it does > list UTF8, but don't think the help shows all options. Thanks I tried

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

>>> "Michael" == Michael D Setzer writes: > The help shows no --utf-8 option, it is a filter not an option? > I think this is what it would look like? Not sure of the LF,,, part of it? > /usr/bin/soffice --headless --infilter=Text (encoded):UTF8,LF,,,--convert-to

[libreoffice-users] Re: saving as csv newline inserted

>>> "jorge" == jorge writes: > Hi Uwe and all: >I suggest: > a) Open the file as is: csv > b) Mark the column that content all the information > c) Use: Menu, Edit, Search and Replace ... click there > d) In the window opened: In the first row for

[libreoffice-users] Re: saving as csv newline inserted

>>> "Bruce" == Bruce Hohl writes: > It appears that the actual contents of Field2 = 05329954A\n where '\n' is a > RETURN (not a TAB). I was able to remove the \n by (1) select/highlight > the column containing Field2, (2) open Data > Text to Columns, (3) Under >

[libreoffice-users] Re: scalc interchange ods between english and spanish

TEXT() function, I use it > this way to have a number with one decimal digit: > =TEXT(value;"0"&"0") or, if you prefer, > =TEXT(value;CONCATENATE("0";SEP;"0")) > In English locales, this translates to: =TEXT(value;"0.0"); in the

[libreoffice-users] Re: scalc interchange ods between english and spanish

> Cells > Numbers and select Language to Spanish (Spain) > and your numbers will go from 3.4 to 3,4 I tried that but I am not entirely sure it worked flawlessly. It seems however that the xlsx format (at least for simple spreadsheets) translate well the different formats. Uwe Brauer

[libreoffice-users] scalc interchange ods between english and spanish

version of my colleagues interpret 3.4 as a number, since in Spanish the convention is either 3,4 or 3'4?. I hoped that could be internally solved without any specification but it seems not to be the case. Any suggestion would be welcome. Thanks Uwe Brauer -- To unsubscribe e-mail to: users

[libreoffice-users] LO and matlab live script mlx

an example file. Thanks Uwe Brauer -- 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

[libreoffice-users] MS word doc with tables: spell check does not work

, but this is impossible. 2. I mark the whole document--> select right mouse--> select char--> select font--> select spanish. No effect. I am really puzzled, I googled and did not find any answer. Any help would be appreciated. Uwe Brauer -- To unsubscribe e-mail to: us

[libreoffice-users] Re: MS word doc with tables: spell check does not work

>>> "libreoffice-ml" == libreoffice-ml mbourne >>> writes: > Uwe Brauer wrote: > I assume the word you're typing is spelled incorrectly? Of course the > spell checker will skip over it if spelled correctly in the selected > language. >

[libreoffice-users] Re: scalc: =MAX(SUM(F12:I12),1)

> At 18:22 04/07/2018 +0200, Uwe Brauer wrote: > Just that you need =MIN(SUM(F12:I12),1) instead? Yes, of course, thanks, I don't know where my head was when I wrote this, sorry for the noise and thanks for your help. -- To unsubscribe e-mail to: users+un

[libreoffice-users] scalc: =MAX(SUM(F12:I12),1)

Hi I want to have a column in which each value is either the sum of previous columns or if the sum exceed the value of 1, it is subsituted by 1. So I tried =MAX(SUM(F12:I12),1) But it does not work. What do I miss? Thanks Uwe Brauer -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Reveal code, old macros convert them to LO

>>> "AP" == Andrew Pitonyak writes: > just so we're clear, the macro functionality was not even close to the > functionality in word perfect. all the macro did, was displaying a > dialogue all of the codes. There is certainly a lot of use for this, > but nothing near what you do automatically in

[libreoffice-users] Re: Reveal code, old macros convert them to LO

>>> "AP" == Andrew Pitonyak writes: > I don't think it was that much code. I might even have a working copy > from a few years back, but won't have computer access until next week. > Might have deleted it. Here is what I found.

[libreoffice-users] Re: Reveal code, old macros convert them to LO

>>> "j" == jomali writes: > I don't remember the details of the sxw format. Perhaps reveal codes were > appropriate then. However, ODF files have a complex SGML or HTML or XML > type format, along with a form of CSS, unlike WordPerfect and similar > programs, which used embedded code to

[libreoffice-users] Re: Reveal code, old macros convert them to LO

> Den tors 4 juli 2019 kl 18:16 skrev John : > If you use styles the way it's intended, you won't have those problems in > the first place. I have never had them (as far as I remember), even when I > was not using styles properly. Direct formatting should generally be > avoided, if you ask me.

[libreoffice-users] Reveal code, old macros convert them to LO

ack machine I found them. They were written around 2005 for OO 1.2, using the sxw format. I tried them out in LO 6.2 and they don't work. Is there somebody with enough knownledge in macros to translate those macros to LO 6.2? Thanks and regards Uwe Brauer -- To unsubscribe e-mail to: users+unsub

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

Uwe Brauer Footnotes: [1] or sort of version control if you prefer. -- 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

[libreoffice-users] online conversion docx to odt, headless or not

, what is the difference? Thanks Uwe Brauer -- 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

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

>>> "AB" == Alan B writes: > Hello Uwe, > I'm using LibreOffice version 6.0.7.3. > "Version..." is the ninth item on the "File" menu. Ah thanks but it is only for odt format, not for docx. Which makes sense Uwe -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Subject: LO does not run on Ubuntu 16.04

to follow the advice found in https://ask.libreoffice.org/t/installed-libreoffice-7-1-on-ubuntu-16-04-lts-it-does-not-start-and-i-get-the-following-error/61992/3 But it does not work Any help would be appreciated or a link to older LO. Regards Uwe Brauer -- To unsubscribe e-mail to: users

[libreoffice-users] Scalc I cannot merge cells, also I selected and unprotected them

, so what could be the reason? Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Hamas terroristic attack on Israel. I strongly condemn Putin's war of aggression against Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership

[libreoffice-users] how to generate a re-scaled column

|| | 1 || Which is not what I want. That is a very elementary question, but google does not help me. regards Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver

[libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

(that would simplify the display of my tables) Thanks and regards Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of Ukraine. I support

Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

>>> "RG" == Remy Gauthier writes: > Hi, > You can use the SUMIF function to have the ResSh1 and ResSh2 of final > to be updated each time you make an entry. If you only have one "Smith" > per table, you can use VLOOKUP to fetch the $7 value for Smith. You > will use these functions to find the

Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

different tables on the same sheet? > For ResSh2, you will replace table1 with table2. > If you want to use VLOOKUP, then you will have, for final.ResSh1: > =VLOOKUP(final.a2,table1.$a$1:$g$20,7,FALSE()) > I hope this helps. > Rémy. > Le mardi 03 octobre 2023 à 18:44 +02

Re: [libreoffice-users] how to generate a re-scaled column

>>> "AP" == Andrew Pitonyak writes: Hi Thanks very much for your answer, it helped me a lot, but let me reply to your points below. > Uwe Brauer > Your question is a good one.  > Either I misunderstand your question or you are doing something I do > not know

[libreoffice-users] libreoffice headless import cannot deal with utf8 csv files

corrupt codification. I convert the same csv file but now I open it it directly in scalc and then convert it explicitly to ods, everything is fine. I tired the same with latin1 and there is no problem. I attach the files. Any comments? Is this known, shall I send a bug report? Regards Uwe Brauer

[libreoffice-users] calc formula are displayed as ###

o see its benefits. Regards Uwe Brauer -- I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the ban of Russia from SWIFT. I support the EU membership of the Ukraine. -- To unsubscribe e-mail to: users

[libreoffice-users] scalc: (auto) wrap all cells per default

Hi Recently I receive ods files that contains cells that are very long and I have to manually activate the wrapping feature for those cells. Is it possible to enabled wrapping in all cells per default? Regards Uwe Brauer -- I strongly condemn Putin's war of aggression against the Ukraine

[libreoffice-users] for a given odt, insert new text always in red (corrections)

appears in red? Thanks and regards Uwe Brauer -- I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the ban of Russia from SWIFT. I support the EU membership of the Ukraine. -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] for a given odt, insert new text always in red (corrections)

Hi Robert > Robert Großkopf > > Hi Uwe, > > I would do it this way: > > Edit → Track Changes → Record > Edit → Track Changes → Show > Tools → Options → LibreOffice Writer → Changes → Insertions > here switch to > Attributes → [None] > Color → Red > Thanks for your answer. The only

[libreoffice-users] scalc (LO 7.2) how to bind borders overwrite

overwrite border (Crt-F11) however when I press CRT-F11 nothing happens, I again need to click on that menu. Is this a bug? Regards Uwe Brauer -- I strongly condemn Hamas heinous despicable pogroms/atrocities on Israel I strongly condemn Putin's war of aggression against Ukraine. I support to deliver