Hi Harvey,
mark the content. Copy it to clipboard.
Go to the database file and open the tables pane.
Right mousclick → insert.
Choose the table where to append the data to, choose the column in the
wizard and it will be done.
You won't need a *.csv-file and phpMyAdmin to do this the same
Does not occur for me in 7.3.4.2
What text language shows at the bottom of the window frame. (mine is
English(UK)
What decimal separator is shown in Tools>Options>Language settings
Steve
On 09/08/2022 12:18, Dave Liesse wrote:
Hi, all. It's been a long time since I've run into a problem of
Hi, all. It's been a long time since I've run into a problem of any
significance, so posting here before I look up how to report a bug (partly to
see if this really is one).
In a Writer document, I have three Right tab stops set, to show staggered
columns of numbers. When I type a large
For the following I assumed the “simple date” column is is date format..
If not you can get to that by entering the formula
=IFERROR(DATEVALUE(LEFT($RAW.A3;10));"") and pull that down.
On another sheet I entered the “query date” in B2
The next formula gives you the max temp on that date:
On 8 Aug 2022 at 21:25, Hylton Conacher (ZR1HPC)
wrote:
Date sent: Mon, 8 Aug 2022 21:25:44 +0200
To: LibreOffice Users
From: "Hylton Conacher (ZR1HPC)"
Subject:[libreoffice-users] VLOOKUP Syntax to find
MAX on a particular
Hi Harvey,
my answer is older and I have not checked, whether the methods still
work, but perhaps you try it?
https://listarchives.libreoffice.org/global/users/2011/msg02407.html
Kind regards
Regina
Harvey Nimmo schrieb am 08.08.2022 um 21:16:
Dear formum,
I believe my objective should be
On 9/8/22 05:16, Harvey Nimmo wrote:
Dear formum,
I believe my objective should be rather simple, but I need to be
pointed in the right direction.
I have a column of text data (unique values) in Calc that I want to
transfer to a Base table. The Base table has been set up with three
columns,
Hi,
Using LO Calc 7.3.2.2 and I have a 28 column table RAW Data table in
excess of 65k rows. A three column sample below:
DateSimple Date Outdoor Temp
2022-01-01T00:05:00+02:00 2022-01-01 00:05:00 17.5
2022-01-01T00:00:00+02:00 2022-01-01
Dear formum,
I believe my objective should be rather simple, but I need to be
pointed in the right direction.
I have a column of text data (unique values) in Calc that I want to
transfer to a Base table. The Base table has been set up with three
columns, two of which I expect to remain empty
On Mon, 08 Aug 2022 15:55:16 +0100
Brian Barker wrote:
Hello Brian,
I'm not the OP, but
>This is not a perfectly defined problem, I'm afraid. I'm guessing
>that the pay rate is per hour: is that right?
{snipped for brevity}
thank you, Brian, for going into detail.
Bookmarked for
If I understand what you are looking at.
With A1 having 8:45
B1 having A1/time(1,0,0)
B1 would have decimal equivalent of time in hours
C1 would be B1 * $15 (example rate)
C1 would be 131.25 (8.75 * 15)
That would work if 24 hours or less.
If values more than 24 hours would need to more
Example:
On a spreadsheet I want to multiply time worked in hh:mm by pay
rate (integer) and I can't find out how.
Help please.
--
Bill Drescher
william {at} TechServSys {dot} com
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
12 matches
Mail list logo