silverlight 载入含有图片的EXCEL2007文件有问题

iceman · iceman

回复 9楼hyqangel的帖子

hyqangel 你好，

图形指的是否为 Excel 中的 Shape？还是 Chart ？

我在确认之后回复。

iceman · iceman

回复 10楼hyqangel的帖子

给你带来不便很抱歉，关于你的问题我们会尽快调查找出解决或者替代方法。如果是产品上的不足，我们会向产品组提交。感谢你的反馈。

"带图的电子表格载入系统后，全部消失"
不好意思，这就话的意思是 Cell 中的内容也消失了，还是指图片消失了呢？

iceman · iceman

回复 12楼iceman的帖子

hyqangel 你好，

Chart 图表功能将作为 10 月发布版中一大亮点功能发布。
Shape 当前版本不支持，已经列入 wish list 列表中，目前还没有明确的发布计划。

谢谢

iceman · iceman

回复 6楼hyqangel的帖子

hyqangel 你好，
关于直接打印可以通过一下方法自定义实现：

private void btnPrint_Click(object sender, RoutedEventArgs e)
{
this.Cursor = System.Windows.Input.Cursors.Wait;
SpreadSheetPrinter ssp = new SpreadSheetPrinter(this.gcSpreadSheet1);
ssp.PrintDocument.EndPrint += (ss, ee) => { this.Cursor = System.Windows.Input.Cursors.Arrow; };
ssp.PrintActiveSheet("SpreadSheet Print");
}
public class SpreadSheetPrinter
{
GcSpreadSheet printSource;
PrintDocument pd;
string documentName;
Grid printVisual;
Grid container;
TextBlock header;
GcSpreadSheet printPreview;
TextBlock footer;
int vPageBreak;
int vNextPageBreak;
int hPageBreak;
int hNextPageBreak;
double pageWidth;
double pageHeight;
public SpreadSheetPrinter(GcSpreadSheet spread)
{
printSource = spread;
pd = new PrintDocument();
pd.PrintPage += new EventHandler<PrintPageEventArgs>(pd_PrintPage);
this.printVisual = new Grid();
this.container = new Grid();
this.container.RowDefinitions.Add(new RowDefinition());
this.container.RowDefinitions.Add(new RowDefinition());
this.container.RowDefinitions.Add(new RowDefinition());
this.printVisual.Children.Add(this.container);
this.header = new TextBlock();
this.header.FontSize = 20;
this.header.VerticalAlignment = System.Windows.VerticalAlignment.Top;
this.header.HorizontalAlignment = System.Windows.HorizontalAlignment.Center;
this.container.Children.Add(this.header);
this.footer = new TextBlock();
this.footer.VerticalAlignment = System.Windows.VerticalAlignment.Bottom;
this.footer.HorizontalAlignment = System.Windows.HorizontalAlignment.Center;
this.container.Children.Add(this.footer);
this.footer.SetValue(Grid.RowProperty, 2);
this.printPreview = new GcSpreadSheet();
this.container.Children.Add(this.printPreview);
this.printPreview.SetValue(Grid.RowProperty, 1);
this.printPreview.VerticalAlignment = System.Windows.VerticalAlignment.Top;
this.printPreview.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
}
public PrintDocument PrintDocument
{
get { return pd; }
}
public void PrintActiveSheet(string documentName)
{
MemoryStream ms = new MemoryStream();
this.printSource.SaveXml(ms);
ms.Seek(0, System.IO.SeekOrigin.Begin);
this.printPreview.OpenXml(ms);
ms.Close();
// hide scrollbar tabstrip border
this.printPreview.VerticalScrollBarVisibility = ScrollBarVisibility.Hidden;
this.printPreview.HorizontalScrollBarVisibility = ScrollBarVisibility.Hidden;
this.printPreview.TabStripVisibility = System.Windows.Visibility.Collapsed;
this.printPreview.BorderThickness = new Thickness(0);
// hide selection
var sheet = this.printPreview.ActiveSheet;
sheet.RowCount++;
sheet.ColumnCount++;
sheet.FrozenTrailingColumnCount = 1;
sheet.FrozenTrailingRowCount = 1;
sheet.SetRowVisible(sheet.RowCount - 1, SheetArea.Cells, false);
sheet.SetColumnVisible(sheet.ColumnCount - 1, SheetArea.Cells, false);
sheet.SetActiveCell(sheet.RowCount - 1, sheet.ColumnCount - 1, true);
vPageBreak = 0;
vNextPageBreak = -1;
hPageBreak = 0;
hNextPageBreak = -1;
pageWidth = 0;
pageHeight = 0;
this.documentName = documentName;
pd.Print(documentName);
}
void pd_PrintPage(object sender, PrintPageEventArgs e)
{
var sheet = this.printPreview.ActiveSheet;
var margin = sheet.PrintInfo.Margin;
// set control position
this.container.Margin = new Thickness(margin.Left, margin.Top, margin.Right, margin.Bottom);
this.container.RowDefinitions[0].Height = new GridLength(margin.Header);
this.container.RowDefinitions[2].Height = new GridLength(margin.Footer);
this.header.Text = this.documentName;
this.footer.Text = string.Format("page {0}", this.pd.PrintedPageCount + 1);
// scroll to current page
this.printPreview.ShowRow(0, vPageBreak, VerticalPosition.Top);
this.printPreview.ShowColumn(0, hPageBreak, HorizontalPosition.Left);
// calc current page size, and find next page break
if (pageHeight == 0) // current page height is not calc yet
{
for (int i = vPageBreak; i < sheet.RowCount; i++)
{
double rowHeight = sheet.GetActualRowHeight(i, SheetArea.Cells) * sheet.ZoomFactor;
if ((pageHeight + rowHeight) > (e.PrintableArea.Height - margin.Bottom - margin.Top - margin.Header - margin.Footer))
{
vNextPageBreak = i;
break;
}
pageHeight += rowHeight;
}
if (this.printPreview.Height != pageHeight)
{
this.printPreview.Height = pageHeight;
}
}
if (pageWidth == 0) // current page width is not calc yet
{
for (int i = hPageBreak; i < sheet.ColumnCount; i++)
{
double columnWidth = sheet.GetActualColumnWidth(i, SheetArea.Cells) * sheet.ZoomFactor;
if ((pageWidth + columnWidth) > (e.PrintableArea.Width - margin.Left - margin.Right))
{
hNextPageBreak = i;
break;
}
pageWidth += columnWidth;
}
if (this.printPreview.Width != pageWidth)
{
this.printPreview.Width = pageWidth;
}
}
e.PageVisual = this.printVisual;
// prepare for next page
if (sheet.PrintInfo.PageOrder == PrintPageOrder.DownThenOver)
{
if (vNextPageBreak != -1) // has next page in vertical
{
vPageBreak = vNextPageBreak;
vNextPageBreak = -1;
pageHeight = 0;
e.HasMorePages = true;
}
else if (hNextPageBreak != -1)
{
hPageBreak = hNextPageBreak;
hNextPageBreak = -1;
pageWidth = 0;
pageHeight = 0;
vPageBreak = 0;
vNextPageBreak = -1;
e.HasMorePages = true;
}
}
else
{
if (hNextPageBreak != -1)
{
hPageBreak = hNextPageBreak;
hNextPageBreak = -1;
pageWidth = 0;
e.HasMorePages = true;
}
else if (vNextPageBreak != -1)
{
vPageBreak = vNextPageBreak;
vNextPageBreak = -1;
pageWidth = 0;
pageHeight = 0;
hPageBreak = 0;
hNextPageBreak = -1;
e.HasMorePages = true;
}
}
}
}

复制代码

		自动登录	找回密码
密码			立即注册

silverlight 载入含有图片的EXCEL2007文件有问题

活字格认证

微信认证勋章

元老葡萄

silverlight 载入含有图片的EXCEL2007文件 有问题

活字格认证

微信认证勋章

元老葡萄

silverlight 载入含有图片的EXCEL2007文件有问题