Altova Mailing List Archives


Re: SpreadsheetML - auto row height

From: thielen@------.------
To: NULL
Date: 12/16/2004 6:11:00 PM
Hi;

I did:
   <Row ss:AutoFitHeight="0" ss:Height="13.5">
    <Cell ss:StyleID="s21"><Data ss:Type="String">line 

line
line
line
line5</Data></Cell>
    <Cell ss:StyleID="s26"><Data ss:Type="String">fred</Data></Cell>
   </Row>

And only the 1st line is visible.

Any other possibilities?

thanks - dave


"Neil Smith [MVP Digital Media]" wrote:

> Just so I'm satisified we've tried everything possible, can you add
> ss:AutoFitHeight="1" to each row and let me know what happens ?
> 
> Cheers - Neil
> 
> On Thu, 16 Dec 2004 08:01:03 -0800, "David Thielen"
> <thielen@n...> wrote:
> 
> >Hi;
> >
> >The problem is I build the SpreadsheetML file programatically and in this 
> >case I don't know the row height. I am doing that in cases where I can 
> >determine the pixel height of a cell.
> >
> >Also, I'd prefer that Excel use it's auto-fit as it knows exactly how many 
> >pixels of height it needs to display the text - I have to guess at the 
> >inter-line spacing.
> >
> >thanks - dave
> >
> >
> >"Neil Smith [MVP Digital Media]" wrote:
> >
> >> Would it help to set a specific height for those cells which have 5
> >> lines ?
> >> 
> >> Cheers - Neil
> >> 
> >> On Thu, 16 Dec 2004 05:55:04 -0800, "David Thielen"
> >> <thielen@n...> wrote:
> >> 
> >> >Hi;
> >> >
> >> >I do set  ss:WrapText="1" but it still only shows the first two lines of my 
> >> >5 line text.
> >> >
> >> >I do not post to microsoft.public.office.xml because it is not a managed 
> >> >newsgroup.
> >> >
> >> >thanks - dave
> >> >
> >> >
> >> >"Kevin Yu [MSFT]" wrote:
> >> >
> >> >> Hi Dave,
> >> >> 
> >> >> First of all, I would like to confirm my understanding of your issue. From 
> >> >> your description, I understand that you need to set a row to auto-size to 
> >> >> display the text in it. If there is any misunderstanding, please feel free 
> >> >> to let me know.
> >> >> 
> >> >> As far as I know, we can add a ss:WrapText="1" attribute in the Style 
> >> >> element. Here is an example:
> >> >> 
> >> >>   <Style ss:ID="s21">
> >> >>    <Alignment ss:Vertical="Center" ss:WrapText="1"/>
> >> >>   </Style>
> >> >> 
> >> >> Please try to post in microsoft.public.office.xml newsgroup next time to 
> >> >> get a quicker response. I think people in that newsgroup are more familiar 
> >> >> with this. Thanks!
> >> >> 
> >> >> Kevin Yu
> >> >> =======
> >> >> "This posting is provided "AS IS" with no warranties, and confers no 
> >> >> rights."
> >> >> 
> >> >> 
> >> 
> >> 
> 
> 

Disclaimer

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.