Re: [libreoffice-users] 'insert comment' on Calc not working

[Johnny Rosenberg]

Den mån 1 maj 2023 kl 15:33 skrev Eric Beversluis <
ebe...@researchintegration.org>:

> This morning on a long-existing spreadsheet, insert comment is not
> working. When I rt-click 'insert comment' the little red box shows up in
> the cell, but the balloon doesn't open. When I click on the little red
> box, it just disappears.
>
> There are quite a few comments on the spreadsheet already. So this is a
> new problem which seems to have come out of nowhere.
>
> Using Lo 7.4.6.2 on Ubuntu LTS 20.04.6 on DELL XPS.
>

This works for me, using LibreOffice 7.4.6.2 on Ubuntu Studio 20.04. Have
you tried to reset your LibreOffice profile?


Kind regards

Johnny Rosenberg


>
> --
> Eric Beversluis www.ericbeversluis.com
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://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] Insert Special Characters

[Johnny Rosenberg]

Den mån 1 maj 2023 kl 14:09 skrev Mike Flannigan :

>
> AutoHotKey might work for you, but I find it difficult.
>

I find it a bit confusing a lot of times, but for easy tasks like creating
phrases for special characters it can be straight forward. I'm not at work
now, so I don't have Windows and AutoHotKey available, but for instance for
a π character, a line like this would do the trick:
:*:.pi::π
So when loaded this, ”.pi” will be replaced with ”π” as soon as the ”i” in
”.pi” is entered.

In AutoKey script is done in Python, but phrases can be made directly. Just
enter the ”π” in the big text field and select ”Clipboard (Ctrl+V)” in
”Paste using” (for characters that are not on the keyboard by default).
To do the same thing with a simple Python script, try this:
keyboard.send_keys("π")



Kind regards

Johnny Rosenberg

You might find a clipboard manager easier to us.
> I use CopyQ on Linux.  Copy, and then pin it to the list.
>
>
>
> Mike
>
>
> On 5/1/23 05:27, users+h...@global.libreoffice.org wrote:
> > Subject:
> > Re: [libreoffice-users] Insert Special Characters
> > From:
> > Jonathan Allen 
> > Date:
> > 5/1/23, 01:52
> >
> > To:
> > Johnny Rosenberg 
> > CC:
> > users@global.libreoffice.org
> >
> >
> > Johnny,
> >
> >> Another option would be to use something like AutoKey (on Linux) or
> >> AutoHotKey (on Windows) to type those characters for you, or if you use
> >> Linux you can just use the Compose key (a lot of information about that
> >> online).
> > Thank you - I will check that out.  It sounds useful.
> >
> > Jonathan
>
>
> --
> 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] 'insert comment' on Calc not working

[Eric Beversluis]

This morning on a long-existing spreadsheet, insert comment is not 
working. When I rt-click 'insert comment' the little red box shows up in 
the cell, but the balloon doesn't open. When I click on the little red 
box, it just disappears.


There are quite a few comments on the spreadsheet already. So this is a 
new problem which seems to have come out of nowhere.


Using Lo 7.4.6.2 on Ubuntu LTS 20.04.6 on DELL XPS.

--
Eric Beversluis www.ericbeversluis.com

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

Re: [libreoffice-users] Insert Special Characters

[Mike Flannigan]

AutoHotKey might work for you, but I find it difficult.
You might find a clipboard manager easier to us.
I use CopyQ on Linux.  Copy, and then pin it to the list.



Mike


On 5/1/23 05:27, users+h...@global.libreoffice.org wrote:

Subject:
Re: [libreoffice-users] Insert Special Characters
From:
Jonathan Allen 
Date:
5/1/23, 01:52

To:
Johnny Rosenberg 
CC:
users@global.libreoffice.org


Johnny,


Another option would be to use something like AutoKey (on Linux) or
AutoHotKey (on Windows) to type those characters for you, or if you use
Linux you can just use the Compose key (a lot of information about that
online).

Thank you - I will check that out.  It sounds useful.

Jonathan



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

Fwd: [libreoffice-users] Importing a row from a spreadsheet

[Ian Graham]

And as if to suggest there may be some sort of mismatch interference
going on, I now find the same mistake about 'reply' as before has recurred.

Sorry again, Alan.

 Forwarded Message 
Subject:Re: [libreoffice-users] Importing a row from a spreadsheet
Date:   Mon, 1 May 2023 10:25:23 +0100
From:   Ian Graham 
To: Alan B 



Good morning, Alan and group

Thank you for your continuing interest in this, Alan.

What you describe is what I first attempted, on the basis of using
LibreOffice for many years. However, my original outcome was not as you
described, which is what set me off searching further.

I have now tried again done what you have said, twice, first inserting
the cursor in the first LH cell of the Writer table, and secondly
selecting the whole row. Both times if I simply 'Paste', what I get
seems to be a graphic ie image of the selected part of the spreadsheet,
with no obvious relation to the created table, and no editable capacity.

I am in Trisquel, which is a somewhat ipsative version of Gnu Linux, and
I'm now wondering if that may have something to do with the responses
I'm getting.

And just for the avoidance of doubt, I have found a work-round I can
live with, as I noted in an earlier post.

Sincerely

Ian G.


On 30/04/2023 19:56, Alan B wrote:
> Ian, if you reply, please reply to users@global.libreoffice.org, not
> my email. Thank you.
>
> I created a twelve (12) column spreadsheet, A to L, with two rows in
> Calc, then selected A1:L2, then copied and pasted it into Write.
>
> That had the same result as you described, columns disappearing off
> the right of the page.
>
> HOWEVER, when I created an empty one (1) row, twelve (12) column table
> in Write FIRST and then pasted the Calc selection into it (cursor at
> R1, C1 of table in Write) both rows were pasted into the table and the
> table did not expand beyond the margins of the page.
>
> If you haven't tried creating a blank, one row table in Write, with
> the same number of columns as your source spreadsheet, give that a shot.
>
> Create the table in Write. Only need one row but need the same number
> of columns as in your source spreadsheet.
>
> Then, copy the rows and columns in the spreadsheet.
>
> And finally paste into R1, C1 in the Write table.
>
> See if that produces the result you're looking for.
>
> Also, if you wish to have an individual one row table in Write for
> each item in the catalog, proceed with the copy/paste as described
> above. The resulting table in Write will have one row for each row
> pasted from Calc.
>
> To separate the rows in Write, put your cursor in any row, then select
> Table>Split Table... from the menu. Select the "No heading" option and
> click "OK" button. Repeat as many times as you need to break the table
> into individual rows.
>
>
>
>
> On Wed, Apr 26, 2023 at 6:48 AM Ian Graham 
> wrote:
>
> Good morning from Wales, UK
>
>
> I am a member of a local Heritage Society which some years ago
> created a
> digital archive of several hundred photographs.
>
> The archive is indexed in an Excel-type document, which was
> possibly not
> very skilfully formated at the time. The index comprises 12 columns,
> A>L, in an A4 Landscape layout, but the actual document seems to
> extend
> rightwards almost to infinity.
>
> I would now like to create new individual ‘slides’, probably as pdfs,
> uniting each image with the information about it. But I have not yet
> worked out the best method by which to import the information from the
> *.ods.
>
>
> One difficulty is that a ‘copy’ of a row from the dbase does not paste
> neatly into a new document – it always seems to spill out to the
> right.
>
> The other difficulty is choosing the best method of pasting. I have
> tried all the ‘paste special’ options, and none of them seem to
> offer a
> one-stop-shop route of import.
>
>
> I have tried, for instance, creating a new table of 12 equal columns
> that fits on my new page, with the idea of pasting into it, and then
> sorting out the spacings, but I have not yet even found a way of
> so pasting.
>
> The best method I have come up with so far is simply pasting the
> copied
> row as unformated text, and then manually inserting the various
> elements
> into the appropriate cell of a new table; which achieves the desired
> result in the end, but is going to be cumbersome over several hundred
> photos.
>
> Any suggestions as to the most efficient way to proceed will be
> greatly
> appreciated.
>
> Sincerely
>
> Ian Graham
>
> -- 
> 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
> 

Re: [libreoffice-users] Importing a row from a spreadsheet

[Ian Graham]

I'm sorry, Alan. I'm not sure how that happened - I thought I clicked on
reply to the original group email in the usual way, and it was only
after it went, that I realised it had gone to your private address, and
I reposted to the group.

On 30/04/2023 19:56, Alan B wrote:
> Ian, if you reply, please reply to users@global.libreoffice.org, not
> my email. Thank you.
>
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Insert Special Characters

[Brad Rogers]

On Sun, 30 Apr 2023 17:14:34 +
"W. Robert J. Funnell, Prof."  wrote:

Hello Prof.,

> you click on Cancel to exit from the dialogue.

Clicking cancel should, in my opinion, undo the insertions made and
exit.  OTOH, the only other option is insert, which enters the last
character again.

Neither option, or their results, are optimal in this use case.

-- 
 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?"
Black man got a lot of problems, but he don't mind throwing a brick
White Riot - The Clash

-- 
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] Insert Special Characters

[Jonathan Allen]

Johnny,

> Another option would be to use something like AutoKey (on Linux) or
> AutoHotKey (on Windows) to type those characters for you, or if you use
> Linux you can just use the Compose key (a lot of information about that
> online).

Thank you - I will check that out.  It sounds useful.

Jonathan

-- 
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] Insert Special Characters

[Jonathan Allen]

Dear Robert,

> When you double-click, the character is inserted immediately and
> you stay in the Special Characters dialogue, so you can then just
> double-click the next character(s).

Ah, I had missed that completely.  Thank you.  That does make it
almost sane again.

> When you're done, you click on Cancel to exit from the dialogue.
> At least that's what's happening for me in LO 7.3.2.2.

That makes sense now you describe it in full.

Jonathan

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