Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 05 May 2021 22:12:18 +0200What formula do i need to drag a column/line of fractions into one of percentages?https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/How do i automatically turn fractions into percentages in a neighboring cell and then drag-copy the formula along a whole column/line to turn all fractions into percentages in the neighboring column/line? Fri, 30 Apr 2021 21:58:11 +0200https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/Answer by LeroyG for <p>How do i automatically turn fractions into percentages in a neighboring cell and then drag-copy the formula along a whole column/line to turn all fractions into percentages in the neighboring column/line? </p>
https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?answer=307247#post-id-307247Drag while holding `Ctrl`, then apply *Format as Percent* (`Ctrl+Shift+5` the 5 in the upper row of the keyboard).
*Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.*
---
*Add Answer* is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click ***edit*** (below your question) to add more information. Thanks.
*Check the mark (<img alt="Answer mark" src="/upfiles/15937350258938472.png"> → <img alt="Correct answer mark" src="/upfiles/16046945351810415.png">) to the left of the answer that solves your question (it may take a little while until it turns green).*Sun, 02 May 2021 03:30:36 +0200https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?answer=307247#post-id-307247Comment by LeroyG for <p>Drag while holding <code>Ctrl</code>, then apply <em>Format as Percent</em> (<code>Ctrl+Shift+5</code> the 5 in the upper row of the keyboard).</p>
<p><em>Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.</em></p>
<hr>
<p><em>Add Answer</em> is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click <strong><em>edit</em></strong> (below your question) to add more information. Thanks.</p>
<p><em>Check the mark (<img src="/upfiles/15937350258938472.png" alt="Answer mark"> → <img src="/upfiles/16046945351810415.png" alt="Correct answer mark">) to the left of the answer that solves your question (it may take a little while until it turns green).</em></p>
https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?comment=307907#post-id-307907You're welcome.Wed, 05 May 2021 22:12:18 +0200https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?comment=307907#post-id-307907Comment by TF8009 for <p>Drag while holding <code>Ctrl</code>, then apply <em>Format as Percent</em> (<code>Ctrl+Shift+5</code> the 5 in the upper row of the keyboard).</p>
<p><em>Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.</em></p>
<hr>
<p><em>Add Answer</em> is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click <strong><em>edit</em></strong> (below your question) to add more information. Thanks.</p>
<p><em>Check the mark (<img src="/upfiles/15937350258938472.png" alt="Answer mark"> → <img src="/upfiles/16046945351810415.png" alt="Correct answer mark">) to the left of the answer that solves your question (it may take a little while until it turns green).</em></p>
https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?comment=307882#post-id-307882Many thanks for the help.Wed, 05 May 2021 20:23:41 +0200https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?comment=307882#post-id-307882Answer by eeigor for <p>How do i automatically turn fractions into percentages in a neighboring cell and then drag-copy the formula along a whole column/line to turn all fractions into percentages in the neighboring column/line? </p>
https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?answer=307095#post-id-307095For this, there is a percentage format of the number that will be copied when filling in the cells.Fri, 30 Apr 2021 22:21:04 +0200https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?answer=307095#post-id-307095Comment by TF8009 for <p>For this, there is a percentage format of the number that will be copied when filling in the cells.</p>
https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?comment=307236#post-id-307236Yes.
One column has simple fractions, fraction format. The column next to it has the percentage format. I am selecting a fraction from the first column and dragging it to the second column. Shouldn't it appear as the equivalent percentage? Eg 4/5 turns into 80%. Correct? Instead, what i see is that 4/5 turns into 1 4/5 in the second column.Sun, 02 May 2021 00:37:39 +0200https://ask.libreoffice.org/en/question/307092/what-formula-do-i-need-to-drag-a-columnline-of-fractions-into-one-of-percentages/?comment=307236#post-id-307236