I guess it depends on your theme, but at least for me, the active cell is
the one that is surrounded by a fat blue frame. I'm not sure how it could
be any clearer than that. Also the column and row headers have a blue
background instead of grey.
Kind regards
Johnny Rosenberg
Den ons 8 maj 2024
Den tors 28 sep. 2023 kl 21:53 skrev MR ZenWiz :
> I updated all my LO installs to use 7.6.2 and verified my links and
> Thunar "open with"s to ensure they go to the 7.6 install.
>
> However, they all show 7.5.5.2 when I click -> About.
>
> What's going on here?
>
What operating system?
What
ons like ADDRESS() and INDIRECT().
If you input a number higher than the last sheet number you will have an
exception, an error. Of course it's possible to get around that too, for
instance by first counting sheets (I think the total count is already
available, so
'm probably the wrong person to ask.
By the way, this question has been asked thousands of times here (I have no
idea why), so searching the archives would probably get you the answer you
need.
Kind regards
Johnny Rosenberg
>
> Thank you.
>
> --
> To unsubscribe e-mail to: user
ard.
Now log in and you'll see a listbox called ”Severity”. Among the things you
can select there is ”enhancement”.
Then don't forget to fill in all the other fields and boxes you find there.
Kind regards
Johnny Rosenberg
>
> I recently came across UI features in Calc that are inconvenie
Den fre 4 aug. 2023 kl 12:21 skrev :
>
>
> Sent: Thursday, August 03, 2023 at 4:45 PM
> From: "Johnny Rosenberg"
> Subject: Re: [libreoffice-users] Odd "soffice --convert-to xlsx" behaviour
> when called from shell script
>
> If I do:
>
>
ave been put into the conversation features since then.
Your version was released 2017-12-23. That's almost six years ago.
Kind regards
Johnny Rosenberg
LibreOffice 7.4.7.2
>
> * Actually, I lie. It takes a long time - way longer than it took to
> generate the xslx from the comman
Den tors 3 aug. 2023 kl 00:33 skrev Brooks, Bruce :
> I have recently purchased a new computer with the latest and greatest
> Windows 11 operating system. My old computer ran windows 11 and the
> LibreOffice path was C:\Users\Bruce's
> Lenovo5\OneDrive\Documents\Joanne\Goals for reading the
a macro call)?
>
No macro needed. Just select a cell and hit F2 and then use the arrow keys
to move the cursor within the cell. Then look at your font toolbar.
Whatever you see there is the format for the character to the immediate
left of the cursor.
Kind regards
Johnny Rosenberg
>
>
went back to Apache OpenOffice for
a year or two and then to LibreOffice again and stayed since version 4 or
something) and the font selection tools never moved or disappeared and they
are still there in LibreOffice 7.4.7.2, so I'm not sure what you are
talking about here.
Kind regards
Johnny Rosenberg
&
n draw a box around
> the line to then erase it?
>
Well, drawing something above the line will hide the line, not erase it,
but if that's good enough, then yes, kind of.
Kind regards
Johnny Rosenberg
> Thank you.
>
> --
> To unsubscribe e-mail to: users+unsubs
1 cell but has a date format
> () that is only supposed to display the month.
>
maj
Yes, it looks right (my locale is Swedish – Sweden).
LibreOffice 7.4.6.2
Kind regards
Johnny Rosenberg
>
> I uploaded a sample file to:
> https://www.mediafire.com/file/mjky6h3u
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.libreoff
n 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 t
udied German at school about 35 years ago, and I still remember some of
it, just a little.
Kind regards
Johnny Rosenberg
>
> Mit freundlichen Grüßen
> Helmut Leininger
>
> Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.
>
> Am 30. April 2023 19:50:15 MESZ schri
, since I need many of the
advanced features that it lacks, so I just assumed it was still maintained.
Sorry for that.
Kind regards
Johnny Rosenberg
>
>
> Mit freundlichen Grüßen
> Helmut Leininger
>
> Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.
>
the time (AutoKey at home and AutoHotKey at work,
since my job computer unfortunately only have Windows), and I find them
extremely useful for a lot of things.
The advantage of using Autokey or AutoHotKey is that you can insert your
special characters and phrases anywhere, not only in LibreOffice.
one pointed out that LibreOffice Writer could be a bit too complex,
I think I should mention a simpler open source word processor: AbiWord.
Kind regards
Johnny Rosenberg
> I found a
> basic introductory video on YouTube, but it was posted back in 2018. I
> found another tutorial
Den tors 27 apr. 2023 kl 10:55 skrev Rose Gale :
> Hello:
>I don't know if anyone has encountered this problem, but I haven't
> been able to find the right solution. I hope I can get some helpful
> suggestions here.
>I'd like to start by stating that I can only do this in c# for a
; 01_cFILE.odt
> 01_dFILE.odt
> 001_zFILE.odt
> 01_zFILE.odt
>
>
That doesn't happen on my system whatever I try. I tried in LibreOffice,
Thunar and in the terminal (ls command). I'm not sure why it would display
in that way. Are you sure you don't sort for date or something?
Ki
ected syntax of the AND() function is not what
> Steve used, the question is whether the "additional spacing" behavior
> should be reported as a bug.
>
I think it should. Then it's up to the developers to decide whether or not
to do something about it. Maybe it could be set to low p
Den tis 7 feb. 2023 kl 20:42 skrev Steve Edmonds :
>
>
> On 08/02/2023 05:45, Johnny Rosenberg wrote:
> > Den tis 7 feb. 2023 kl 01:35 skrev Steve Edmonds <
> steve.edmo...@ptglobal.com
> >> :
> >> I am observing what may be a bug in saving a formula
s below.
>
> A3 is =IF((F22=$B$21) AND (G22<>$B$21),10,20)
>
I didn't even know you can use AND like that. I always write like:
=IF(AND(F22=$B$21;G22<>$B$21);10;20)
Kind regards
Johnny Rosenberg
>
> You will notice one space before and after the AND;
> Clic
Den sön 30 okt. 2022 kl 21:13 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
>
>
> On 31/10/2022 07:41, Steve Edmonds wrote:
>
>
>
> On 31/10/2022 07:10, Steve Edmonds wrote:
>
>
>
> On 31/10/2022 03:55, Johnny Rosenberg wrote:
>
> Den
Den sön 30 okt. 2022 kl 19:41 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
>
>
> On 31/10/2022 07:10, Steve Edmonds wrote:
>
>
>
> On 31/10/2022 03:55, Johnny Rosenberg wrote:
>
> Den sön 30 okt. 2022 kl 02:13 skrev Steve Edmonds <
> steve.edmo...@ptg
Den sön 30 okt. 2022 kl 02:13 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
>
>
> On 30/10/2022 10:22, Johnny Rosenberg wrote:
> > Den lör 29 okt. 2022 kl 22:48 skrev Steve Edmonds <
> > steve.edmo...@ptglobal.com>:
> >
> >>
> >> On 29
Den lör 29 okt. 2022 kl 22:48 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
>
>
> On 29/10/2022 12:12, Steve Edmonds wrote:
> >
> >
> > On 29/10/22 10:39 am, Johnny Rosenberg wrote:
> >> Den fre 28 okt. 2022 kl 22:20 skrev Steve Edmonds <
> &g
;
That's probably a bug. I don't know if anyone reported it, but I guess
someone should.
Before customizing, you can save your current settings, and then
(hopefully) bring them back if something goes wrong. Maybe worth to
consider next time. :)
Kind regards
Johnny Rosenberg
>
> On
window, Edit>Find
> > will open it again, no Find dialogue.
>
Yes, that's by design, as far as I know.
Kind regards
Johnny Rosenberg
> > Cmd F now opens another strange dialogue requesting search for command.
> >
> > steve
> >
> > On 27/10/22 10:49 pm,
2)Is there a way to fix it?
>
If nothing else works, why not install a newer version, such as LibreOffice
7.3.6?
I guess you should do that in any case, though. Maybe there were some
security fixes along the way, so that's probably a good idea.
Kind regards
Johnny Rosenberg
> Thank
6.4.7.2*
>
> Should I suppose all of these packages are affected by every vulnerability
> from your feeds?
> Does architecture or version release matter?
>
>
Is there any reason why you use such an old version? I'm sure a lot of
security stuff was fixed since then, so maybe a good idea to update.
like I can't say anything more
than that.
Kind regards
Johnny Rosenberg
>
>
> Thanks.
>
>
>
> --
>
> Chris Johnson rchristopherjohn...@gmail.com
> Ex SysAdmin, now, writer/Marriage is a great institution, but I'm
> not
> ready for an institution y
Den sön 21 aug. 2022 kl 18:55 skrev David Lynch :
> On 21/08/2022 15:50, Johnny Rosenberg wrote:
> > Den sön 21 aug. 2022 kl 14:04 skrev David Lynch <
> dlynch1...@googlemail.com>:
> >
> >> I am still getting a delay on loading into Calc with "Adapt Row
the GIMP mailing list has a solution for you, but then you
must write there instead of here.
Kind regards
Johnny Rosenberg
>
> Kolbjørn
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/h
t significantly
faster?
To what is that file stored (SD, SSD etc.)?
Kind regards
Johnny Rosenberg
> whose row heights do not change. Is there a
> way to avoid this delay, please?
>
> David Lynch
>
> Version: 7.4.0.3 (x64) / LibreOffice Community
> Build ID: f85e47c08ddd19c015
Den mån 15 aug. 2022 kl 13:38 skrev Michael D. Setzer II <
msetze...@gmail.com>:
> In Linux that are a number of option using standard
> commands.
>
I think he said he's on Windows, actually.
Kind regards
Johnny Rosenberg
> First would be sed
> sed 's/ \[/\t/g;s/\]/\t /
Okay, I did the same mistake again and sent my reply to the OP rather than
to the list. Once again sorry for that.
Now I intend to reply again, see below.
Den mån 15 aug. 2022 kl 00:01 skrev MR ZenWiz :
> On Sun, Aug 14, 2022 at 6:14 AM Johnny Rosenberg
> wrote:
> >
> > Den s
And you can't just increase the distance between each tab stop or decrease
the font size? Or maybe remove every second tab stop?
Kind regards
Johnny Rosenberg
> Dave
>
> On Tue, Aug 9, 2022, at 5:19 AM, Johnny Rosenberg wrote:
>
> Den tis 9 aug. 2022 kl 02:20 skrev Dave Lies
Den tis 9 aug. 2022 kl 15:50 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> On 2022/08/09 14:53, Johnny Rosenberg wrote:
> >
> >
> > Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC)
> > mailto:hyl...@conacher.co.za>>:
> >
>
Den tis 9 aug. 2022 kl 13:18 skrev Nathan Perkins <
nate.eric.perk...@gmail.com>:
> Bill,
>
> I am replying because I saw your post at users@global.libreoffice.org
>
> I don't yet understand how to reply to the general post
I think you actually did, though.
Kind rega
I doing wrong? I'm sure I have
got Preserve to work many times before, but maybe my brain crashed this
time.
Using LibreOffice 7.2.7.2 on Ubuntu Studio 20.04.
Kind regards
Johnny Rosenberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https
, yes. I didn't think of that. Yes, that makes sense, and I remember we
learned that method in school too. So no bug report necessary, then… Unless
we want the documentation to be clearer on this.
Kind regards
Johnny Rosenberg
> With this method if next digit is 1,2,3,4 the nu
ll in Calc.
Result: 12.13
Kind regards
Johnny Rosenberg
Den sön 5 juni 2022 kl 11:37 skrev Johnny Rosenberg :
> Looks like a bug to me. 12.125 returns 12.12, but 12.1251 returns 12.13.
> Both should return the same.
> I guess this bug should be reported.
> Meanwhile, you can
hod we learned at school:
Public Function fRound(x As Double, d As Integer)
fRound=Int(10^d*x+.5)/10^d
End Function
Test:
Print afRound(12.125, 2)
Result: 12.13
Print fRound(12.125, 2)
Result: 12.13
Print fRound(12.125, 1)
Result: 12.1
… and so on.
Kind regards
Johnny Rosenberg
Den sön 5 juni 2
gt; I've just worked through 500 pages of lyrics manually marking the
> choruses. Surprisingly fast, in fact. Basic problem solved, but it would
> be good to know for the future.
>
> Thanks.
>
>
So this doesn't seem to be possible (unless you write your own script that
unzips the od
an also just type m², then you don't need to change any settings. And
it looks better.
Kind regards
Johnny Rosenberg
> John
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-t
s, just select those cells and click that style.
Kind regards
Johnny Rosenberg
>
> --
> 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:/
just want to remove the trailing space from each line, both
> > Johnny's and Michael's methods work for me on your sample file.
> >
> > Find= [:space:]{1,}$
> > Replace= empty
> >
> > Find= $
> > Replace= empty
> >
> > Use regular expression= checked
>
t? Because Apache OpenOffice works
the same way as LibreOffice in this matter, working with objects and all
that. As I no longer have Apache OpenOffice installed I can't test it, so I
can't say for sure.
Kind regards
Johnny Rosenberg
>
> Any pointers would be welcome.
>
>
need to add <2a. Select 'More'>
> >
> > Peter HB
> >
> I did however find out that I can reverse the print order by entering in
> the 'pages' place the page numbers individually in reverse order, e.g.,
> 10, 8, 6, 4, 2; but for long documents that method is cumbersome
Not that I've been able to find. I also prefer to search columns
> before rows and wish there were a way to make that the default.
>
I think it would be even nicer if it remembered the settings from last time.
Kind regards
Johnny Rosenberg
>
>
> --
> T. R. Valentine
>
ght
or wrong, just explaining why this fails so often for me… :)
Again, sorry for all that. I'll try to get a little better at this…
Kind regards
Johnny Rosenberg
> You could use something like the below for the cells with a '+' in them.
> Assuming below is row 4, vertical bars are cell b
isplay as 16.7.
>
Correct.
> >
> > I want to get away from cell references and use the contained values.
> > Can I?
>
Not easily using existing functionality directly, but you can make it
happen, see above.
> >
> > I thought that =VALUE(A1)/10 might work, but the
Den lör 12 juni 2021 kl 21:51 skrev John Kaufmann :
> On 2021-06-12 13:59, Johnny Rosenberg wrote:
> > Den lör 12 juni 2021 kl 01:05 skrev Dutton:
> >
> >> In cell A1 there's the number 1230
> >> In cell A2 I want the number to appear as 12:30 (a time figure)
ut you said nothing about calculating so I assume that this
is what you want.
Kind regards
Johnny Rosenberg
>
>
>
>
> Does anyone know that
> can be done in Calc?
>
>
>
>
> Thank you,
>
>
> Peter Dutton
>
>
>
>
> --
> To unsubscribe e
;
As long as you have a ”#REF!” involved you'll get an error. Get rid of that
first (replace it with what's supposed to be there), and then try again.
And what's ”$zip”? Is that a cell name? Then that's wrong too.
Another way to get around it is to name your range. Then your formula could
look something
only guess.
Kind regards
Johnny Rosenberg
Den fre 11 juni 2021 kl 16:09 skrev Alessandra Beffa-Boggia <
alessandra.be...@bbaa.ch>:
> Hello,
> we are experiencing the following problem in CALC and we are asking for
> help:
> As you can see in the file attached it happe
Den sön 30 maj 2021 kl 18:05 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> On 2021/05/29 23:36, Johnny Rosenberg wrote:
> > Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) <
> > hyl...@conacher.co.za>:
> >
> >> Hi Johnny,
>
Den lör 29 maj 2021 kl 21:58 skrev Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za>:
> Hi Johnny,
>
> On 2021/05/28 23:44, Johnny Rosenberg wrote:
> > Den fre 28 maj 2021 kl 22:49 skrev Hylton Conacher (ZR1HPC) <
> > hyl...@conacher.co.za>:
> >
>
quot;";E3="");"";IF(B3>E3;A3;D3))
Then you could just fill down and only the relevant cells will display
something and the rest will be blank.
You can do the same thing to column H if you like, for instance in H3:
=IF(OR(A3="";B3="";D3="";E3=
racters, this
won't work.
Also note that this would also delete lines that ends with a number or
colon followed by a space. Tell me if that's a problem and we'll try to
work something out.
Kind regards
Johnny Rosenberg
>
>
> 25:49
> that's always been the case yeah and
> 25:52
ave to switch user every time you want to use
LibreOffice or when you are finished using it.
Kind regards
Johnny Rosenberg
> steve
>
> On 20/04/2021 04:36, Dan Lewis wrote:
> >
> >
> >
> > Forwarded Message
> > Subject: LibreOffice Fon
e and install it manually).
The only way I could find is if you use LibreOffice Portable.
Well, another way would of course be if you install an operating system in
a virtual machine and then install LibreOffice and the fonts there. Then
you'll only have those fonts in that virtual machi
entered. When I right-click and check
> the cell, it does show it’s set to auto-wrap.
>
> Using LO 6.2.8.2 on Mac 10.12.6
>
>
Strange. Mine wraps as expected. LibreOffice 7.0.4, on Manjaro Linux 20.2.1.
Maybe a bug in 6.2.8.2 that has been fixed now?
Kind regards
Johnny Rosenberg
:
=NOW()-DATE(YEAR(NOW());1;1)+1
or
=DATEDIF(DATE(YEAR(NOW());1;1)-1;NOW();"d")
The last one returns an integer. If you want to use the first one to return
an integer, just modify it like this:
=INT(NOW()-DATE(YEAR(NOW());1;1)+1)
Kind regards
Johnny Rosenberg
>
> Apr. 4, 2021 19:
would affect all your spreadsheets, I guess. In many cases
you probably don't want that.
Kind regards
Johnny Rosenberg
>
>
> On 2021-01-29 6:30 a.m., Rob Jasper wrote
>
> > James,
> >
> > Since a MINIF function does not exist you can use MINIFS.
> >
&g
with the information I'm given, a 45° rotated blue square in a
random (?) cell.
Kind regards
Johnny Rosenberg
>
> On 28/01/2021 08:16, Hylton Conacher (ZR1HPC) wrote:
> > Hi,
> >
> > I have a 134 column spreadsheet I am tidying up. An issue has arisen
> > where if I
Den sön 10 jan. 2021 kl 12:07 skrev Philip Jackson :
> On 10/01/2021 08:49, Johnny Rosenberg wrote:
> > Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA <
> >> tomcloydm...@gmail.com>:
> >>> I recently moved my LO user profile to a new computer, but my Calc
Ooops, did it again, I sent to the poster instead of the group.
Here it is for the group only.
My apologies.
Den sön 10 jan. 2021 kl 08:46 skrev Johnny Rosenberg :
> Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA <
> tomcloydm...@gmail.com>:
>
>> I recently moved my LO
hen opened in Libreoffice this no longer happens. How can I fix this?
>
Maybe there's a macro active in that document that makes that happen that
can't be run in LibreOffice Calc?
Kind regards
Johnny Rosenberg
>
> My MS Office 2007 has spat the dummy, and frankly I don't want to
Den tors 31 dec. 2020 kl 10:43 skrev Johnny Rosenberg <
gurus.knu...@gmail.com>:
>
>
> Den tis 29 dec. 2020 kl 15:29 skrev Peter Dutton :
>
>>
>>
>> In cell
>> A4 is the following code;
>>
>>
>> ="Monday
>>
language to US English, it will display:
Sunday 27
Why not Monday, you might ask? Because 27 December 2020 was a Sunday.
>
>
>
> Any
> idea how to fix this?
>
If you want 2020-12-27 to be a Monday, then no. Otherwise, see above.
Kind regards
Johnny Rosenbe
ond largest value when there
are 7 values that are larger than 322.
Kind regards
Johnny Rosenberg
>
> thanks
>
>
>
>
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+
uot;″N"
Or, if a period is used for decimals in your language:
[TT]"°"MM"′"SS.00"″O"
[TT]"°"MM"′"SS.00"″N"
Result in my case, after inputting 0:5:15,53 and 42:48:12,8:
00°05′12,53″O 42°58′12,80″N
42,9702°, 0,08681389°
Kind re
and replace the O in my example with whatever means East.
Same goes for North and South, of course. A negative number means south, a
positive number means north. Replace the N in my example with whatever
means North in your language.
Kind regards
Johnny Rosenberg
Den sön 22 nov. 2020 kl 12:23
Den sön 22 nov. 2020 kl 11:22 skrev Johnny Rosenberg :
> Yes, it's very, very easy (when you know how to do it…). Those coordinates
> work exactly like time, so all you need to do is to format your input cells
> properly (if you care about looks) and multiply your input cells with 24
>
stance, in
A3, type (for a result with 8 decimals):
=ROUND(A1*24;8) & ", " & ROUND(B1*24;8)
or, if you want to use the values in A2 and B2:
=ROUND(A2;8) & ", " & ROUND(B2;8)
Result (in my case):
42,9867, 0,0867
So, as you see, no advanced formulas are
you are trying to say.
Kind regards
Johnny Rosenberg
> It has only one value at one given time, it's this value that I want to
> compare with its previous values so I can extract the maximal value the
> cell
> ever reached.
>
>
>
>
> --
> Sent from:
> http:
with their values
automatically and run it before saving your spreadsheet. Or maybe let the
same macro also save the spreadsheet and use that macro instead of Ctrl+s
for saving.
Kind regards
Johnny Rosenberg
Den fre 2 okt. 2020 kl 19:58 skrev Johnny Rosenberg :
> Den fre 2 okt. 2020 kl 11:41 skrev Chi
argument for
> staticness or something.
> So far, I am forced to type or insert the time manually each time.
> Let me repeat it: Manually each time! Me! ;)
>
I'll experiment a bit with a macro for this. I'm back when done, if nobody
beats me to it.
Kind regards
Johnny Rosenberg
that
macro.
Kind regards
Johnny Rosenberg
> --
> Sent from:
> http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/m
what I do.
Do I also need to save the new spreadsheet file at some place included in
that Trusted File Locations?
LibreOffice 6.4.5
Manjaro Linux 20.0.3
Kind regards
Johnny Rosenberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get
I agree though that it's strange that fields don't work the same over the
whole suite. Seems like someone unnecessarily re-invented the wheel, and
did that more than once…
Kind regards
Johnny Rosenberg
> With that context, I have these questions:
>
> (Q1) If I go to Tools - Options -
to just use the same value and format it
to show minutes only. An example:
A1
Input: 12:34:56
Format: HH:MM
Result: 12:34
B1:
Formula: =A1
Format: [MM]
Result: 754
So same value, but formatted as [MM]. Don't forget the [].
This won't work if the values are in text format, of course.
Kin
ht Excel did worse than LibreOffice Calc, but after a while I
got tired of it, so I ended up with only 8 things, but I think I could make
the list much bigger.
Kind regards
Johnny Rosenberg
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems
Here's one suggestion that I found:
https://ask.libreoffice.org/en/question/53569/delete-duplicates-in-calc/
Otherwise I guess you have to write a macro.
Kind regards
Johnny Rosenberg
Den mån 29 juni 2020 kl 19:20 skrev Dave Stevens :
> There's a bug in the storage layout of some data
Den fre 26 juni 2020 kl 18:20 skrev Johnny Rosenberg :
> Today when I opened the Basic IDE for macro editing, I noticed that the
> font changed. I'm not sure which one it is now, but maybe FreeSans or
> something, but it used to be one of those mono fonts, and I want my old
> font ba
Today when I opened the Basic IDE for macro editing, I noticed that the
font changed. I'm not sure which one it is now, but maybe FreeSans or
something, but it used to be one of those mono fonts, and I want my old
font back. How do I change font in the Basic IDE?
Kind regards
Johnny Rosenberg
d. I guess the
same thing happens when exporting to PDF, but I didn't try that. The
automatically inserted hyphens have a gray background and they take no
place, that's two ways to see the difference between automatically and
manually inserted hyphens.
Maybe you could just file a bug rep
ept that you didn't. The
difference between subroutines and functions (at least in Basic), is that
functions returns something. Yours don't, as far as I can see.
To return a value in Basic (at least LibreOffice Basic), you just set a
value to the function itself:
ColorExampleFunc=Something
I'm
Den sön 10 maj 2020 kl 22:26 skrev jean-francois <
jean-francois.nifenec...@laposte.net>:
> Hi Johnny,
>
> Le 10/05/2020 à 14:35, Johnny Rosenberg a écrit :
> > I'm playing a little with macros (my level is probably one step or two
> > above beginner) and making exte
Den sön 10 maj 2020 kl 17:25 skrev Johnny Rosenberg :
> Den sön 10 maj 2020 kl 15:29 skrev Regina Henschel <
> rb.hensc...@t-online.de>:
>
>> Hi Johnny,
>>
>> Johnny Rosenberg schrieb am 10-May-20 um 14:35:
>> > Hi!
>> > I'm playing a littl
Den sön 10 maj 2020 kl 15:29 skrev Regina Henschel :
> Hi Johnny,
>
> Johnny Rosenberg schrieb am 10-May-20 um 14:35:
> > Hi!
> > I'm playing a little with macros (my level is probably one step or two
> > above beginner) and making extensions out of them. I found a fe
exporting
as Basic library), there are three files:
dialog.xlb
MyMacro.xba
script.xlb
If I want to use several languages, what would happen here? Or would there
be one ”library” for each language?
So, obviously I haven't grasped the concept for this at all yet. Any hints?
Kind regards
Johnny
Den tis 5 maj 2020 kl 02:07 skrev Steve Edmonds :
>
>
> On 04/05/2020 09:09, Johnny Rosenberg wrote:
>
> Den sön 3 maj 2020 kl 22:39 skrev Steve Edmonds <
> steve.edmo...@ptglobal.com>:
>
>>
>>
>> On 04/05/2020 08:24, Johnny Rosenberg wrote:
>>
Once again I accidentally sent something in private rather than to the
list. When will I learn?
Anyway, apologies to Dave and here it is for the list:
-- Forwarded message -
Från: Johnny Rosenberg
Date: sön 10 maj 2020 kl 09:07
Subject: Re: [libreoffice-users] Range names
Den tis 5 maj 2020 kl 08:38 skrev Luuk :
>
> On 4-5-2020 09:43, Brian Barker wrote:
> > At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote:
> >> Let's say I have a spreadsheet (I actually have several…) with a lot
> >> of cells and ranges already filled wit
for something that's already there, so that's why I ask this question
in the first place.
Kind regards
Johnny Rosenberg
--
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
Den lör 2 maj 2020 kl 10:07 skrev Johnny Rosenberg :
> I accidentally replied to you directly, I'm sorry for that. Here's another
> one, this time sent to the right destination, see below.
>
> Den lör 2 maj 2020 kl 07:49 skrev Ken Heard :
>
>> On 01/05/20 11:31 PM, J
I accidentally replied to you directly, I'm sorry for that. Here's another
one, this time sent to the right destination, see below.
Den lör 2 maj 2020 kl 07:49 skrev Ken Heard :
> On 01/05/20 11:31 PM, Johnny Rosenberg wrote:
> > Den fre 1 maj 2020 kl 18:11 skrev Ken Heard :
> >
&
1 - 100 of 529 matches
Mail list logo