Styjun

Can a German sentence have two subjects?

N.B. ligature in Latex

Copycat chess is back

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

least quadratic residue under GRH: an EXPLICIT bound

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

What Brexit solution does the DUP want?

Is it possible to make sharp wind that can cut stuff from afar?

Accidentally leaked the solution to an assignment, what to do now? (I'm the prof)

How to make payment on the internet without leaving a money trail?

Is there really no realistic way for a skeleton monster to move around without magic?

XeLaTeX and pdfLaTeX ignore hyphenation

Prevent a directory in /tmp from being deleted

Could a US political party gain complete control over the government by removing checks & balances?

Why was the small council so happy for Tyrion to become the Master of Coin?

What are these boxed doors outside store fronts in New York?

Download, install and reboot computer at night if needed

Why Is Death Allowed In the Matrix?

Non-Jewish family in an Orthodox Jewish Wedding

Do airline pilots ever risk not hearing communication directed to them specifically, from traffic controllers?

Infinite past with a beginning?

Is there a minimum number of transactions in a block?

DOS, create pipe for stdin/stdout of command.com(or 4dos.com) in C or Batch?

I see my dog run

LibreOffice writer field calculations

LibreOffice writer: Make an Hyperlink that opens an sshLibreOffice: Text for footer of last pageHow do I test in a LibreOffice python macro whether I'm in a Writer or Calc document?Further calculations from calculated fields in libreoffice baseAreas of display in LibreOffice not being refreshedasciidoc: is there a way to create an anchor that will be visible in libreoffice writer?libreoffice - run (python) macro to insert cross reference from Gnu/Linux command lineHow to insert a data url/binary to replace an image in a libreoffice writer document?LibreOffice Writer define and use dynamic variables for caption labels

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

3

In a LibreOffice writer document with a field of #temperature_farenheit. Is there a way to create a field named #temperature_celcius that would automatically calculate and insert the correct temperature?

And if this is possible, what types of fields do I use and how do I reference them for purposes of calculations.

textfield libreoffice calculation libreoffice-writer

share|improve this question

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

add a comment | 

3

In a LibreOffice writer document with a field of #temperature_farenheit. Is there a way to create a field named #temperature_celcius that would automatically calculate and insert the correct temperature?

And if this is possible, what types of fields do I use and how do I reference them for purposes of calculations.

textfield libreoffice calculation libreoffice-writer

share|improve this question

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

add a comment | 

In a LibreOffice writer document with a field of #temperature_farenheit. Is there a way to create a field named #temperature_celcius that would automatically calculate and insert the correct temperature?

And if this is possible, what types of fields do I use and how do I reference them for purposes of calculations.

textfield libreoffice calculation libreoffice-writer

share|improve this question

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

share|improve this question

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

share|improve this question

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

asked Mar 22 at 0:48

BrianWilsonBrianWilson

4181414

1 Answer
1

active

oldest

votes

2

This can be achieved with user variables. I'll give a start-to-finish example in painful detail for clarity, and hopefully universal applicability to other cases.

1. Open a new text document.


2. Enter some text like Water boils at °F (°C).
   


3. Put the cursor before °F where you would normally type the number.


4. From the menus, choose Insert→Fields→More Fields…


5. Go to the Variables tab. Choose Type: User Field.


6. Below that, you'll see each User Field gets a Name and a Value. It will not appear in your document, but enter a Name for this variable we're using to store "water's boiling temperature in degrees Fahrenheit," lets say: BoilF
   


7. Enter the Value you want stored in that variable, and accordingly shown in this field in the actual document text. Here, its: 212
   


8. Click the Insert button to actually add the field to your document. You should see 212 appear in the text.

You've now added the field, but also created a variable that can be used elsewhere. Now to do the math and use it elsewhere:

9. Leaving the Fields window open, put the cursor before °C.


10. In the Fields window, select Type: Insert Formula.


11. Below that, enter the Formula: (BoilF-32)*5/9
    


12. Click the Insert button. You should see 100 appear in the text.

Should you ever need to update a number pair, double-click the first number—that is, the User Field in your text. Example steps, using the above starting point:

13. Add to the sentence so it reads
    Water boils at 212°F (100°C) atop Everest.
    


14. It's now wrong, so double-click 212.


15. The Edit Fields window will appear. In the Value box, enter 154.4 and click the OK button. It will do the math and both temperatures will update in the text.
    Water boils at 154.4°F (68°C) atop Everest.
    

Be mindful of variable names. If you have 20 temperatures scattered through your text, you should in turn have 20 user variables, with thoughtfully-chosen names.

share|improve this answer

edited Apr 4 at 19:26

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There is no way to update the (BoilF) field without double-clicking it? I would like to directly edit the value. But doing so removes the field.
  
  – dpat
  Apr 4 at 15:25
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I don't believe so, no. Both fields are reflecting the variable, one without math, one with. The design choice they made with Writer is that the relationship is not two-directional.
  
  – Joel Reid
  Apr 4 at 19:31
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55291324%2flibreoffice-writer-field-calculations%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

This can be achieved with user variables. I'll give a start-to-finish example in painful detail for clarity, and hopefully universal applicability to other cases.

1. Open a new text document.


2. Enter some text like Water boils at °F (°C).
   


3. Put the cursor before °F where you would normally type the number.


4. From the menus, choose Insert→Fields→More Fields…


5. Go to the Variables tab. Choose Type: User Field.


6. Below that, you'll see each User Field gets a Name and a Value. It will not appear in your document, but enter a Name for this variable we're using to store "water's boiling temperature in degrees Fahrenheit," lets say: BoilF
   


7. Enter the Value you want stored in that variable, and accordingly shown in this field in the actual document text. Here, its: 212
   


8. Click the Insert button to actually add the field to your document. You should see 212 appear in the text.

You've now added the field, but also created a variable that can be used elsewhere. Now to do the math and use it elsewhere:

9. Leaving the Fields window open, put the cursor before °C.


10. In the Fields window, select Type: Insert Formula.


11. Below that, enter the Formula: (BoilF-32)*5/9
    


12. Click the Insert button. You should see 100 appear in the text.

Should you ever need to update a number pair, double-click the first number—that is, the User Field in your text. Example steps, using the above starting point:

13. Add to the sentence so it reads
    Water boils at 212°F (100°C) atop Everest.
    


14. It's now wrong, so double-click 212.


15. The Edit Fields window will appear. In the Value box, enter 154.4 and click the OK button. It will do the math and both temperatures will update in the text.
    Water boils at 154.4°F (68°C) atop Everest.
    

Be mindful of variable names. If you have 20 temperatures scattered through your text, you should in turn have 20 user variables, with thoughtfully-chosen names.

share|improve this answer

edited Apr 4 at 19:26

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There is no way to update the (BoilF) field without double-clicking it? I would like to directly edit the value. But doing so removes the field.
  
  – dpat
  Apr 4 at 15:25
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I don't believe so, no. Both fields are reflecting the variable, one without math, one with. The design choice they made with Writer is that the relationship is not two-directional.
  
  – Joel Reid
  Apr 4 at 19:31
  

  
  
  
  

add a comment | 

2

This can be achieved with user variables. I'll give a start-to-finish example in painful detail for clarity, and hopefully universal applicability to other cases.

1. Open a new text document.


2. Enter some text like Water boils at °F (°C).
   


3. Put the cursor before °F where you would normally type the number.


4. From the menus, choose Insert→Fields→More Fields…


5. Go to the Variables tab. Choose Type: User Field.


6. Below that, you'll see each User Field gets a Name and a Value. It will not appear in your document, but enter a Name for this variable we're using to store "water's boiling temperature in degrees Fahrenheit," lets say: BoilF
   


7. Enter the Value you want stored in that variable, and accordingly shown in this field in the actual document text. Here, its: 212
   


8. Click the Insert button to actually add the field to your document. You should see 212 appear in the text.

You've now added the field, but also created a variable that can be used elsewhere. Now to do the math and use it elsewhere:

9. Leaving the Fields window open, put the cursor before °C.


10. In the Fields window, select Type: Insert Formula.


11. Below that, enter the Formula: (BoilF-32)*5/9
    


12. Click the Insert button. You should see 100 appear in the text.

Should you ever need to update a number pair, double-click the first number—that is, the User Field in your text. Example steps, using the above starting point:

13. Add to the sentence so it reads
    Water boils at 212°F (100°C) atop Everest.
    


14. It's now wrong, so double-click 212.


15. The Edit Fields window will appear. In the Value box, enter 154.4 and click the OK button. It will do the math and both temperatures will update in the text.
    Water boils at 154.4°F (68°C) atop Everest.
    

Be mindful of variable names. If you have 20 temperatures scattered through your text, you should in turn have 20 user variables, with thoughtfully-chosen names.

share|improve this answer

edited Apr 4 at 19:26

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  There is no way to update the (BoilF) field without double-clicking it? I would like to directly edit the value. But doing so removes the field.
  
  – dpat
  Apr 4 at 15:25
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I don't believe so, no. Both fields are reflecting the variable, one without math, one with. The design choice they made with Writer is that the relationship is not two-directional.
  
  – Joel Reid
  Apr 4 at 19:31
  

  
  
  
  

add a comment | 

This can be achieved with user variables. I'll give a start-to-finish example in painful detail for clarity, and hopefully universal applicability to other cases.

1. Open a new text document.


2. Enter some text like Water boils at °F (°C).
   


3. Put the cursor before °F where you would normally type the number.


4. From the menus, choose Insert→Fields→More Fields…


5. Go to the Variables tab. Choose Type: User Field.


6. Below that, you'll see each User Field gets a Name and a Value. It will not appear in your document, but enter a Name for this variable we're using to store "water's boiling temperature in degrees Fahrenheit," lets say: BoilF
   


7. Enter the Value you want stored in that variable, and accordingly shown in this field in the actual document text. Here, its: 212
   


8. Click the Insert button to actually add the field to your document. You should see 212 appear in the text.

You've now added the field, but also created a variable that can be used elsewhere. Now to do the math and use it elsewhere:

9. Leaving the Fields window open, put the cursor before °C.


10. In the Fields window, select Type: Insert Formula.


11. Below that, enter the Formula: (BoilF-32)*5/9
    


12. Click the Insert button. You should see 100 appear in the text.

Should you ever need to update a number pair, double-click the first number—that is, the User Field in your text. Example steps, using the above starting point:

13. Add to the sentence so it reads
    Water boils at 212°F (100°C) atop Everest.
    


14. It's now wrong, so double-click 212.


15. The Edit Fields window will appear. In the Value box, enter 154.4 and click the OK button. It will do the math and both temperatures will update in the text.
    Water boils at 154.4°F (68°C) atop Everest.
    

Be mindful of variable names. If you have 20 temperatures scattered through your text, you should in turn have 20 user variables, with thoughtfully-chosen names.

share|improve this answer

edited Apr 4 at 19:26

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149

share|improve this answer

edited Apr 4 at 19:26

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149

answered Mar 25 at 17:58

Joel ReidJoel Reid

598149