Tuesday, February 20, 2024
Tip of the Day: Enhanced Formula Detection for Excel Exports
Product.......: R:BASE 11
Build.........: 11.0.1.40214 or higher
Section.......: File Gateway
Keywords......: Export, Excel, Formula, Equal Character
Did you know that data exports to Excel have been enhanced to prevent formulas from being incorrectly evaluated?
A new DETECT_FORMULA (ON/OFF) parameter, which controls the evaluation of equal characters in table values, has been implemented.
When DETECT_FORMULA is ON (default), equal characters are evaluated as formulas, where spreadsheet cells can be loaded with calculations (e. g. "=SUM(E2:E4").
When equal characters exist in table values that are not actual formulas, formula detection should be turned off; DETECT_FORMULA OFF. Otherwise, errors may be encountered when equal characters in table values are incorrectly evaluated as a formula.
GATEWAY EXPORT XLS ApplicationReview.xls +
SELECT * FROM ContactAppReview +
OPTION OPTION COL_NAMES ON +
|TAB_NAME Contacts +
|DETECT_FORMULA OFF
|SHOW_PROGRESS ON
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
-- Tip of the Day: Enhanced Formula Detection for Excel Exports
Product.......: R:BASE 11
Build.........: 11.0.1.40214 or higher
Section.......: File Gateway
Keywords......: Export, Excel, Formula, Equal Character
Did you know that data exports to Excel have been enhanced to prevent formulas from being incorrectly evaluated?
A new DETECT_FORMULA (ON/OFF) parameter, which controls the evaluation of equal characters in table values, has been implemented.
When DETECT_FORMULA is ON (default), equal characters are evaluated as formulas, where spreadsheet cells can be loaded with calculations (e. g. "=SUM(E2:E4").
When equal characters exist in table values that are not actual formulas, formula detection should be turned off; DETECT_FORMULA OFF. Otherwise, errors may be encountered when equal characters in table values are incorrectly evaluated as a formula.
GATEWAY EXPORT XLS ApplicationReview.xls +
SELECT * FROM ContactAppReview +
OPTION OPTION COL_NAMES ON +
|TAB_NAME Contacts +
|DETECT_FORMULA OFF
|SHOW_PROGRESS ON
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/957831637.1236961.1708429358891%40email.ionos.com.
