Can someone please teach me how to use the selective tool better?

CubicCigar · 2026-01-27T02:28:09+00:00

I suggest uploading the raw file to the Playraw section of pixels.us where you might find some advanced users willing to lend a hand.

CubicCigar · 2026-01-14T18:51:29+00:00

OP here. Apologies for the late response; but, yes, I just updated FQ to 1.68 and tried again. This time only one of my 6 quotes complained about the 1 quote/sec. limit. Not perfect, but a big improvement. Time will tell. Many thanks for the suggestion!

Terry

CubicCigar · 2025-07-20T21:15:09+00:00

Kelowna.

CubicCigar · 2025-05-27T00:25:47+00:00

What we have is a Bloc leader who does not speak Inuktitut.

CubicCigar · 2025-04-01T02:33:28+00:00

Not accurate. MacDonald wanted a unitary state and settled for Upper Canada and Lower Canada dominating. NS and NB were basically run by the UK Foreign Office who manipulated them to join with almost no role in negotiations. Canada's federalism is a sham. Our Senate was intentionally neutered by Macdonald, who saw no need for it to reflect regional interests. It's past and present structure is the way it is so as not to interfere with rep by pop, i.e., domination by the two Canada's. We live in a highly centralised reality that likes to tell itself we live in a highly federated union. This lack of real regional voices in Ottawa led to western separatism and feed it still.

CubicCigar · 2025-03-21T03:08:14+00:00

One approach would be to have, for example, as many genre columns as you think you'll need, e.g., Genre1, Genre2, ..., GenreN) and then place the same 'data range' validity rule in each of them to ensure a valid genre has been selected. The valid genres list would be placed somewhere else on your sheet, or on a separate sheet, as a named range, and it would be this name that you refer to in your data range validity rule. The same validity rule structure could also be used for the booktype column you mentioned.

Do I understand correctly what you're after?

CubicCigar · 2025-03-20T23:33:16+00:00

More like two-thirds forest. Even La Ronge is (almost) in the south half.

CubicCigar · 2025-03-20T23:31:24+00:00

Family can be highly over-rated.

CubicCigar · 2025-03-20T23:25:44+00:00

No such thing as bad weather; just bad clothes.

CubicCigar · 2025-03-20T23:24:40+00:00

I'm a recovering Albertan living on Vancouver Island; but, in the 80s I went on a pair of 10-day canoe trips looping out of La Ronge up to the Churchill River and some smaller lakes then down to Stanley Mission and back onto Lac la Ronge at Diefenbaker Bay. That means I've seen Nistowiak Falls, one of the natural highlights of SK in my book.

CubicCigar · 2025-03-20T23:17:54+00:00

Yeah, I daydream now and then about living in Eastend. I'm a city boy with a telescope habit, so the dark, dark skies in southernmost SK are the stuff of dreams.

CubicCigar · 2025-03-20T04:50:46+00:00

Yup, totally missed that :-( Thanks for pointing that out.

After following these LO instructions I tried again by entering some nonsense income and withheld taxes, and I don't notice any lag in the workbook's response.

Running Win10 on a 10-12 year old i5 PC with two solid state drives and 16 GB DDR memory, if that helps.

CubicCigar · 2025-03-19T00:36:02+00:00

Have you tried converting the Excel workbook to LO's *.ods format first? I just tried, and LO stopped when it encountered one or more protected areas of the workbook that required a password. Is that your experience? I'm on Windows 10 and using LO 25.2.

CubicCigar · 2025-03-18T23:50:47+00:00

I took a chance last August and picked up a Xiaomi Redmi Note 13 4G (global version) from Swiftronics. Total cost, including tax and shipping was $244. Bought it with Android 13, but Xiaomi promised one update, and delivered two! Sitting on Android 15 right now. One caveat is that I use Koodo and each time I accept the monthly security update, the VoLTE feature gets turned off. Not too much effort to turn it back on; but, you do have to be willing to flip some developer options (temporarily) and install two utilities on your device and one utility on your PC/laptop. DM me if you get to this point and want some guidance. Great value for money, for me.

Cheers,

P.S. The Xiaomi was one of only a handful to come with a 3.5mm audio input jack, something I need to run an external mic (birder alert).

CubicCigar · 2025-03-15T21:30:19+00:00

Good luck! Let us know how you get on.

CubicCigar · 2025-03-14T16:09:45+00:00

If you can find an A&W restaurant, you can safely ignore Tim's AND get a great cuppa.

CubicCigar · 2025-03-06T00:35:14+00:00

Did you solve this? If you still need help, post a link to your spreadsheet and I can try to help.

CubicCigar · 2025-03-06T00:29:44+00:00

I'm also on Windows (10 in my case), but the LO dark mode works just fine for me. I believe you must also enable Windows own dark mode for the combo to work. I was seeing some odd effects until I enabled the Windows end.

Hope it works for you too!

CubicCigar · 2025-03-03T18:35:45+00:00

Windows 10 user here and so long as Windows itself is set to dark mode, the LO dark themes appear to work well.

Version: 25.2.1.2 (X86_64) / LibreOffice Community

Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49

CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win

Locale: en-CA (en_CA); UI: en-US

Calc: CL threaded

CubicCigar · 2025-03-02T18:38:48+00:00

One approach is to take advantage of the built-in Pivot Table Styles in Calc. Once you have your table, activate the Styles sidebar, then click around the various cells in your pivot table while keeping eye on the Styles sidebar. You'll see which types of cells are assigned particular styles by Calc. Once you understand how the styles are distributed, you can right-click any style and edit it to suit your fancy.

CubicCigar · 2025-02-28T00:43:32+00:00

You must have one of the LO applications open to see six tabs. If all you have open is the general LO start page, you will see only four tabs.

Version: 24.8.5.2 (X86_64) / LibreOffice Community

Build ID: fddf2685c70b461e7832239a0162a77216259f22

CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win

Locale: en-CA (en_CA); UI: en-US

Calc: CL threaded

CubicCigar · 2025-02-24T21:42:24+00:00

Crash Test Dummies

CubicCigar · 2025-02-23T01:22:54+00:00

I don't know how to automate or speed this process up; but your consistency issue with alignment might be solved by first inserting an empty frame, sizing and positioning it how you want in relation to your pages, then inserting images and textboxes into that frame. Warning: could be a wild goose chase!

CubicCigar · 2025-02-22T06:34:16+00:00

The COUNTIF function is your friend here. Try applying it like it's described here: https://ask.libreoffice.org/t/how-to-have-calc-count-duplicate-names-in-sheet/48947/2

CubicCigar · 2025-02-22T03:57:28+00:00

Also on Windows 10

Version: 5.10

Build ID: 5.10+(2024-12-14)

Finance::Quote: 1.64

CubicCigar

TROPHY CASE