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

[Uwe Brauer]

Hi

I frequently mark a region of cells then click on the border menu and
select the option to add borders to all cell.

Since I don't like to click on menus I tried to bind «overwrite borders»
to a key Crt-F11.

Indeed when I go with the mouse of the menus a small window pops up
telling 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 weapons to Ukraine's military. 
I support the EU and NATO membership of Ukraine. 



-- 
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] Scalc I cannot merge cells, also I selected and unprotected them

[Uwe Brauer]

Hi 

I have a document with several sheets, I selected some cells on a row,
made sure they are unprotected, and then selected the merge option,
however that option remained in grey and could not been selected.

What is the problem here?

In a new scalc document I have no problem to merge cells, 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 of Ukraine.
I support the EU membership of Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/


-- 
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] split a huge table in subtables (say on different sheets) and link some columns between these tables???

[Uwe Brauer]

>>> "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 "Smith" values in each of your
> smaller tables.

> Assuming "Name" of table1 is in A1, "Smith" of final is in A2, and
> there are 20 rows in table1, using SUMIF for the ResSh1 in final would
> bring:

> =SUMIF(table1.$a$1:$a:20,CONCATENATE("=",final.a2),table1.$g$1:$g$20)


I think I will try this out now. Do you mean my table1
the name of the sheet, so to distribute the various tables in different
sheet our does there exits a table name (and I don't know where to find
it.) So that I could have 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 +0200, Uwe Brauer a écrit :
>> Hi
>> 
>> I am facing the following problem, I work with a table with 6 rows
>> but
>> 56 columns. Of course I can hide some columns but I find this not
>> very
>> comfortable.
>> So the question is can I split this table say in 8 tales, each with 7
>> columns.
>> 
>> In each table the last column gives me a result of certain operation,
>> say 
>> 
>> #+begin_src 
>> #+Name: table1
>> > Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 |
>> > ---+-+-+-+-+-+|
>> > Smith |   2 |   3 |   4 |   6 |   7 | 22 |
>> #+TBLFM: $7=vsum($2..$6);f2
>> 
>> #+Name: table2
>> > Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2  |
>> > ---+-+-+-+-+-+|
>> > Smith |   1 |   3 |   5 |   8 |   9 | 26 |
>> #+TBLFM: $7=vsum($2..$6);f2
>> 
>> #+Name: final
>> > Name  | ResSh1 | ResSh2 | Total |
>> > ---+++---|
>> > smith | 22 | 26 | 48    |
>> #+TBLFM: $4=vsum($2..$3);f2
>> 
>> #+end_src 
>> 
>> 
>> So that every time I actualise any column in any table, that
>> table gets updated and the final one
>> 
>> Is this possible. It is possible in emacs org mode with its table
>> spreadsheet, however my colleagues use either LO or Excel, so it
>> would
>> be great if this were possible.
>> 
>> BTW is html mail possible/allowd on this lis?t (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 the EU membership of Ukraine. 
>> https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
>> 
>> 


-- 
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 the EU membership of Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

-- 
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] split a huge table in subtables (say on different sheets) and link some columns between these tables???

[Uwe Brauer]

>>> "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 "Smith" values in each of your
> smaller tables.

> Assuming "Name" of table1 is in A1, "Smith" of final is in A2, and
> there are 20 rows in table1, using SUMIF for the ResSh1 in final would
> bring:

> =SUMIF(table1.$a$1:$a:20,CONCATENATE("=",final.a2),table1.$g$1:$g$20)

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


Thanks very much I will have a look. That might be the most elegant
solution so far.


-- 
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 the EU membership of Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

-- 
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] split a huge table in subtables (say on different sheets) and link some columns between these tables???

[Uwe Brauer]

Hi

I am facing the following problem, I work with a table with 6 rows but
56 columns. Of course I can hide some columns but I find this not very
comfortable.
So the question is can I split this table say in 8 tales, each with 7
columns.

In each table the last column gives me a result of certain operation,
say 

#+begin_src 
#+Name: table1
| Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 |
|---+-+-+-+-+-+|
| Smith |   2 |   3 |   4 |   6 |   7 | 22 |
#+TBLFM: $7=vsum($2..$6);f2

#+Name: table2
| Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2  |
|---+-+-+-+-+-+|
| Smith |   1 |   3 |   5 |   8 |   9 | 26 |
#+TBLFM: $7=vsum($2..$6);f2

#+Name: final
| Name  | ResSh1 | ResSh2 | Total |
|---+++---|
| smith | 22 | 26 | 48|
#+TBLFM: $4=vsum($2..$3);f2

#+end_src 


So that every time I actualise any column in any table, that
table gets updated and the final one

Is this possible. It is possible in emacs org mode with its table
spreadsheet, however my colleagues use either LO or Excel, so it would
be great if this were possible.

BTW is html mail possible/allowd on this lis?t (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 the EU membership of Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/


-- 
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 generate a re-scaled column

[Uwe Brauer]

>>> "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 (so you can teach me something) and I will provide what I
> think can be a solution to your problem. Let me start with what I do
> not understand.

> Where you have B1/max(A2:A7), I actually expected it to be A2:A8, but

You are absolutely right! I was so distracted (and annoyed that out of
the sudden the entries in the max function changed (you explained below
why this is so), that I did not pay attention to the other changes that orrur

So the behavior I wanted to report should be like this 


| A | B  |
|---+|
| 7 | =A1/max(A1:A7) |
| 2 | =A2/max(A2:A8) |
| 3 | =A3/max(A3:A9) |
| 4 ||
| 5 ||
| 6 ||
| 1 ||


While I wanted 

| A | B  |
|---+|
| 7 | =A1/max(A1:A7) |
| 2 | =A2/max(A1:A7) |
| 3 | =A3/max(A1:A7) |
| 4 ||
| 5 ||
| 6 ||
| 1 ||

Now you already gave me the answer, using $. I tried this before sending
the question, but not with the correct syntax!

So the correct way of doing this, is:

| A | B|
|---+--|
| 7 | =A1/max(A$1:A$7) |
| 2 | =A2/max(A$1:A$7) |
| 3 | =A3/max(A$1:A$7) |
| 4 |  |
| 5 |  |
| 6 |  |
| 1 |  |

So I learned something very important thank you again.

Now to the «dragged a formula» 
this is basically the same as you do via copying and pasting.

So if I go back to my original question:

| A | B  |
|---+|
| 7 | =A1/max(A1:A7) |
| 2 ||
| 3 ||
| 4 ||
| 5 ||
| 6 ||
| 1 ||

So I have just defined a formula in one cell. Instead of copying and
pasting, I take the mouse at the right lower corner 
=A1/max(A1:A7)
 ^(mouse)

And drag it down obtaining 

| A | B   |
|---+-|
| 7 | =A1/max(A1:A7)  |
| 2 | =A2/max(A2:A8)  |
| 3 | =A3/max(A3:A9)  |
| 4 | =A4/max(A4:A10) |
| 5 | =A5/max(A5:A11) |
| 6 | =A6/max(A6:A12) |
| 1 | =A7/max(A7:A13) |




> I have never actually "dragged a formula" so some of what I am about
> to say could be wrong. Also, perhaps you can tell me how to "drag with
> the mouse". My best guess is that either (1) there is a feature I do
> not know or (2) you are doing some kind of selection while entering a
> formula (which I know can be done but again, somthing I do not usually
> do). I usually drag with a mouse when I am simply selecting cells, but
> I am unser how to drag a formula. Then again, I also do not remember
> how to do array formulas (I think that is what they call them) even if
> I did play with them once some years back.

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 weapons to Ukraine's military. 
I support the NATO membership of the Ukraine.
I support the EU membership of the Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

-- 
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 generate a re-scaled column

[Uwe Brauer]

Hi

I have the following simple table

| Marks | Scaled  |
|---+|
| 1 ||
| 2 ||
| 3 ||
| 4 ||
| 5 ||
| 6 ||
| 7 ||


In the column scaled I want each value from column Marks, divided by the
maximum of column marks which is 7.


So I thought 

| Marks | Scaled |
|---+|
| 1 | =A1/max(A1:A7) |
| 2 ||
| 3 ||
| 4 ||
| 5 ||
| 6 ||
| 7 ||

That gives the correct entry for B1, however if now, drag with the mouse
down that formula I obtain 

| Marks | Scaled |
|---+|
| 7 | =A1/max(A1:A7) |
| 2 | =B1/max(A2:A7) |
| 3 ||
| 4 ||
| 5 ||
| 6 ||
| 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 weapons to Ukraine's military. 
I support the NATO membership of the Ukraine.
I support the EU membership of the Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/


-- 
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] for a given odt, insert new text always in red (corrections)

[Uwe Brauer]

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 problem with this approach, is if I
want to delete something. I understand that according to the logic of
recorded changes, a deletion must be displayed.

However in my workflow, I would like just silently delete text. I can
set deleted text to a white font, but then a gap in the text would
appear.

There seems no simple way to avoid this.

Regards

Uwe 

-- 
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] for a given odt, insert new text always in red (corrections)

[Uwe Brauer]

Hi

In an already existing odt document I would like to add some text,
however that text should always appear in red (say for corrections).

When I switch to a red font, and set the cursor to a new line, I again
have to activate red.

How can I configure libreoffice so that only new texts 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...@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] scalc: (auto) wrap all cells per default

[Uwe Brauer]

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.
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...@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 formula are displayed as ###

[Uwe Brauer]

Hi

Using LO 7.2, in scalc I selected

Tools-->Options-->Scalc-->View--Display_Formulas

Which I activated

However then the formula in that colum are displayed as ### (before turning 
this option on, the result was displayed)

Is this a BUG or a feature.

If it is a feature I fail to 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+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 headless import cannot deal with utf8 csv files

[Uwe Brauer]

Hi

This looks like an absurd issue.
I am on Ubuntu 16.04 using LO 7.2

I start with a csv file that contains is saved as UTF8.

I convert it to ods via the command line 

/opt/libreoffice7.2/program/soffice --headless --convert-to ods --outdir . 
test1-utf8.csv

The resulting ods file has 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 

-- 
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...@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] Subject: LO does not run on Ubuntu 16.04

[Uwe Brauer]

Hi 

I am still on Ubuntu 16.04. 
After the installation of LO, 
/opt/libreoffice7.2/program/swriter 

I obtain 
opt/libreoffice7.2/program/soffice.bin: symbol lookup error: 
/opt/libreoffice7.2/program/libvclplug_gtk3lo.so: undefined symbol: 
gtk_widget_path_iter_set_object_name


I tried 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+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] online conversion docx to odt, headless or not

[Uwe Brauer]

Hi

The following works
soffice --convert-to odt 
GQ_Course_guide_Applied_Statistics_and_Numerical_Methods_2020_FINAL.docx
but I have also seen 

soffice --convert-to odt 
GQ_Course_guide_Applied_Statistics_and_Numerical_Methods_2020_FINAL.docx 
--headless

It seems to generate the same file, 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://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Uwe Brauer]

>>> "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
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] version control of sorts: it is gone?

[Uwe Brauer]

Hi

I swear I have seen a  version control of sorts[1], maybe back in the old
days of openoffice. You could manually set versions which tend increased
the size of the file quite a bit because new versions were saved on top
of old ones.

I cannot find this feature anymore. Is it gone?

Regards

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

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

[Uwe Brauer]

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

Yes if you only work with odt documents. But if you force to deal with
docx and you run into problems, that feature might be useful.

-- 
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: Reveal code, old macros convert them to LO

[Uwe Brauer]

>>> "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 delineate format changes. That is,
> there are no format codes to reveal in ODF documents. Any program that
> pretended  to show some kind of "format code" would be hopelessly
> misleading.

If I remember correctly sxw was a lot like odt, styles included, the
changes between both was mostly name conventions of the tags etc, but I
am not completely sure. 

But right wordperfect has a different approach then OO or even word, but
may that reveal code feature could work for those documents which take
more a visual approach and don't rely much on styles.


BTW I just remembered there is a app called cross eyes for Word 2011,
which has some reveal functionality and Word 2011 used already xml based
file formats.

-- 
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: Reveal code, old macros convert them to LO

[Uwe Brauer]

>>> "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 word perfect.

Right, you have to select a paragraph and then the formatting code was
revealed, but it was by no means updated when you wrote, or something
like this.

I still consider it as very useful (I know one of the macros had a
result which looked closer to WP than the others, but I don't remember which
of the 3 macros it was)

-- 
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: Reveal code, old macros convert them to LO

[Uwe Brauer]

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

https://web.archive.org/web/20180326030224/http://homepages.paradise.net.nz/hillview/OOo/

I finally made some progress using LO 5 (in 6 it seems I was not
successful).

However when executing any of these macros, I recveived a macro language
error, but I really don't now the language so I can't really tell much.

 
> If you can't make it work, remind me next week and I can take a look.


-- 
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] Reveal code, old macros convert them to LO

[Uwe Brauer]

Hi 

>From time to time the question pops up whether LO could support
Wordperfects reveal code. The developer are not too keen, and sometimes
it is stated that this feature could be implemented by a
macro/extension.

Now I remember that long time ago such macros existed and using the
wayback 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+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: MS word doc with tables: spell check does not work

[Uwe Brauer]

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

   > You could try on the menu Tools > Language > For All Text > Spanish.
   > If Spanish isn't already listed there select More and then, under the
   > "Default Languages for Documents" section of the options dialog which
   > appears, select Spanish and check "For the current document only".

   > Check that the Spanish dictionary is definitely installed correctly.
   > In the dropdown box where you select the language, there should be a
   > tick with "ABC" alongside "Spanish".

   > If that still doesn't work, it might be worth saving the document in
   > ODT format, close and then open the ODT version. I don't think that's
   > likely to make any difference, but you may as well try if nothing else
   > helps.

   > If none of that helps, perhaps someone else here with more experience
   > of working in different languages might have some ideas...

Nothing helped, thanks.

 I presume it is something wired with the fields in the table, the way
there were generated by MS Word

-- 
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] MS word doc with tables: spell check does not work

[Uwe Brauer]

Hi 

I am running Ubuntu 16.04 and either libreoffice 5 as shipped by Ubuntu
or libreoffice 6, installed by myself. The problem is the same in both
versions. I have installed in both version the relevant dictionaries,
spanish/english/german.

And in both I can run the spell checker on a new odt document.

However I am facing the following problem:


I open a MS doc document, which contains a large table which I have to
fill in. I type a word in spanish, mark it, and press F7 for spell
checking. The word is ignored since no dictionary is chosen. 

1. So I try to set spanish myself, 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: 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: scalc: =MAX(SUM(F12:I12),1)

[Uwe Brauer]

   > 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+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] scalc: =MAX(SUM(F12:I12),1)

[Uwe Brauer]

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...@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] LO and matlab live script mlx

[Uwe Brauer]

Hi

I just learned about matlab live script

https://es.mathworks.com/help/matlab/matlab_prog/live-script-file-format.html

Which uses Office Open XML (ECMA-376) format. So in principle LO 
should open it, as it open docx files, but it fails.


Did anybody try that out. If needed I can provide 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://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

>>> "Tom" == Tom Davies <tomc...@gmail.com> writes:

   > Hi :)
   > Does .xlsx work well enough now?
Yes and no.

That is after some trouble I found out that I convert cvs with . For
decimals to xlsx which are read correctly by LO and Excel.

However there is an issue.

When I convert csv (and you might ask why I use them, for simple tables
I use emacs org mode (with a poor man spreadsheet, which exports to
csv).

Then I convert it either opening the file with LO and exporting to xlsx
or on the command line with gnumeric

ssconvert example.csv example.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.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

>>> "Philip" == Philip Jackson <philip.jack...@nordnet.fr> writes:

Hi Philip

   > Hi Uwe,

   > Regardless of the version of calc you are using, you can change the
   > decimal indicator.  In the spreadsheet, select the cells concerned and
   > then  Format > 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 


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

   > Hello,
   > I exchange ODS and XLS files between the French Canadian (decimal
   > separator « , ») and English US/Canada locales (decimal separator « .
   > ») without issues. When the number is already in a cell on a worksheet,
   > the application will use the locale to display a decimal number in the
   > correct way.

   > However, you cannot transfer files in text format (such as CSV)
   > directly from one to the other because the formatting of the decimal
   > numbers will conform to the current locale when the file is created: if
   > I import a CSV file created from the "English" version, afer the import
   > I must do a global replace of « . » to « , » to make numbers become
   > numbers again. Also, when going the other way, the CSV separator is
   > usually a « ; » to allow decimal numbers to contain a comma as decimal
   > separator, which is something Excel does not always handle very well.


Ok maybe I mixed CSV with excel files and that is where my confusion
starts. You are right the xlsx format seems pretty save.


   > So far, the best way I found is to save as XLS (or XLSX) from LO (Excel
   > considers ODS files as "broken" and does not preserve formulas), do the
   > changes in Excel, then open the XLS file in LO and save in ODS. Just
   > remember here that some page and cell formatting may be lost in the
   > exchange, so do not attempt anything fancy on that front :-).

Still the excel files, when opened in excel contain cells with small
green edges, which according to the documentation is a indication of
possible format violation.


   > If you use formulas that format numbers (=TEXT()), you will need to
   > have some intelligence to use the proper separator when encoding the
   > number format (more so for Excel than for LO). What I usually do is
   > have a cell that I name SEP that contains a formula like this:

   > =IF(ISNUM("3.4");".";",")

   > Then when I need to format a value with the =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 non-
   > English locale, it becomes =TEXT(value;"0,0")

   > I hope this helps.

Thanks it does, will try to avoid to use the TEXT function, though.

Uwe Brauer 


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

Hi

I am using the english version of LO 5.3 and therefore I use the «.» to
indicate decimals: 3.4

However I have to interchange the documents with my colleagues which
using the Spanish version (of excel) so I must send xlsx or xls format
anyhow.

How I can I ensure that the spanish excel 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+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

>>> "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 xlsx test.csv

Thanks I tried it out in various variations

/usr/bin/soffice --headless --infilter="Text(encoded):UTF8" --convert-to xlsx 
test.csv   

But the encoding is still broken.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

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

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

In various order but obtained 
Unknown option: --utf-8


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

Hi

I run from the command line

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

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

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

Thanks

Uwe Brauer





-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

>>> "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 input what to search,
   > input and "space" with spacebar
   > e) In the second row for input what to replace, keep without input
   > f) Apply the option Replace All
   > g) Now if all is good, you are eliminate the space after "name" field
   > h) Save the file again as csv
   > i) Now you can close the file and open again or use the option: Menu,
   > Data, Text to Column to split the fields in the column

Thanks, I did it with replace regexp using \n which also worked nicely.
I will keep in mind you suggestion for other cases, thanks
   > I hope this help,


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

>>> "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
   > 'Separator Options' set Y=Separated by, Y=Other as \n then click 'OK'.  Now
   > save as CSV.

Thanks, that works nicely. I don't know how the heck the \n entered, but
at least I know how to deal with it. thanks


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] saving as csv newline inserted

[Uwe Brauer]

Hi

I have an excel (xls) file which I open with scalc (5.3)
and save it as csv

Unfortunately it looks like

Field1,Field2,Field3,Field4,Field5
"Name","05329954A
   ",0.55,0.75,1.3

Instead of

Field1,Field2,Field3,Field4,Field5
"Name","05329954A ",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: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

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...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

Hello

I periodically receive excel files (generated by Office 2010 I think,
but saved in the old binary format).

Some of these columns cause me problems, since they seem to contain spaces
and even newlines. I could correct that manually, but since the file
contains hundred of 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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

 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 Linux Kubuntu 10.04)

If the same shortcut key is defined for both, the one for an
individual application takes priority when in that application. In
Writer, Ctrl++ is assigned to Calculate and Ctrl+- is assigned to
Optional hyphen (at least for me). If you assign those keys to zoom
in and out at the LibreOffice level, they will not have that effect
when in Writer; you'd need to remove the assignments from the Writer
level (and likewise for Calc etc. If you want them to work there too).

I know, and that is why I tried out other bindings such has Alt+F2
and it does not work neither, I googled around and found out that it/was
a long standing bug, that is zoom in and out cannot be bound to a key!

I am using LO 4.2. Did you try it out, successfully? If so which version
do you use, because I then might upgrade.


Uwe 


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

Hello

LO has a nice button down right which allows to zoom in and out using
the mouse. However I would prefer to bind zoom in to a key and zoom out
to another say Crt-+ and Crtl-- but when I go to 
Customize--View--Zoom in and bound it to say Crtl-+ nothing happens,
Customize--View--what do I 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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

 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 that I had to run the command

 apt-get install myspell-he myspell-en-us

To make it work.

Uwe 



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

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...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

Hello


I just upgraded to libre office 4.1.2.3 and opened a document which
contain hebrew with niqqud. While these niqqud are displayed correctly
in libreoffice 4.0 (and in OO 3.2 and 4.0) they are *not* displayed in
libreoffice 4.1.2.3. I also cannot enter niqqud, at least 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/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

 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 InnoDB engine in your mysql db ?


Aha, good question.

Well show engines;
showed  

InnoDB | YES | Supports transactions | YES  | YES  | YES

So I presume the answer is yes.

Otherwise, e.g. if you are using myisam or heap as the default engine,
relations are not supported by mysql, i.e. they are not enforced
(although they can be stored as a textual reference).

This is true whether you are using ODBC, JDBC or the native mysql
connector to reach your tables from within LO.
A question, can you set various relations between tables, using mysql
and they are saved?

Uwe 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

 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 to either type of keys. (This one really goes to
the error message you got. (I make these suggestions because it is
what I had to do to understand tables in a relational database.)
Yes of course, I desperately need to learn more.  But the issue is that
the GUI seems only to set and save relations between primaries keys. Did
you try it out via the GUI, what is your experience?

 I am a little curious. Your email address implies you may live in
Spain. 

Yes, I do.

Your name looks German to me. If you are German, then there is
a Base Handbook written in German that you might be able to use. 

Yes again, I am German.
Tom might be able to tell you from where to download it on the
LibreOffice wiki if that would help.
That would be extremely helpful. I googled around of course but mostly
found old material (2007/08).

 As far as MySQL problems, I think I tried to modify fields in a
table while using MySQL. They were not saved either.

Aha so there is a problem?!

Uwe 


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

 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 connect to an external database such as mysql via
   a number of drivers or

-  it uses a database it ships (I think it is based in
   hsql). Because of a lack of a word I denoted this as intrinsic.

 Primary-foreign key pairs are created when a table is
normalized. (There several levels of normalized tables.) These pairs
are based upon the relationships between the fields of the original
table.
 So, you probably should put all the fields of the two tables into
a single table with the exception of any fields that belong to both
tables. For example the single table contains only one primary key
(ID) and one field named Notes. Then look for any fields (other
than ID) that determine the values of other fields. (In other words,
begin to normalize the table.) Without knowing all of the fields that
you are using, it would be difficult to know what fields these might
be.
 FYI, very seldom will two tables have a 1:1 relationship (linking
the primary keys of the two tables). Very likely, yours doesn't
either. Most often, these relationships involve a primary key of one
table and a foreign key of the other.


I am not entirely sure I understand: I set up a new base, no the primary
keys are not any existing field of the table (autovalue is On)


My tables are the following (they are just toy models in order to
understand the relation ship concept)

Task:
Name Type
Id   (generated by OO as a primary key)
Task Id Integer
Description Memo Longchar
Notes Memo Longchar


Authors 
Name Type
Id (generated by OO as a primary key)
Author Id Integer 
FirstName Memo Longchar
Nationality Notes Memo Longchar

Now I try to make a relation between the two tables, and in the GUI I
select the field Task Id and Author id in the other table, since both
fields have the same type.

I receive  the following error:


SQL Status: 23000
Error code: -177

Integrity constraint violation - no parent 1, table: Authors in
statement [ALTER TABLE Authors ADD  FOREIGN KEY (AuthorID)
REFERENCES Tasks (ID)] 

Now the gui allow me to add more fields so I add both primary keys, gain
an error:
SQL Status: S0011
Error code: -170

Primary or unique constraint required on main table: Tasks in
statement [ALTER TABLE Authors ADD FOREIGN KEY (AuthorID,ID)
REFERENCES Tasks (TaskID,ID)]

The only one which works, using the GUI is between the primaries keys!!!

Did you try it out your self and you are able to set more relations
between the tables?

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

Uwe 



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[Uwe Brauer]

 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.

Primary or unique constraint required on main table.  Accounts
in statement [ALTER TABLE Tasks ADD FOREIGN KEY
(TaskId,Notes) REFERENCE Accounts(AccountI,Notes)]

I am puzzled, in the intrinsic database only relations between
primary keys are possible?? Is this a property of the intrinsic
database, or is it a bug? I am thinking of submitting a bug
report.


The following possibilities occur to me :

(a) you might need to drop your previously configured constraint
before you can set up a new one via the GUI. From what I recall,
this might only be possible manually, i.e. by issuing a SQL command
(menu Tools  SQL) to DROP the CONSTRAINT from the tables, then
shutting down the db file, closing LO completely and re-opening.

(b) you might not be able to set combined constraints on more than one
field in both tables simultaneously via the GUI - again you may
find that you have to do this manually (although it may actually
turn out to be a limitation of hsqldb 1.8, I haven't checked)

This is my impression. Even when I generate for the first time a
relation ship via the GUI, I can only have the primary keys, if I put
more field in the relation it fails. 

And if I just set it up for the primary keys and later edit, same
result.

I think it is time for a bug report.

Uwe 


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] how to insert enumerated comments.

[Uwe Brauer]

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 are *not* displayed (RTF or 2003 doc binary format).


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted