Comments by PaulaJoannAllen (Top 44 by date)

Sorry about that. I will do that but the real solution resulted from the comment by OriginalGriff, which I accepted, it helped with the right search phrase. You are right I should of waited until I completed commenting the code.

For deleting the sheet, I don't have it turned off in either place. I do for saving the workbook.

I gave up on it and did what I needed another way. Thanks for your help. If you put something as an answer to the question, I will accept it as solved.

I have done that, and I even changed the name of the inserted sheet from Sheet1 to Sheet2. I can see no reason why it should not work.

I solved it by not hiding the main form as you suggested, not showing the subform, and on closing the workbook I run a routine called in the before app_WorkbookBeforeClose event. I think it is solved with your help.

The problem is not showing the main form that was hidden; I can do that with a close button. The problem is when they click on the 'X' of the excel sheet; I want to close the subform automatically and show the main form that was hidden. I agree that I was going about it the wrong way, but I don't know where to find documentation on this. Maybe I need to insert a macro in the excel sheet, being still a newbie I just don't know.

I will look into that

According to the Microsoft documentation, you can embed one Tuple inside another. I can get s single one working but not when I combine two into one.

The problem was after the book was closed, I did not re-initialized the worksheet also

Yes, excel is still running.
No, I don't do any special properties.

excelFileName = "Food Pantry Registry.xlsx";

The trouble is when the "Food Pantry Registry.xlsx" is closed by the user, so it needs to be reopened.

Works like a charm, thank you.

The starting order is Totals, Dec, Nov, Oct ...., I need the order to be Totals, Jan, Feb, Mar ....

I looked on the EPPlus website and to get in for questions or answers, you must be a paying member. I am new to this, so I would need my handheld.

It's an Excel Histogram chart with a monthly series for the X axis and persons and households for the second and third series.

You were right; I found it in an if statement. I don't know how many times I looked there and did not see it.

Thank you

It almost works, but I get a

Compiler Error CS0161, method': not all code paths return a value

The code is long, so I will include what I think you need.

All the variables are declared and set in the code.

        
        //public (bool, bool, string) VerifyDate(string thisDay, object[] status)
        public Tuple <bool, bool, string> VerifyDate(string thisDay, object[] status)

                
                //status[3] = (dateError, dateNotValid, outDate);
                var retruneArray = new Tuple<bool, bool, string>(dateNotValid, dateError, outDate);

                return retruneArray;
                //return var retruneArray = new Tuple <bool, bool, string>(dateError,dateNotValid,outDate;
                //return status;
                //return ((bool, bool, string))(status[3] = (dateError, dateNotValid, outDate));

Tried, and it still does not work. It was worth a try.

Just something I tried, but of course, it was looking for an array. I put them back to ().

frmFoodPantry is the main program, and theWorkbook is assigned on the open statement.

I looked over that article and managed to get the dialog to show but found no way of setting the print on one page. I also looked over all the printer .net documents and found nothing. I really don't want to make the user to print everything manuly but maybe what I want can't be done. There has to be some way.

Tried that several times with the same results.

Besides the open statement, what other statement, would create a new instance? From what I have read and understand, the second instance is read-only.

Although I have some programming background, I am new to all this with C#. So sorry if this is real basic.

I put a breakpoint on the line in question and on what I think is the constructor. The second excel file is opened after

frmRegisterInput pantryForm = new frmRegisterInput();

is executed

and before

private System.ComponentModel.IContainer components = null;


namespace RegisterInput
{
partial class frmRegisterInput
{
///

/// Required designer variable.
///

private System.ComponentModel.IContainer components = null;

///

/// Clean up any resources being used.
///

/// <param name="disposing" />true if managed resources should be disposed; otherwise, false.
protected override void Dispose(bool disposing)


It is not making any sense to me.

The file is now ok, I need to get back to the code to see how that is doing now. I took a break from that segment of the code to work on another section.

No, I haven't. I put it on the back burner for a little bit because I was getting too frustrated with it and was going in circles. I am working on another part of the code and will get back to this when that is done. I am sure I will post in this or start another question when I do.

The code is

private void SetChartAxis(int newRow)
{
Excel.Chart chart;
frmFoodPantry.objApp.Visible = false;
Excel.Worksheet theWorkSheet;
theWorkSheet = (Excel.Worksheet)frmFoodPantry.theWorkbook.Worksheets.get_Item(ShRegister);
theWorkSheet.Activate();

//diaable the alearts
frmFoodPantry.objApp.DisplayAlerts = false;
Excel.Sheets sheets = frmFoodPantry.theWorkbook.Worksheets;
Excel.Worksheet totalWorksheet = (Excel.Worksheet)frmFoodPantry.theWorkbook.Worksheets["Sheet1"];
string temp1 = theWorkSheet.Name;
totalWorksheet.Activate();
//Unprotect the Totals sheet
totalWorksheet.Unprotect();
// Access Bar chart

int chartcount = theWorkSheet.ChartObjects().Count;

chart = totalWorksheet.ChartObjects("ChartTotals");

string temp3 = chart.Name;

chart.SeriesCollection("HouseHolds").Delete();
//chart.SeriesCollection(2).Delete();

if (!isNewYear)
{
//chart.SeriesCollection(3).Delete();
chart.SeriesCollection(2).Delete();
}
chart.SeriesCollection().NewSeries();
//name series for the number of familes series as "HouseHolds"
chart.SeriesCollection(1).Name = @"=""HouseHolds""";
chart.SeriesCollection(1).Format.Line.ForeColor.RGB = (int)Excel.XlRgbColor.rgbRed;

chart.SeriesCollection().NewSeries();
//namenumber of people as "People"
chart.SeriesCollection(2).Name = @"=""People""";
chart.SeriesCollection(2).Format.Line.ForeColor.RGB = (int)Excel.XlRgbColor.rgbBlue;

chart.SeriesCollection().NewSeries();
//name the new series as "Series 3"
chart.SeriesCollection(3).Name = @"=""Series3""";

if (isNewYear)
{
//name the new series as "Series 3"
chart.SeriesCollection(3).Name = @"=""Series3""";
}
else
{

}

//switching off the alerts
frmFoodPantry.objApp.DisplayAlerts = false;
//Set series 1 to be equal to the number of familes
chart.SeriesCollection("HouseHolds").Values = @"=Totals!$C$3:$C" + newRow;

//Set series 2 to be equal to the number of people in the family
chart.SeriesCollection("People").Values = @"=Totals!$D$3:$D" + newRow;

//Set the title axis to be the dates
chart.SeriesCollection(3).XValues = @"=Totals!$B$3:$B" + newRow;

//switching off the alerts
frmFoodPantry.objApp.DisplayAlerts = false;
frmFoodPantry.theWorkbook.SaveAs(RegGlobals.excelFileName);
//switching on the alerts
frmFoodPantry.objApp.DisplayAlerts = true;

totalWorksheet.Protect();
//End of SetChartAxis
}


On the line chart = totalWorksheet.ChartObjects("ChartTotals");

When I use a number, I get a com error.
When I use a string, I get: 'The item with the specified name wasn't found.'

I have made a new excel workbook from scratch.
The sheet name is Sheet1, as it should be.
The number of charts is 1.

I am just creating the sheet, and the code will follow. I need to get the bar chart set up so I can use it.

You were a lot of help.

I am going to redo the complete workbook, including the graph. I am hoping the workbook is corrected, and that will fix it.

I am having a problem with Office 2022, which I did not have in Office 2010.

I will make that another question.

shapes.count = 0

It turns up 0 charts, so I rebuilt the excel sheet, and it still turns 0.

When I set the value of Excel.Worksheet totalWorksheet = (Excel.Worksheet)frmFoodPantry.theWorkbook.Worksheets[1];

It still turns up 0

I looked at the sheet, and there is definitely a chart there.

The first I have already read, and it did not help much.
The second I just tried, and no change.

In the main form:
using RegGlobals = FoodPantryGlobals.GlobalConst;
using NewMonth;
using NameSearch;
using GetDataSheets;

The calling routine in the main form:
private void cmdOpenDataSheets_Click(object sender, EventArgs e)
{
this.Hide();
frmGetDataSheet pantryForm = new frmGetDataSheet();
pantryForm.Show();
}

In the other forms:
using RegGlobals = FoodPantryGlobals.GlobalConst;
using Food_Pantry;


I have moved the declaration and assignment of theWorkBook out of the FoodPantryGlobals and into the main program frmFoodPantry. With the same results.

I am not sure what other code to include. Please tell me if you need more.

That worked; I did a copy-paste from the form name and had to add a using statement. So it works now.

Yeah, I found out it was case-sensitive the hard way.

How do I declare it as a class when I have already brought the code into the main project?

I know this is a newbie question, and I should know it.

That was a coding error, and it should be FrmNewMonth. FrmNewMonth is a .exe project that was added using the 'Project.Add reference'. I know that this changes the original question, should I let this one be closed and ask it again?

I entered the code

//this.Hide();
FrmNewMonth pantryForm = new FrmNewMonth();
pantryForm.Show();
//Application.EnableVisualStyles();
//Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new frmFoodPantry());

And I get a build error.
CS0246 Type or Namespace name 'FrmNewmonth' could not be found.
I have added the form and its code to the project, which shows up under references.

That won't work because the time the second .exe file runs depends on the operator.