[libreoffice-users] XLOOKUP in LibreOffice 24.8

rds (* ?) for partial matches", whereas the older functions support (the full set of) regular expressions. Please can XLOOKUP (and similar new functions) support the full set of regular expressions? David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libre

[libreoffice-users] Accessing character formats in calc

cell, but that destroys the distinctive formatting. David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Limits in Calc

string that can be stored in a cell and used by functions such as REGEX David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org

[libreoffice-users] Exploiting ScriptForge in Calc

ScriptForge routines in a manner that makes them speedy? David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List ar

Re: [libreoffice-users] Defaults in Find dialogue and toolbar for Calc

On 24/10/2021 03:29, John Kaufmann wrote: On 2021-10-23 18:14, Johnny Rosenberg wrote: Den tors 7 okt. 2021 kl 00:28 skrev T. R. Valentine : On Tue, 5 Oct 2021 at 07:07, David Lynch wrote: The defaults in the Find toolbar and the Find dialog are: Direction: Rows Search in: Formulae I

[libreoffice-users] Defaults in Find dialogue and toolbar for Calc

to change the default permanently? Is there a reason for the current behaviour? If not, I propose to ask for a change. David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] Calc: Adapting row height is slow

g I can do to eliminate or speed up this part of the processing? David Lynch Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc

[libreoffice-users] Regular expressions

lt;http://userguide.icu-project.org/strings/regexp> linked from the REGEX help page Please, is there anywhere that tells me what regular expressions are supported? David Lynch Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads:

[libreoffice-users] REGEX difficulty

If I use the REGEX tester <https://regex101.com/> with regular expression (?=(29|79|97)) and test string 29791 I get 3 matches 29, 97,79, as I expect. On the other hand, if I enter =REGEX("29791","(?=(29|79|97))",,1) I get a zero length string. Can anyone help ple

[libreoffice-users] Unable to record macros

7c66b2379df5ea4407429775 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists

[libreoffice-users] Calc - Find and Replace options

and Search in "Formulae".  I can't deduce why it does this. Why does it do this? Can I stop it reverting to the default? David Lynch Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: wi

[libreoffice-users] Calc - Find and Replace options

and Search in "Formulae".  I can't deduce why it does this. Why does it do this? Can I stop it reverting to the default? David Lynch Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: wi

[libreoffice-users] Calc - Find and Replace options

and Search in "Formulae".  I can't deduce why it does this. Why does it do this? Can I stop it reverting to the default? David Lynch Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: wi

[libreoffice-users] [Gramps-devel] Crash report (unable to report via Bugzilla)

file because LO didn't offer me the chance to recover it.  If I try and report this via Bugzilla I get the error message:  The text you entered in the Crash report or crash signature field is too long (259 characters, above the maximum length allowed of 255 characters).  David Lynch Versio

[libreoffice-users] Can I stop Calc altering the formulas I enter?

in "A" to "ACCRINT()", I have to click the tick button in the formula bar rather than hit [enter] to retain the "I" and "A" as I entered them. Is there any way to stop this behaviour and make [enter] act in the same way as clicking the tick

[libreoffice-users] Font size in Formula bar

-GB Calc: threaded Windows 10 David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https

Re: [libreoffice-users] Unable to access offline help in 6.1

/LibreOffice/help/en-US/text/shared/main0108.html?=WRITER=WIN Do you want to submit the bug report or shall I? Dave You go ahead. Thanks. David On 08.08.2018 19:33, David Lynch wrote: I cannot access the offline help in: Version: 6.1.0.3 (x64) Build ID

[libreoffice-users] Unable to access offline help in 6.1

in 6.0.5. David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.o

[libreoffice-users] Unable to install off-line help for 5.4.0.3

rogram and help are x64 versions. After installing, I get the error message: The LibreOffice built-in help is not installed on your computer. Any ideas, please? David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/m

Re: [libreoffice-users] LO Scolling problems under Windows.

ion.org/show_bug.cgi?id=107770> Please add clarification, comment or support. David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoun

Re: [libreoffice-users] Libre Office - 5.3.3

org/show_bug.cgi?id=107770> on Windows 10. David Lynch -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive

Re: [libreoffice-users] Calc: Sluggish response from version 5.3.2.2

On 11/05/2017 11:52, David Lynch wrote: I installed Version: 5.3.2.2 (x64) Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1 Windows 10 yesterday. It seems to be running slowly, particularly scrolling and altering column widths (you can see the latter proceeding in jumps). I am editing

[libreoffice-users] Enhancements to Calc functions

The new functions, TEXTJOIN and CONCAT, have been a great help, allowing me to simplify some spreadsheets. Partly motivated by this success, I have asked for enhancements to some existing Calc functions that I would find useful:

[libreoffice-users] Default column width in Calc

;Width... change to 0.5 cm (doesn't matter when Default value is ticked or not) Enter aaa in a1, ccc in c1. Select columns A, B and C. Double click divider. Column B is 2.26 cm wide. I want it to be 0.5 cm wide. David Lynch Version: 5.1.0.3 Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 Wid

Re: [libreoffice-users] Re: how to make formulas permanently case sensitive?

On 12/05/2015 21:39, Andreas Säger wrote: Am 12.05.2015 um 12:55 schrieb hw: Am 12.05.2015 um 12:45 schrieb hw: Hi, I need, of course, formulars to be case sensitive. This can be set in the options for calc. The option is not saved permanently and every time I open a spreadsheet, I need to

[libreoffice-users] Split Move/Copy Sheet item in sheet tab menu

.* *Please may I have support for this request.* *David Lynch* * -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

[libreoffice-users] Re: Split Move/Copy Sheet item in sheet tab menu

On 18/02/2015 15:04, Kaj wrote: It is that the *default* behaviour is to overwrite the target (and no warning is given). David Lynch The change might be ok, but in which way does that solve your problem? The target is overwritten in any case. Well yes, if you think you still are keeping