Search found 10 matches

Go to advanced search

by maseline_98
Tue Dec 09, 2014 5:56 pm
Forum: XLSReadWritwII 6
Topic: Problem with Page Breaks
Replies: 1
Views: 1775

Problem with Page Breaks

XLS[SHEET].PrintSettings.PrintTitles(-1, -1, 0, 0); with XLS[SHEET].PrintSettings.VertPagebreaks.Add do begin col := 0; Row1 := 280; Row2 := 65535; end; XLS[SHEET].WorkspaceOptions := [woFitToPage]; XLS[SHEET].PrintSettings.FitWidth := 1; XLS[SHEET].PrintSettings.FitHeight := 500; I'm trying to get...
by maseline_98
Tue Nov 11, 2014 4:10 pm
Forum: XLSReadWritwII 6
Topic: Three Problems with 5.10.05
Replies: 5
Views: 3865

Re: Three Problems with 5.10.05

pl00 wrote:Thanks - that nailed it.

How did you resolve the autoWidthCols? It's not seeming to work for me.

Code: Select all

   
 NUM_FORMAT = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)'; 
AutoWidthCols(0, LAST_COL);
Range.Items[DISC_COL, 0, LAST_COL, iRow].NumberFormat := NUM_FORMAT;
by maseline_98
Mon Nov 10, 2014 8:12 pm
Forum: XLSReadWritwII 6
Topic: HeaderFooter Page numbers?
Replies: 1
Views: 1866

Re: HeaderFooter Page numbers?

Nevermind....found the answer in the XLSSheetData5 unit:

For anybody else looking it is:

Code: Select all

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '&P of &N';
by maseline_98
Mon Nov 10, 2014 7:54 pm
Forum: XLSReadWritwII 6
Topic: HeaderFooter Page numbers?
Replies: 1
Views: 1866

HeaderFooter Page numbers?

I was trying to get the page numbers to print, but there seems to problem: XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '&[Page] of &[Pages]'; The result: 'Page] of Pages]'. The strange thing is that if I open the header in excel and click on it, then it displays the page numbers. I ha...
by maseline_98
Mon Aug 12, 2013 7:29 pm
Forum: XLSReadWritwII 6
Topic: Formulas are not populating
Replies: 0
Views: 2444

Formulas are not populating

We recently upgraded from v4.00.46 to v5.10.28. Sometimes(doesn't seem to happen every time) when we create a .xlsx(haven't tried .xls), our formulas do not add up. They are displayed. If you open the file in Excel, click on the cell, press F2 and enter, the totals are populated. What is going on wi...
by maseline_98
Tue Mar 26, 2013 3:22 pm
Forum: XLSReadWriteII 3/4/5
Topic: Print Options not working in xv2007 format
Replies: 5
Views: 13408

Re: Print Options not working in xv2007 format

Has this been resolved? I can't seem to get this to work in v4.00.67.
by maseline_98
Wed Oct 10, 2012 2:05 pm
Forum: XLSReadWriteII 3/4/5
Topic: Support for the last version
Replies: 4
Views: 5417

Re: Support for the last version

I upgraded to the latest version of v.4.00.65a. Why do my spreadsheets have "XLSReadWriteII Copyright(c) 2010 Axolot Data" at the top? I was also wondering if the Source is available for this version. We have the Source for the previous version. Edit: I'm guessing that I downloaded it from...
by maseline_98
Fri Sep 28, 2012 1:25 pm
Forum: XLSReadWriteII 3/4/5
Topic: xvExcel2007: 'Cell is missing/is of wrong type' exception
Replies: 3
Views: 5033

Re: xvExcel2007: 'Cell is missing/is of wrong type' exception

Here is my call stack: FormulaHandler4.TFormulaHandler.GetAsFormulaEx12(???,0,2) SheetData4.TSheet.GetAsFormulaEx12(???,???) XLSWriteXML4.WriteFormula XLSWriteXML4.WriteSheet(0) XLSWriteXML4.TXLSWrite2007XML.WriteSheets($20A57F0) XLSWriteXML4.TXLSWrite2007XML.SaveToStream($20A5450,???) XLSReadWriteI...
by maseline_98
Fri Sep 28, 2012 1:10 pm
Forum: XLSReadWriteII 3/4/5
Topic: xvExcel2007: 'Cell is missing/is of wrong type' exception
Replies: 3
Views: 5033

Re: xvExcel2007: 'Cell is missing/is of wrong type' exception

My version is:
4.00.05

The only thing I can think of is maybe my version is somehow corrupted or I have an older version. I also had another programmer(he has the same version as I) try to compile and run it and he is getting the same result.
by maseline_98
Thu Sep 27, 2012 8:04 pm
Forum: XLSReadWriteII 3/4/5
Topic: xvExcel2007: 'Cell is missing/is of wrong type' exception
Replies: 3
Views: 5033

xvExcel2007: 'Cell is missing/is of wrong type' exception

I get a 'Cell is missing/is of wrong type' exception for any formula I try to use while using xvExcel2007. I'm using delphi 2007. Any reason for this? We have been using the xvExcel97 version with no issue, but it appears some of our clients want the most recent file extension(.xlsx). I thought mayb...

Go to advanced search