[Solved] Function name changed after opening with Excel

[dwellman]

I am using the DAYSINMONTH() function in my spreadsheet. When I open the file, the function name is changed to "org.openoffice.daysinmonth()" which returns "#NAME?". Why is it doing this. This is on a Windows 10 Home OS.

The answer was that the file was originally an Excel spreadsheet (or somewhere along the way it was converted from one). I created the file from scratch and the problem no longer occurs. Thanks MrProgrammer.

[MrProgrammer]

I am using the DAYSINMONTH() function in my spreadsheet. When I open the file, the function name is changed to "org.openoffice.daysinmonth()" which returns "#NAME?".

Did you break the spreadsheet by opening/saving it with Excel? You must use Open Office if you want to use that function in your spreadsheet.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Villeroy]

A compatible replacement for DAYSINMONTH(A1)

Code: Select all

=DAY(DATE(YEAR(A1);MONTH(A1)+1;1)-1)

subtracts one day from the first of next month and extracts the day portion.

[Zizi64]

This function is only available if the Analysis AddIn is installed.
...
Issues:

DAYSINMONTH is not part of the forthcoming ODFF international standard, and should not be regarded as portable. An alternative would be DAY(DATE(YEAR(date);MONTH(date)+1;0)).

https://wiki.openoffice.org/wiki/Docume ... H_function