Search found 12 matches

by mikekaganski
Wed Nov 15, 2023 10:21 am
Forum: Calc
Topic: [Solved] Unexpected result of division by days
Replies: 18
Views: 1785

Re: [Solved] Failure to Divide??

@karolus: :-D I'm sorry, but it seems to be comparing oranges to apples: Whichever change you refer to, that change had its justification - but then you can't compare *that* justification (made by whom?) to a justification mentioned here by @MrProgrammer, and say that there is a discrepancy in them....
by mikekaganski
Wed Nov 15, 2023 8:54 am
Forum: Calc
Topic: [Solved] Unexpected result of division by days
Replies: 18
Views: 1785

Re: [Solved] Failure to Divide??

I find it funny to see heated discussion of someone's personal responses in the bug; the closing there was a personal opinion, not something set in stone. The documentation should be fixed, it is not something difficult (the energy spent here already would be more than enough to propose the fix to t...
by mikekaganski
Mon Dec 26, 2022 1:27 pm
Forum: Macros and UNO API
Topic: [Solved] Add all underlined words to dictionary
Replies: 13
Views: 18624

Re: [Solved] Add all underlined words to dictionary

I get the error "Unsupported datatype" in line 31 (LibreOffice 7.0) sListaPalabras = sListaPalabras + oTextCursor.getString() + Chr(13) This is because tdf#124605 was fixed in LibreOffice 6.3. The sListaPalabras variable needs to be initialized to an empty string prior to use in "sum...
by mikekaganski
Wed Sep 14, 2022 8:07 am
Forum: Macros and UNO API
Topic: [Calc][Python] Addin inconsistency with string array on LibO
Replies: 7
Views: 3048

Re: [Calc][Python] Addin inconsistency with string array on LibO

Zizi64 wrote: Wed Sep 14, 2022 7:49 am How to create that .rdb file?
What is its function in the extension?
Please search for "rdb" in https://wiki.documentfoundation.org/Doc ... Components.
by mikekaganski
Tue Sep 13, 2022 11:59 am
Forum: Macros and UNO API
Topic: [Calc][Python] Addin inconsistency with string array on LibO
Replies: 7
Views: 3048

Re: [Calc][Python] Addin inconsistency with string array on LibO

This is a regression in LibreOffice 5.4; it worked OK in 5.3. Filed tdf#150926.
by mikekaganski
Wed Dec 29, 2021 10:00 am
Forum: Macros and UNO API
Topic: Missing parameter problem & its evaluation
Replies: 23
Views: 16118

Re: Missing parameter problem & its evaluation

Optional parameters are of the Error value type (10) so we could also put: Sub foo(optional bar) if vartype(bar) =10 then bar = true end sub Note that errors are not limited to "missing", and there may be valid cases of passing errors as arguments; so IsMissing is more specific and correc...
by mikekaganski
Tue Aug 03, 2021 6:07 pm
Forum: Macros and UNO API
Topic: Missing parameter problem & its evaluation
Replies: 23
Views: 16118

Re: Missing parameter problem & its evaluation

FTR: 1. Basic behavior WRT Optional arguments is explained in https://git.libreoffice.org/core/+/8e323fcacebad1afe9d867b846722a6b9bf20f78: In LO Basic, optional parameters are allowed, but without any default values. Missing parameters will not be initialized to their respective default values of it...
by mikekaganski
Sun Aug 23, 2020 11:34 am
Forum: Writer
Topic: [Tutorial] Differences between Microsoft and AOO/LO files
Replies: 6
Views: 62604

Re: [Tutorial] Differences between Writer and MS Word files

If you use different Page Styles in a document, and you save the file as a .doc, you will often run into seemingly endless problems with page numbering, headers, footers and page styles. The problems appear to get worse if the .doc file is edited by both AOO and MS Word. This seems to be because AO...
by mikekaganski
Mon Feb 24, 2020 2:31 pm
Forum: LibreOffice
Topic: [Tutorial] How to fix SAXParse error in LibreOff .docx files
Replies: 4
Views: 57830

Re: [Tutorial] How to fix SAXParse error in LibreOff .docx f

Sigh. This partially useful tutorial still has all these nonsensical statements after almost three years! These problems seem only to arise in .docx files saved by LibreOffice. This only appears in LibreOffice, because the same erroneous data is handled silently by AOO, which truncates the stream af...
by mikekaganski
Mon Jul 29, 2019 3:53 am
Forum: Code Snippets
Topic: [Python] Array Sort add-in function.
Replies: 17
Views: 32192

Re: [Python] Array Sort add-in function.

This fixes the code to be compatible with Python 3 (used in LibreOffice since version 4.0): No. There is something more than that. Still returns #VALUE! while working with AOO. Hmm... I suppose you have made some mistake while applying the diff from my post (and I must admit that the diff formatted...
by mikekaganski
Sun Jul 28, 2019 1:38 pm
Forum: Code Snippets
Topic: [Python] Array Sort add-in function.
Replies: 17
Views: 32192

Re: [Python] Array Sort add-in function.

This fixes the code to be compatible with Python 3 (used in LibreOffice since version 4.0): # SortArray Calc Add-in implementation. NUMBER_RE = re.compile(r'[1-9]\d*') +# unicode from Python 2 is str in Python 3 +try: + unicode +except NameError: + unicode = str + class PySortImpl( unohelper.Base, X...
by mikekaganski
Mon Oct 30, 2017 12:48 pm
Forum: Extensions
Topic: [Solved] SpecialCells on OOo 3.3.0 / LO 3.3.0
Replies: 7
Views: 9898

Re: [Solved] SpecialCells on OOo 3.3.0 / LO 3.3.0

@Villeroy: Thank you for your extension! I have tried it with LibreOffice 5.4, and it turned out that there were some issues with SpecialCells.py: 1. It has non-ASCII character in its license header, and its encoding is not UTF-8 2. Inconsistencies in space and tab usage in indentation 3. Using lega...