Sum of requests


#1

Hi Laurence,

I have to resume about some features:

1. chart.NSeries[i].Line.Weight = WeightType.MediumLine;
a) The line get colored black though color before was red or some other color
b) The DataMarkers appears though I’m using “ChartType.Line” and not “ChartType.LineWithDataMarkers”.
c) The DataMarkers get colored pink though “chart.NSeries[i].Line.Color = Color.Red;” -> Either DataMarkers in color of line [by ChartType=LineWithDataMarkers] or invisible or a method / variable to color manual.

2. Reading conditional formatting from designerfile for formulafields in generated sheets.

For these features I need to know a timeline within it will be fixed. I have to give out this timeline, so please call a date which is real.

Regards, Stefan


#2

Hi Stefan,

About 1, it’s fixed in the latest hotfix. Please download it and have a try.

About 2, this feature is far complex than I had thought before, so I have to delay to the mid of June.


#3

Hi Laurence,

I tested new release at the moment but still getting not the output I need.

I refer to my post of yesterday

1a)
My charttype is ChartType.Line. I have written following code:
for(int i = 0; i < chart.NSeries.Count; i ++)
{
chart.NSeries[i].Line.Weight = WeightType.MediumLine;
}
All lines get the color black! So I can’t differ with my legend which line is for which data.
If I set NO Line.Weight, the lines get automatic a color assigned. This “autocolor” feature get’s lost by setting Line.Weight!

1b)
fixed

1c)
My charttype is ChartType.LineWithDataMarkers. I’m using follwing code:
chart.NSeries[1].Line.Color = Color.Red;
The line gets the color red but the “DataMarkers” have color pink (pink is this line when not setting explicit a color = autocolor). I want to have the DataMarkers in same color as the line.

2)
Conditional formatting: Can Aspose.Excel set conditional formatting by code? I mean, can I write cell.ConditionalStyle.Font.Color = Color.Red ?
The question for my example is just, which value is for the conditional format because of no formula is deposited.
For me it would reach to set cellstyle for negative formula results, so if this can be easier included you can think about it if nobody else need this feature…

Thanks for support!!!

Regards, Stefan


Please have I try on your machine. I use WinXP Pro & Excel XP. FileFormatType.Default.



#4

Hi Stefan,

1a) Yes. Currently after setting the width, all line color is set to black by default. You can set the line color by your own code.

1c) I will check this again.

2) We will supply code to set conditionla formatting. But it’s far more complex than your suggested code. You can refer to MS Excel VBA help for conditional formatting issue.


#5

Hi Laurence,

the conditionla formatting takes some time, OK!

But 1a) is not dissatisfying for me.
Can you please add the feature “autocolor” also by setting Line.Weight? This is because of I don’t know how many rows and thus lines I will get in my excel-sheets / diagramms and hold about 20 or 30 colors for it is not very fine.

Regards, Stefan


#6

Hi Stefan,

About 1a, you are right. It’s very inconvennence to set so many colors. Could you give me one or two days to investigate this issue?


#7

Hi Laurence,

investigate this prob and solve it and I’m happy!
End of week is soon enough…

-Stefan


#8

Hi Stefan,

1A is fixed. Please download hotfix 1.9.4 and have a try.


#9

Hi Laurence,

1a) is fixed, your right!
1a add-on) In ChartType.LineWithDataMarkers this functionality is not included yet. If you fix the DataMarkers.Color to Line.Color (1c) problem, please add feature of 1a) into ChartType.LineWithDataMarkers.

Thanks for your quick support!!!

-Stefan