When.com Web Search

Search results

  1. Results From The WOW.Com Content Network
  2. [Solved] Calculate a period as years, months, and days

    forum.openoffice.org/en/forum/viewtopic.php?t=87153

    Even "almost 2 years and 8 months" is better for my purpose. Windows 10: Apache OpenOffice v 4.1.9 (Build ...

  3. Line break within a cell - Apache OpenOffice Community Forums

    forum.openoffice.org/en/forum/viewtopic.php?f=9&t=54503

    acknak wrote: The only way to enter a line break is when you edit the text in the cell: double-click on the cell itself and you can enter a line break by typing Ctrl+Enter. It doesn't work when you're typing in the formula toolbar. Thank you for this tip. In error, I kept wanting to Shift+Enter.

  4. [Solved] Sum a column of times in minutes and seconds

    forum.openoffice.org/en/forum/viewtopic.php?t=107948

    As discussed in section 5 above, you must ensure that Calc understands the values you're entering. Calc will interpret 1:22 as one hour and twenty two minutes. There is no way to tell Calc that you want 1:22 to mean one minute and twenty two seconds. To get that value in a cell, either enter 0:1:22 or 1:22.0 or =TIME(0;1;22).

  5. [Solved] Converting time values - Apache OpenOffice Community...

    forum.openoffice.org/en/forum/viewtopic.php?f=5&t=39238

    Hours = (B1-A1)*24. f I just do a simple equation (D1/C1) I get an eroneous answer of 526.83 instead of 21.95 which is the correct answer. 526.83/21.95 = 24. Please, edit this topic's initial post and add " [Solved]" to the subject line if your problem has been solved. Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice.

  6. [Solved] Drag/drop not working - Apache OpenOffice Community...

    forum.openoffice.org/en/forum/viewtopic.php?t=70793

    Click on the header to select the column, then click/hold in the selected/highlighted area (but not on the header). Hold the mouse button down for a second, then move it--the mouse cursor should change to indicate a drag/drop has started. Note: the default action for drag/drop in Calc is that the dropped column (s) should replace the cells they ...

  7. [Solved] Unable to move column - Apache OpenOffice Community...

    forum.openoffice.org/en/forum/viewtopic.php?t=99363

    These instruction posted in this forum do not work for me: Here's the step-by-step: Select the source column. This works. Click again anywhere on the selected area, hold for a second and drag left or right. Nothing drags left or right, whether I left-click or right-click when dragging, To move the column, hold Alt when you release the mouse ...

  8. [Solved] Dragging Cells in Calc - Apache OpenOffice Community...

    forum.openoffice.org/en/forum/viewtopic.php?f=9&t=12466

    by notbugme » Wed Jan 20, 2016 8:33 pm. (Calc openoffice.org 3.4.1) Move an individual cell by dragging WITHOUT using the keyboard: 1) First select a cell by left clicking in the middle of the cell & holding the mouse key down. 2) While holding the key down, move the cursor beyond the cell border.

  9. [Solved] How to create a 24-hour clock pie chart

    forum.openoffice.org/en/forum/viewtopic.php?t=70693

    Hello, I don´t find anywhere on the Internet how to create a 24-hour clock pie chart. On the edge of the pie, I would like to insert certain time of the day but not all, and within each slice of the pie corresponding to a time period, I would like to insert a small text. The aim of the pie is to show how is organized the spanish day : from 6 ...

  10. [Solved] Date to text - how - Apache OpenOffice Community Forums

    forum.openoffice.org/en/forum/viewtopic.php?t=105738

    Re: Date to text - how. by FJCC » Wed Jul 21, 2021 9:11 pm. I think you want a formula like. Code: Select all. ="Date = " & TEXT (A1;"YYYY-MM-DD") OpenOffice 4.1 on Windows 10 and Linux Mint If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.

  11. [Solved] OpenOffice crashes - Apache OpenOffice Community Forums

    forum.openoffice.org/en/forum/viewtopic.php?t=108627

    by RoryOF » Thu Oct 06, 2022 4:20 pm. One quick test for causes of crashes is to start Windows in Safe Mode, and, running Windows in that mode, use OpenOffice. If OpenOffice runs stable in Windows Safe Mode, then the cause is by some program or driver that runs in Windows Normal mode. Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS.