RE: gnumeric-list Digest, Vol 18, Issue 6

[<anna madhusudhanan wipro com>]

Hi,
  Herewith I have attached the pseudo code .please look this one and
help me. In the xslt code we set the color, etc attribute. I am getting
the excel sheet , but there is no hyperlink in the anna.com . it
displays simple text. How can I solve this problem. Please need help for
solve this problem.


*********************XML CODE LOOK LIKE THIS*************** 

<?xml version="1.0" encoding="UTF-8"?>
........................
........................
........................
<level1>
   <level2>
     <text>THE TEXT AREA <text>
     <url>anna.com</url>
   </level2>
</level1>
........................
........................


*********************XSLT CODE LOOK LIKE THIS***************
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
    xmlns:gmr="http://www.gnome.org/gnumeric/v7";>
  ........................
  ........................
   
 <gmr:Workbook>
    <gmr:SheetNameIndex>
      <gmr:SheetName>User Report</gmr:SheetName>
    </gmr:SheetNameIndex>
    <gmr:Sheets>
      <gmr:Sheet>
        <gmr:Name>User Report</gmr:Name>
        <gmr:MaxCol>3</gmr:MaxCol>
        <gmr:MaxRow>50</gmr:MaxRow>
        <gmr:Styles>
          <gmr:StyleRegion startCol="0" startRow="0" endCol="10"
endRow="5">
              <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="0:0:0"
PatternColor="0:0:0 " Format="General">

                <gmr:Font Unit="9" Bold="0" Italic="0" Underline="0"
StrikeThrough="0">Helvetica</gmr:Font>

            </gmr:Style>
           </gmr:StyleRegion>
         </gmr:Styles>
         <gmr:Cells>
           <gmr:Cell Row="3" Col="0" ValueType="60">
             <xsl:value-of select="text"/>
           </gmr:Cell>
        </gmr:Cells>   
         ........................
         ........................
         ........................
        ........................

 

Thanks and regards

Anna Madhusudhanan

 

-----Original Message-----

From: Jody Goldberg [mailto:jody gnome org] 

Sent: Friday, October 07, 2005 10:48 PM

To: Anna Madhusudhanan (WT01 - Technology,Media,Transportation&Services)

Cc: gnumeric-list gnome org

Subject: Re: getting problem with version 7(DON'T KNOW HOW TO DIAPLY

 

On Fri, Oct 07, 2005 at 10:08:43PM +0530, anna madhusudhanan wipro com
wrote:

> I am using standard XML? Is there any difference between .gnumeric xml


> format and standard XML format?

 

xml is a metaformat.  Gnumeric uses one layout. OpenDoc uses a different
layout, and SpreadsheetML uses yet another.  An xml parser can parse and
manipulate all of them, but it has not idea of 'spreadsheet'.  To get
that level of application logic something has to understand the xml
format.

 

-----Original Message-----

From: Jody Goldberg [mailto:jody gnome org] 

Sent: Friday, October 07, 2005 10:48 PM

To: Anna Madhusudhanan (WT01 - Technology,Media,Transportation&Services)

Cc: gnumeric-list gnome org

Subject: Re: getting problem with version 7(DON'T KNOW HOW TO DIAPLY

 

On Fri, Oct 07, 2005 at 10:08:43PM +0530, anna madhusudhanan wipro com
wrote:

> I am using standard XML? Is there any difference between .gnumeric xml


> format and standard XML format?

 

xml is a metaformat.  Gnumeric uses one layout. OpenDoc uses a different
layout, and SpreadsheetML uses yet another.  An xml parser can parse and
manipulate all of them, but it has not idea of 'spreadsheet'.  To get
that level of application logic something has to understand the xml
format.