# Does Synology spreadsheet support functions like importxml, importhtml, etc?

Synology spreadsheet

I’ve never owned a NAS but thinking of getting one to replace Google drive.

Question:
Does Synology spreadsheet support functions like importxml, importhtml, etc?

If not, any third-party add-on for this?
If not, what happens when that Googlesheet is imported into Synology spreadsheet?
If not, any other NAS that supports these functions?

Synology Office is not supporting functions importxml, importhtml. But you can find a full list of supported functions here:

# SpreadSheet Function List

Category Function Syntax Description
Compatibility COVAR COVAR(array1, array2) Calculates the covariance between two sets of numbers. Learn more
Date and time DATE DATE(year, month, day) Converts a specified year, month, and day into date format. Learn more
Date and time DAY DAY(date) Returns the day of a given date. Learn more
Date and time DAYS DAYS(end_date, start_date) Calculates the number of days between two given dates. Learn more
Date and time DAYS360 DAYS360(start_date, end_date, [method]) Calculates the number of days between two given dates, based on a 360-day year (30 days per month, 12 months per year). Learn more
Date and time EDATE EDATE(start_date, months) Returns the date that is a specified number of months before or after a given date. Learn more
Date and time EOMONTH EOMONTH(start_date, months) Returns the last day of the month, that is a specified number of months before or after a given date. Learn more
Date and time ISOWEEKNUM ISOWEEKNUM(date) Returns the ISO week number of a given date. Learn more
Date and time MONTH MONTH(date) Returns the month of a given date, in the form of an integer. Learn more
Date and time TODAY TODAY() Returns the current date. Learn more
Engineering BIN2DEC BIN2DEC(number) Converts a binary number into a decimal number. Learn more
Engineering BIN2HEX BIN2HEX(number, [places]) Converts a binary number into a hexadecimal number. Learn more
Engineering IMABS IMABS(inumber) Returns the absolute value of a complex number. Learn more
Engineering IMAGINARY IMAGINARY(inumber) Returns the imaginary coefficient of a complex number. Learn more
Engineering IMCONJUGATE IMCONJUGATE(inumber) Returns the complex conjugate of a complex number. Learn more
Engineering IMCSC IMCSC(inumber) Returns the cosecant of a complex number. Learn more
Engineering IMDIV IMDIV(inumber) Divides one complex number by another and returns the quotient. Learn more
Engineering IMPRODUCT IMPRODUCT(inumber1, [inumber2], …) Multiplies all given complex numbers and returns the product. Learn more
Engineering IMREAL IMREAL(inumber) Returns the real coefficient of a complex number. Learn more
Information ERROR.TYPE ERROR.TYPE(error_val) Receives an error value and returns a corresponding number to this error value. Learn more
Logical IF IF(logical_test, value_if_true, [value_if_false]) Returns one value if a condition is true and another if it is false. Learn more
Lookup and reference CHOOSE CHOOSE(index_num, value1, [value2], …) Chooses a value from a list of values according to index. Learn more
Lookup and reference MATCH MATCH(lookup_value, lookup_array, [match_type]) Returns the relative position of a specified value in a range of cells. Learn more
Math and trigonometry ATANH ATANH(number) Calculates the inverse hyperbolic tangent of a given number. Learn more
Math and trigonometry DEGREES DEGREES(angle) Converts radians into degrees. Learn more
Math and trigonometry FACT FACT(number) Calculates the factorial of a number. Learn more
Math and trigonometry INT INT(number) Rounds a real number down to the nearest integer. Learn more
Math and trigonometry LOG LOG(number, [base]) Calculates the logarithm of a number to a specified base. Learn more
Math and trigonometry LOG10 LOG10(number) Calculates the base 10 logarithm of a number. Learn more
Math and trigonometry PI PI() Returns the value of the mathematical constant π (pi), accurate to 10 digits. Learn more
Math and trigonometry PRODUCT PRODUCT(number1, [number2], …) Multiplies all given numbers and returns the product. Learn more
Math and trigonometry RADIANS RADIANS(angle) Converts degrees into radians. Learn more
Math and trigonometry RAND RAND() Returns a random number between 0 (inclusive) and 1 (exclusive). Learn more
Math and trigonometry RANDBETWEEN RANDBETWEEN(bottom, top) Returns a random integer number between specified numbers every time the spreadsheet is opened. Learn more
Math and trigonometry ROUND ROUND(number, num_digits) Rounds a number to a specific number of decimal places. Learn more
Math and trigonometry SIGN SIGN(number) Returns the sign of a given number. Learn more
Math and trigonometry SUM SUM(number1, [number2],…) Adds all given numbers and returns the sum. Learn more
Math and trigonometry SUMIF SUMIF(range, criteria, [sum_range]) Adds the values in a range according to a specified criteria. Learn more
Statistical AVERAGE AVERAGE(number1, [number2], …) Returns the average value (arithmetic mean) of its arguments, ignoring text and blank cells. Learn more
Statistical AVERAGEIF AVERAGEIF(criteria_range, criterion, [average_range]) Returns the average value (arithmetic mean) of a range according to a specified criteria. Learn more
Statistical COUNT COUNT(value1, [value2], …) Counts the number of numeric values in a range. Learn more
Statistical COUNTA COUNTA(value1, [value2], …) Counts the number of non-blank values in a range. Learn more
Statistical COUNTIF COUNTIF(range, criteria) Counts the number of cells within a range according to a specified criteria. Learn more
Statistical MAX MAX(number1, [number2], …) Returns the maximum value in a set of numeric data. Learn more
Statistical MIN MIN(number1, [number2], …) Returns the minimum value in a set of numeric data. Learn more
Text FIND FIND(find_text, within_text, [start_num]) Returns the first position of a text string within another text string, case sensitive. Learn more
Text LEN LEN(text) Returns the number of characters in a text string, spaces included. Learn more
Text SUBSTITUTE SUBSTITUTE(text, old_text, new_text, [instance_num]) Substitutes new text for old text in a text string. Learn more

Posted in Uncategorized