English 中文(简体)
共同公式扩展
原标题:excel shared formula expansion

我将开放式图书馆从C#改为Excel文档。

我的一项要求是能够显示每个有一间牢房的确切公式。 开放式反洗钱法编码文件使用“共享公式”,以减少档案规模。

与此类似:

D3 : <x:f t="shared" ref="D3:D6" si="1" >D2+C3</x:f><x:v >130</x:v>
D4 : <x:f t="shared" si="1"  /><x:v >136</x:v>
D5 : <x:f t="shared" si="1"  /><x:v >141</x:v>
D6 : <x:f t="shared" si="1"  /><x:v >147</x:v>

在上述例子(D2+C3)中,它有一个相当简单的根基公式,而且显然可以任意混淆。

我想知道的是,是否有一部图书馆或范例法典,其中含有任何低层(如D4、D5、D6)和回归“未共享”模式?

例如,就D6而言,这将归还“D5+C6”

最佳回答

并非易事,但可以做。 我要做的是使用林克。

首先,我想到的是<代码><v:f>Value <>“和<v:f>@t = “共有”。 然后,我将作一个<代码>。 查阅<代码>。 内容After Self where <v:f>.Value = “ and <v:f>@t =“共有”

一旦我有这个数字(Of XElement),我就将使用第一个1公式的标语,然后使用<>每个,为每个XElement设定一个新的公式,使电池的相对价值增加。

采用C#和LINQ撰写复种性子或许是最佳的I ve 。

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签