I am trying to get row height for some area of template. Using
Code
AreaTemplate.Areas.Totals.RowHeight
i get 0 no matter that AutoRowHeight is false.
How could I find out the size of some template area in mm, and the size of filled template area before putting it to the result document? I need to calculate the quantity of products which could enter one page (or some predefined area).
--- addition
It seems like if you set Height directly for area it stays set, and you can get this from code, but if you set 3 lines of one area in a template (all the lines) then RowHeight for the area will not be set.
I am also wondering how to get RowHeight for the line which have AutoRowHeight, but already was filled with data and putted to resulting Spreadsheet.
> I need to calculate the quantity of products which could enter one page Usually for this problem the method "CheckPut" of SpreadsheetDocument is using. Maybe it help to you
No this wont help. I need to calculate how many lines would enter some area and then put them into this area and make the next line exactly how it was designed in template.
You need to check if your row with footer will fit the page or not. If not you will have to put it on the next page. See M15 or TORG12 print form generation in PrintForm() procedure of manager module of Sales Invoice document of the application as an example.
There is nothing that could help me to put footer exactly where I want.
I also looked up for some functions which may help. Document have header and footer which could contain this information:
Quote
This may be used to access the spreadsheet's header and footer. header and footer is special text that is placed at the top or bottom of each page when a document is printed. The following control structures can be used in the header and footer text: [&PageNumber]- a page number will be printed on this part of the page; [&PagesTotal] - total number of pages will be printed on this part of the page; [&Date]- the current date will be printed on this part of the page; [&Time]- the current time will be printed on this part of the page,
Correct me if I wrong but I can not define custom template for Document footer.
I really need that some fields are exactly in the defined space. Here, there are a lot of document templates which should be filled by printing. So I have some area in the middle of document which is a space for goods. No matter how much goods I have the footer should always be at the same position, at the bottom of the page.
I tried this technique, but it seems not work in 8.3
Code
TempSD = New SpreadsheetDocument;
Area.Parameters.BaseImponible = "100";
Region = TempSD.Put(Area);
Nota = TempSD.Drawings.Add(SpreadsheetDocumentDrawingType.Text);
Nota.Place(Region);
Message(Nota.Height);
Return Nota.Height;
My suggestion is that you use the described technique but divided into 2 steps. First, output table rows with data. Stop when the current table row together with the footer does not fit the page. Second, output empty rows with 1mm height. Stop when the current empty row together with the footer does not fit the page, then output the footer.
You will have precision of 1mm. Guess this will help.
Here is the example:
Code
&AtClient
Procedure Print(Command)
SpreadsheetDocument = PrintServer();
SpreadsheetDocument.Show();
EndProcedure
&AtServer
Function PrintServer()
Result = New SpreadsheetDocument();
DataProcessor = FormAttributeToValue("Object");
Template = DataProcessor.GetTemplate("Template");
Header = Template.GetArea("Header");
Row = Template.GetArea("Row");
Compensator = Template.GetArea("Compensator");
Footer = Template.GetArea("Footer");
Result.Put(Header);
RowsToCheck = New Array();
RowsToCheck.Add(Row);
RowsToCheck.Add(Footer);
While Result.CheckPut(RowsToCheck) Do
Result.Put(Row);
RowsToCheck.Clear();
RowsToCheck.Add(Row);
RowsToCheck.Add(Footer);
EndDo;
RowsToCheck.Clear();
RowsToCheck.Add(Compensator);
RowsToCheck.Add(Footer);
While Result.CheckPut(RowsToCheck) Do
Result.Put(Compensator);
RowsToCheck.Clear();
RowsToCheck.Add(Compensator);
RowsToCheck.Add(Footer);
EndDo;
Result.Put(Footer);
Return Result;
EndFunction
