Re: [libreoffice-users] CSV Import Loses Scientific Format

2025-03-02 Thread Robert Großkopf
Hi ?, Everything is formatted correctly, that is the text labels are text and the numbers are numbers, but the floating point (FP) format has been converted to a decimal format. All values are imported right. Your formatting should be done after importing. So mark the fields and format it you

[libreoffice-users] CSV Import Loses Scientific Format

2025-03-02 Thread LAP
Hello, I first give an example of a CSV file that I want to import into Libreoffice Calc: "t","Dpsi","Dtheta","Dphi" 0.0e+00,1.28000e+00,-8.0e+00,1.3e+02 1.0e-03,-1.10555e+02,-7.97843e+00,2.41833e+02 2.0e-03,-1.00443e+03,7.70485e+00,1.13570e+03 3.0e-03,-2.12390e+01,8.00497

Re: [libreoffice-users] Libre Office Programming

2025-03-02 Thread Johnny Rosenberg
Den sön 2 mars 2025 kl 18:34 skrev Günter Katzor : > Hello,is it not possible to simplify the conditional formatting in Libre > Office CALC?The list of pre-defined formatting can be omitted, as it is > rarely used. Do you mean styles? Rarely used? What do you use instead? There isn't anything el

Re: [libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Fred James
Alternative (1) select sell to move (2) right click, select cut (3) select destination cell (4) right click, select paste Regards Fred James Gabriele Bertolucci wrote: I agree, but only if you force yourself to use the mouse for selecting the single cell. Consider using the keyboard to reach th

Re: [libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Wiebe van der Worp
On 3/2/25 16:44, Gabriele Bertolucci wrote: First you have to select the cell: click on it, then click again and keep clicked, ... If you think about it, I agree 100% with OP, it is a clumsy way to go. An alternative: === Click on cell results in positioning Then Shift click on same cell re

Re: [libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Gabriele Bertolucci
I agree, but only if you force yourself to use the mouse for selecting the single cell. Consider using the keyboard to reach the same goal. If you move to the desired cell (with one only mouse click or with arrow keys), then to select it you can simply keep the shift key pressed then press righ

[libreoffice-users] Libre Office Programming

2025-03-02 Thread Günter Katzor
Hello,is it not possible to simplify the conditional formatting in Libre Office CALC?The list of pre-defined formatting can be omitted, as it is rarely used.It is particularly difficult for beginners to work with conditional formatting. Changing such conditions always requires new formatting.In

Re: [libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Gabriele Bertolucci
Sorry for my previous message, it wasn't correct. First you have to select the cell: click on it, then click again and keep clicked, move your mouse (this way you will select more cells) and move back to the starting cell. Now release the mouse button. Now that the cell is selected, you can dra

Re: [libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Gabriele Bertolucci
To move a single cell you must move the mouse cursor till one of the four edges of the cell: notice that cursor will not change its shape. When you have reached the desiderd edge, click left mouse and keep it clicked, then move you mouse till to the desired location. Done. > This is frustratin

[libreoffice-users] Moving single cell in Calc

2025-03-02 Thread Pat Brown
This is frustrating me no end. I have tried the "Ctrl-Click, Alt-Click" method, the "Select Cell then move cursor till hand appears", "Click and hold mouse on cell then drag". None if these work. Is there maybe something in settings that I need to change? This is only for single cells, multiple cel