Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Johnny Rosenberg
Ooops, I once again accidentally sent my reply directly to the OP and not to the list, sorry. At least this one is to the list. Den tis 9 aug. 2022 kl 20:04 skrev Dave Liesse : > Using v7.3.4.2, so pretty well up to date. Language is English (USA) and > commas/decimals are set correctly. > Ok,

[libreoffice-users] Calculated values in View or Query

2022-08-09 Thread Harvey Nimmo
I wonder if anyone knows a simple way in Base to calculate a value for a view and/or query field entry from the contents of other data fields of a record. (I know this feature from MSAccess) For example, I would like to extract a text string from a field in each record and display it in an extra

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Steve Edmonds
On 10/08/2022 02:55, Johnny Rosenberg wrote: Den tis 9 aug. 2022 kl 15:50 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: On 2022/08/09 14:53, Johnny Rosenberg wrote: Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC) mailto:hyl...@conacher.co.za>>: Hi Johnny,

Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Steve Edmonds
I suppose you have lots of rows and columns. I don't think it is a bug in writer not to overwrite letters in a "layer" but you may achieve the visual effect you are wanting by making each column a text box, each wide enough for the full number, right aligned, overlaying to the left, text boxes

Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Dave Liesse
Looks like I accidentally sent my response to one respondent instead of to the list. Here's what I said: -- Using v7.3.4.2, so pretty well up to date. Language is English (USA) and commas/decimals are set correctly. Tab stops are .5 inches apart, so the numbers definitely overflow

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Johnny Rosenberg
Den tis 9 aug. 2022 kl 15:50 skrev Hylton Conacher (ZR1HPC) < hyl...@conacher.co.za>: > On 2022/08/09 14:53, Johnny Rosenberg wrote: > > > > > > Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC) > > mailto:hyl...@conacher.co.za>>: > > > > Hi Johnny, > > > > On 2022/08/08 22:19,

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Hylton Conacher (ZR1HPC)
On 2022/08/09 14:53, Johnny Rosenberg wrote: Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC) mailto:hyl...@conacher.co.za>>: Hi Johnny, On 2022/08/08 22:19, Johnny Rosenberg wrote: > Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC) >

Re: [libreoffice-users] Reply hh:mm

2022-08-09 Thread Johnny Rosenberg
Den tis 9 aug. 2022 kl 13:18 skrev Nathan Perkins < nate.eric.perk...@gmail.com>: > Bill, > > I am replying because I saw your post at users@global.libreoffice.org > > I don't yet understand how to reply to the general post I think you actually did, though. Kind regards Johnny Rosenberg >

[libreoffice-users] Reply hh:mm

2022-08-09 Thread Nathan Perkins
Bill, I am replying because I saw your post at users@global.libreoffice.org I don't yet understand how to reply to the general post but I think I have an easy solution for you. If HH and MIN are entered in separate cells,  convert HH to min, add additional min, convert hourly rate to by

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Hylton Conacher (ZR1HPC)
On 2022/08/08 23:55, Michael H wrote: 1. Vlookup can only return columns to the left of the column you search so you need to introduce the date into a leftward column (N2=B2, copy it, paste into column N, all rows) All the examples I see on the net show that the left most column is the one

Re: [libreoffice-users] VLOOKUP Syntax to find MAX on a particular date

2022-08-09 Thread Hylton Conacher (ZR1HPC)
Hi Johnny, On 2022/08/08 22:19, Johnny Rosenberg wrote: Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC) mailto:hyl...@conacher.co.za>>: 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: Date   

Re: [libreoffice-users] export data from Calc, import to Base

2022-08-09 Thread Harvey Nimmo
Thanks for all the good tips. I have it working. This last one from Robert works, too. I had tried it before but for some reason only one record was imported that time. Anyway, good this time, although patience was needed to import more than 7000 records (felt like a minute, maybe only half).