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

Last updated on 27 Sep 2019 📧 Subscribe

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


If you like this service, please consider supporting us.
We use affiliate links on the blog allowing NAScompares information and advice service to be free of charge to you. Anything you purchase on the day you click on our links will generate a small commission which is used to run the website. Here is a link for Amazon and B&H. You can also get me a ☕ Ko-fi or old school Paypal. Thanks! To find out more about how to support this advice service check HERE   If you need to fix or configure a NAS, check Fiver   Have you thought about helping others with your knowledge? Find Instructions Here  

☕ WE LOVE COFFEE ☕

Or support us by using our affiliate links on Amazon UK and Amazon US
     

locked content ko-fi subscribe

DISCUSS with others your opinion about this subject.
ASK questions to NAS community
SHARE more details what you have found on this subject
CONTRIBUTE with your own article or review. Click HERE
IMPROVE this niche ecosystem, let us know what to change/fix on this site
EARN KO-FI Share your knowledge with others and get paid for it! Click HERE

ASK YOUR QUESTIONS HERE!