Difference between revisions of "Clear all data values"

m (Text replacement - "XLCubed" to "FluenceXL")
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
New in [[Version 7.5]] - it is possible to clear all the data values from a workbook. Go to XLCubed -> Extras -> Clear all data values. This does the following:
+
New in [[Version 7.5]] - it is possible to clear all the data values from a workbook. Go to FluenceXL -> Extras -> Clear all data values. This does the following:
  
 
# Clears all grids
 
# Clears all grids
# Sets any XLCubed Formulae to "Working.."
+
# Sets any FluenceXL Formulae to "Working..."
  
 
The workbook can then be saved or published. For a saved workbook the numbers will only be re-retrieved once the workbook is loaded and the grids & formulae are refreshed. For a published report, the published file will not contain any data and the numbers will only be retrieved after the report is viewed in Web Edition
 
The workbook can then be saved or published. For a saved workbook the numbers will only be re-retrieved once the workbook is loaded and the grids & formulae are refreshed. For a published report, the published file will not contain any data and the numbers will only be retrieved after the report is viewed in Web Edition
 +
 +
 +
==See Also==
 +
* [[Web Publishing]]
 +
 +
[[Category:Web Publishing]]

Latest revision as of 08:34, 4 July 2023

New in Version 7.5 - it is possible to clear all the data values from a workbook. Go to FluenceXL -> Extras -> Clear all data values. This does the following:

  1. Clears all grids
  2. Sets any FluenceXL Formulae to "Working..."

The workbook can then be saved or published. For a saved workbook the numbers will only be re-retrieved once the workbook is loaded and the grids & formulae are refreshed. For a published report, the published file will not contain any data and the numbers will only be retrieved after the report is viewed in Web Edition


See Also