XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » what is ' ss:Formula="=SUM(R[-3]C:R[-2]C)" ' in Excel Spread sheet XML format
Conferences Close Tree View
+ Stylus Studio Feature Requests (1126)
- Stylus Studio Technical Forum (13845)
-> + Skipping invalid records on SQ... (2)
-> + EDI XML Converters Inserting "... (2)
-> + Trying to use EDI to XSD docum... (5)
-> + Specifying EDI Delimiters (2)
-> + Defining 'connection string' f... (9)
-> + Help Programatically Convertin... (2)
-> + Using adapter URL in pipeline. (7)
-> + How to enable EDI functionalit... (2)
-> + Unable to open file with '%2F'... (2)
-> + How to create a dependency gra... (2)
-> + If block (2)
-> + Mapping multiple files within ... (7)
-> + StylusStudio vs Altova vs BizT... (4)
-> + Command line execution (7)
-> + CSS and Styling in X15 (2)
-> + Ignores debug breakpoints in X... (5)
-> + Cursor dissapearing in Text vi... (5)
-> + compile error xquery java styl... (3)
-> + Stylus Studio Setup: Applicati... (10)
-> + Stylus StudioX15 Crashing whe... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (244)
+ XSLT Help and Discussion (7447)
+ XQuery Help and Discussion (1870)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (361)
+ Stylus Studio Announcements (113)
Topic  
Postnext
karthik veerajSubject: what is ' ss:Formula="=SUM(R[-3]C:R[-2]C)" ' in Excel Spread sheet XML format
Author: karthik veeraj
Date: 07 Nov 2005 07:56 AM

Plz Help me out.

I need to calculate the sum dynamically. But I'm not gettiing what is -3 and -2 in this formula ss:Formula="=SUM(R[-3]C:R[-2]C)".


Suppose if I want calculate the sum dynamically How can i do that?

Usually in Excel sheet we give = Sum(ColumnNameRow1: ColumnNameRow10)

How could i replace the same using ExcelSpreadSheet ?

Please reply me soon. I need urgently.
Posttop
Clyde KesselSubject: what is ' ss:Formula=
Author: Clyde Kessel
Date: 07 Nov 2005 10:51 AM
Karthik,

The syntax you typed appears to be correct. If you send the .xml file as an attachment, we might be able to see the problem.

Thanks.
Clyde
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.