Search found 12 matches
- 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....
- 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...
- 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...
- 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
- 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.
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...