Openoffice calc text function11/11/2023 ![]() Supplement: OpenOffice 3.2.0 did not reproduce the described behaviour on a second try. We cannot rely on functions or processes distorting logic to such an extent.ħ: My tests with AOO 3.2.0 Calc and with LibO 4.3.5 Calc didn’t show any differences with respect to the formula under discussion. But “32-Mar-14” is neither rejected as illegal (only 31 days in march!) nor interpreted as (next day after the 31st of march) consequently but as. ![]() Same with “28-Mar-14” interpreted as an abbreviation. See also 6:ĥ: It is not clear whether the values polled from D39 and ‘resultsYear’ ( as we are told) are text or numeric.Ħ: Assuming the concatenated string is “2”, it is an amazing (obviously old) malfunction of LibreOffice (V4.3.5.1 used) and OpenOffice (V3.2.0 Portable used) as well that this string is actually accepted under US locale setting representing the (ISO 8601). It must be by default, however, as it cannot be added to the ‘Date acceptance patterns’.Ĥ: A Calc document as heavily depending on fragile constructs should be redesigned before going to the level of adapting a single formula. This also applies to OO.ģ: A gingerly rectified version of the formula can only work as intended if the running LibO will accept the pattern “D-MMM-Y” as a date. 1: The formula is not correct with regard to the specifications of the used functions. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |