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 |
Where to Buy a Product | |||
VISIT RETAILER ➤ | |||
VISIT RETAILER ➤ | |||
VISIT RETAILER ➤ | |||
VISIT RETAILER ➤ | |||
VISIT RETAILER ➤ |
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 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
Private 🔒 Inner Circle content in last few days :
(Early Access) The BEST Photographer and Video Editor NAS (2024)
(Early Access) COOL NAS UPGRADES (You might Not Know About)
(Early Access) UGREEN NAS SERIES - SHOULD YOU BUY?
(Early Access) DIY NAS - The Cost of Building a Synology NAS?
(Early Access) The Best DIY NAS Builds for Under $500
(Early Access) DIY NAS vs Lockerstor Gen 3 - IS IT WORTH $1299 ???
(Early Access) Lockerstor Gen 3 Series - SHOULD YOU BUY ONE?
(Early Access) Asustor ADM 5 Software Review - Should Synology Be Worried?
(Early Access) Best 8-Bay NAS of 2024
(Early Access) Best 4-Bay NAS of 2024
(Early Access) Best 2-Bay NAS of 2024
(Early Access) Best Value NAS of 2024 - SAVE SOME MONEY!
Access content via Patreon or KO-FI
(Early Access) The BEST Photographer and Video Editor NAS (2024)
(Early Access) COOL NAS UPGRADES (You might Not Know About)
(Early Access) UGREEN NAS SERIES - SHOULD YOU BUY?
(Early Access) DIY NAS - The Cost of Building a Synology NAS?
(Early Access) The Best DIY NAS Builds for Under $500
(Early Access) DIY NAS vs Lockerstor Gen 3 - IS IT WORTH $1299 ???
(Early Access) Lockerstor Gen 3 Series - SHOULD YOU BUY ONE?
(Early Access) Asustor ADM 5 Software Review - Should Synology Be Worried?
(Early Access) Best 8-Bay NAS of 2024
(Early Access) Best 4-Bay NAS of 2024
(Early Access) Best 2-Bay NAS of 2024
(Early Access) Best Value NAS of 2024 - SAVE SOME MONEY!
Access content via Patreon or KO-FI
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