I am having a problem with the use of the hyphen/minus character in Libre Calc.
When I type the minus sign, expecting a - sometimes it will come up with a sign which looks like a longer minus sign. And any attempt to change it fails.
Because it is a different character, it affects the way that data and text is sorted.
Using Find and Replace works to eliminate the longer characters but that is a bit cumbersome.
I have tried to cut and paste it into this post but it reverts to the original smaller sign so I am not able to show you what it looks like. I have tried to attach a file which should show the different characters.
Does anyone know of a solution to this problem?
I have tried using different fonts but the same thing is happening.
Cheers
Graham
[Solved] Inconsistent hyphen/minus character in Calc
-
bluewindfisher
- Posts: 2
- Joined: Sun Feb 05, 2023 8:12 am
[Solved] Inconsistent hyphen/minus character in Calc
- Attachments
-
- Template for Find and Replace Hyphen.odt
- (12.76 KiB) Downloaded 73 times
Last edited by MrProgrammer on Wed Feb 15, 2023 5:49 am, edited 3 times in total.
Reason: Tagged ✓ [Solved] Disable Autocorrect for the character -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] Disable Autocorrect for the character -- MrProgrammer, forum moderator
Libre Office 7.4.3.2 on Windows 10 - Build 19045
Re: Inconsistent hyphen/minus character in Calc
Have you looked at the settings in Tools | AutoCorrect Options?
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
-
bluewindfisher
- Posts: 2
- Joined: Sun Feb 05, 2023 8:12 am
Re: Inconsistent hyphen/minus character in Calc
Thanks David,
I have had a look at those options and changed the one that seemed relevant.
It works fine as long as I don't type a space after the hyphen. If I do It immediately changes to the longer character.
I can't see any other settings that are relevant.
I have had a look at those options and changed the one that seemed relevant.
It works fine as long as I don't type a space after the hyphen. If I do It immediately changes to the longer character.
I can't see any other settings that are relevant.
Libre Office 7.4.3.2 on Windows 10 - Build 19045
Re: Inconsistent hyphen/minus character in Calc
You could try disabling AutoCorrect if you don't need it - under Options uncheck Use replacement table.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Apache OpenOffice 4.1.16
LibreOffice 26.2.2.2; SlackBuild for 26.2.2 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.