How to disable autoformat in LibreOffice 6 Calc?Updating LibreOffice Calc 3.3.4How to run Libreoffice calcLibreOffice Calc - Disable roundingLibreoffice calc date format problemSimple query in LibreOffice Calclibreoffice calc -copy paste not workingExpand LibreOffice calc filter boxLibreOffice Calc Macro doesn't insert new sheetLibreoffice Calc Today Function Date Format?LibreOffice Calc - Delete empty rows
What if you are holding an Iron Flask with a demon inside and walk into Antimagic Field?
What are the balance implications behind making invisible things auto-hide?
Calculating total slots
What exact color does ozone gas have?
Multiplicative persistence
Does the UK parliament need to pass secondary legislation to accept the Article 50 extension
How to hide some fields of struct in C?
How do I delete all blank lines in a buffer?
How can mimic phobia be cured?
Mimic lecturing on blackboard, facing audience
Terse Method to Swap Lowest for Highest?
Why does the Sun have different day lengths, but not the gas giants?
Strong empirical falsification of quantum mechanics based on vacuum energy density
Why is the "ls" command showing permissions of files in a FAT32 partition?
Quoting Keynes in a lecture
How do apertures which seem too large to physically fit work?
What is Cash Advance APR?
Fear of getting stuck on one programming language / technology that is not used in my country
Are Captain Marvel's powers affected by Thanos' actions in Infinity War
Add big quotation marks inside my colorbox
Do the primes contain an infinite almost arithmetic progression?
Biological Blimps: Propulsion
Does the Linux kernel need a file system to run?
creating a ":KeepCursor" command
How to disable autoformat in LibreOffice 6 Calc?
Updating LibreOffice Calc 3.3.4How to run Libreoffice calcLibreOffice Calc - Disable roundingLibreoffice calc date format problemSimple query in LibreOffice Calclibreoffice calc -copy paste not workingExpand LibreOffice calc filter boxLibreOffice Calc Macro doesn't insert new sheetLibreoffice Calc Today Function Date Format?LibreOffice Calc - Delete empty rows
I am using LibreOffice Version: 6.1.5.2
I cannot find a way to remove autoformat from Calc.
I am trying to enter 00:10:00 as a value and it keeps converting it to 12:10:00 AM. This is a timecode and I need to build a lot of these.
I have looked online but all I found was a post from 2012 and that is not applicable. I also would really only like to ignore a column and not turn it off completely but for now I will take a full removal of autoformat. I'm sure it has the capability but I cannot find it at all.
I have tried to Clear Direct Formatting but then it converts my value to 0.00694444444444444... This is pretty frustrating so I am hear asking for help.
Thanks
libreoffice
asked Feb 25 at 17:41
JeremyJeremy
135111
add a comment |
I am using LibreOffice Version: 6.1.5.2
I cannot find a way to remove autoformat from Calc.
I am trying to enter 00:10:00 as a value and it keeps converting it to 12:10:00 AM. This is a timecode and I need to build a lot of these.
I have looked online but all I found was a post from 2012 and that is not applicable. I also would really only like to ignore a column and not turn it off completely but for now I will take a full removal of autoformat. I'm sure it has the capability but I cannot find it at all.
I have tried to Clear Direct Formatting but then it converts my value to 0.00694444444444444... This is pretty frustrating so I am hear asking for help.
Thanks
libreoffice
asked Feb 25 at 17:41
JeremyJeremy
135111
1
Why not select an area and set format to text?
– Pilot6
Feb 25 at 17:42
Dude.... thanks... It took me a min to figure out how to do this. Never thought to right-click... Thanks a lot
– Jeremy
Feb 25 at 17:44
I tried on LO 5, and I didn't have to do it though.
– Pilot6
Feb 25 at 17:46
That's probably why I am now having this problem. It's been a while since I needed to do this and I had no issues before. Maybe it's an 6 issue/feature
– Jeremy
Feb 25 at 17:48
add a comment |
I am using LibreOffice Version: 6.1.5.2
I cannot find a way to remove autoformat from Calc.
I am trying to enter 00:10:00 as a value and it keeps converting it to 12:10:00 AM. This is a timecode and I need to build a lot of these.
I have looked online but all I found was a post from 2012 and that is not applicable. I also would really only like to ignore a column and not turn it off completely but for now I will take a full removal of autoformat. I'm sure it has the capability but I cannot find it at all.
I have tried to Clear Direct Formatting but then it converts my value to 0.00694444444444444... This is pretty frustrating so I am hear asking for help.
Thanks
libreoffice
asked Feb 25 at 17:41
JeremyJeremy
135111
I am using LibreOffice Version: 6.1.5.2
I cannot find a way to remove autoformat from Calc.
I am trying to enter 00:10:00 as a value and it keeps converting it to 12:10:00 AM. This is a timecode and I need to build a lot of these.
I have looked online but all I found was a post from 2012 and that is not applicable. I also would really only like to ignore a column and not turn it off completely but for now I will take a full removal of autoformat. I'm sure it has the capability but I cannot find it at all.
I have tried to Clear Direct Formatting but then it converts my value to 0.00694444444444444... This is pretty frustrating so I am hear asking for help.
Thanks
libreoffice
libreoffice
asked Feb 25 at 17:41
JeremyJeremy
135111
asked Feb 25 at 17:41
JeremyJeremy
135111
asked Feb 25 at 17:41
JeremyJeremy
135111
asked Feb 25 at 17:41
JeremyJeremy
135111
asked Feb 25 at 17:41
JeremyJeremy
135111
135111
1
Why not select an area and set format to text?
– Pilot6
Feb 25 at 17:42
Dude.... thanks... It took me a min to figure out how to do this. Never thought to right-click... Thanks a lot
– Jeremy
Feb 25 at 17:44
I tried on LO 5, and I didn't have to do it though.
– Pilot6
Feb 25 at 17:46
That's probably why I am now having this problem. It's been a while since I needed to do this and I had no issues before. Maybe it's an 6 issue/feature
– Jeremy
Feb 25 at 17:48
add a comment |
1
Why not select an area and set format to text?
– Pilot6
Feb 25 at 17:42
Dude.... thanks... It took me a min to figure out how to do this. Never thought to right-click... Thanks a lot
– Jeremy
Feb 25 at 17:44
I tried on LO 5, and I didn't have to do it though.
– Pilot6
Feb 25 at 17:46
That's probably why I am now having this problem. It's been a while since I needed to do this and I had no issues before. Maybe it's an 6 issue/feature
– Jeremy
Feb 25 at 17:48
1
1
Why not select an area and set format to text?
– Pilot6
Feb 25 at 17:42
Why not select an area and set format to text?
– Pilot6
Feb 25 at 17:42
Dude.... thanks... It took me a min to figure out how to do this. Never thought to right-click... Thanks a lot
– Jeremy
Feb 25 at 17:44
Dude.... thanks... It took me a min to figure out how to do this. Never thought to right-click... Thanks a lot
– Jeremy
Feb 25 at 17:44
I tried on LO 5, and I didn't have to do it though.
– Pilot6
Feb 25 at 17:46
I tried on LO 5, and I didn't have to do it though.
– Pilot6
Feb 25 at 17:46
That's probably why I am now having this problem. It's been a while since I needed to do this and I had no issues before. Maybe it's an 6 issue/feature
– Jeremy
Feb 25 at 17:48
That's probably why I am now having this problem. It's been a while since I needed to do this and I had no issues before. Maybe it's an 6 issue/feature
– Jeremy
Feb 25 at 17:48
add a comment |
2 Answers
2
active
oldest
votes
Select an input area, right-click it and select "Text" format.
That will disable auto formatting.
I added 00:10:00 to LO Calc 5 and it didn't change though.
Probably they added some automation in the 6 version.
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
add a comment |
If I wanted to be flip, I would say move to Win 10. I am running Win 10 could not fine it in LibreOffice 6.2.
answered 1 hour ago
Harry SmithHarry Smith
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1121194%2fhow-to-disable-autoformat-in-libreoffice-6-calc%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Select an input area, right-click it and select "Text" format.
That will disable auto formatting.
I added 00:10:00 to LO Calc 5 and it didn't change though.
Probably they added some automation in the 6 version.
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
add a comment |
Select an input area, right-click it and select "Text" format.
That will disable auto formatting.
I added 00:10:00 to LO Calc 5 and it didn't change though.
Probably they added some automation in the 6 version.
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
add a comment |
Select an input area, right-click it and select "Text" format.
That will disable auto formatting.
I added 00:10:00 to LO Calc 5 and it didn't change though.
Probably they added some automation in the 6 version.
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
Select an input area, right-click it and select "Text" format.
That will disable auto formatting.
I added 00:10:00 to LO Calc 5 and it didn't change though.
Probably they added some automation in the 6 version.
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
answered Feb 25 at 17:51
Pilot6Pilot6
53.6k15109198
53.6k15109198
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
add a comment |
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
But "I am trying to enter 00:10:00 as a value".
– DK Bose
Feb 25 at 17:52
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
@DKBose I, and presumably Pilot6 as well, took that to mean "I want to enter the literal string '00:10:00' as a value, and not as a formatted string that gets interpreted and converted to a different numerical value, which then may be re-formatted in a way I don't have control over".
– Jos
Feb 25 at 18:00
add a comment |
If I wanted to be flip, I would say move to Win 10. I am running Win 10 could not fine it in LibreOffice 6.2.
answered 1 hour ago
Harry SmithHarry Smith
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
If I wanted to be flip, I would say move to Win 10. I am running Win 10 could not fine it in LibreOffice 6.2.
answered 1 hour ago
Harry SmithHarry Smith
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
If I wanted to be flip, I would say move to Win 10. I am running Win 10 could not fine it in LibreOffice 6.2.
answered 1 hour ago
Harry SmithHarry Smith
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
If I wanted to be flip, I would say move to Win 10. I am running Win 10 could not fine it in LibreOffice 6.2.
answered 1 hour ago
Harry SmithHarry Smith
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 1 hour ago
Harry SmithHarry Smith
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 1 hour ago
Harry SmithHarry Smith
1
answered 1 hour ago
Harry SmithHarry Smith
1
1
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Harry Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1121194%2fhow-to-disable-autoformat-in-libreoffice-6-calc%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Why not select an area and set format to text?
– Pilot6
Feb 25 at 17:42
Dude.... thanks... It took me a min to figure out how to do this. Never thought to right-click... Thanks a lot
– Jeremy
Feb 25 at 17:44
I tried on LO 5, and I didn't have to do it though.
– Pilot6
Feb 25 at 17:46
That's probably why I am now having this problem. It's been a while since I needed to do this and I had no issues before. Maybe it's an 6 issue/feature
– Jeremy
Feb 25 at 17:48