Report (PDF) Header Background Fill Color Not Extending to Bottom of the Space
The background fill color on the header is not filling the entire space when viewed in PDF. You can see on four of the six columns there is white space where the text is shorter. I need the teal color to fill to the bottom of the header space, and not just exist where the text is located. It works fine in excel and cube view. The issue only exists in report PDFs. Does anyone know of a way to accomplish this? Report/PDF: Excel: Cube View: Here's an example of a PDF that looks good because the length of the header text is more comparable across the columns: I'm sure there's a way to accomplish this through a Custom Report Formatting rule or formula. I'm trying to avoid this, as I feel the formatting should already default to what I want. But, if I have to go this route, I will. Thanks in advance!CVR and GetDataCell Issue in cube views
Hello, I currently have a cube where I am having an issue calculating variances. The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12). When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell. I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?
Saving Offline Copy
My team has recently been unable to save offline copies of Excel files that contain XFGetCells + CubeViews. Prior to this, we had no issues and had saved 100+ files offline as part of quarterly reporting. I have seen prior threads where this has been discussed some time ago, and our team has tried updating preferences, saved elsewhere, etc. with no luck. Is anyone else currently having this issue?ReportBackgroundColor not filling the entire cell when viewing the report as a PDF
Hi, I am encountering an issue with the header format of the 'Total' row below where the ReportBackgroundColor is not filling the entire cell when viewing the report as a PDF. There is no issue when viewing view the cube view or Excel. Below is the header formatting we're suing: ELSE IF (RowName Contains ':Total:') THEN ExcelBottomBorderColor = Black, ExcelTopBorderColor = Black, ExcelTopBorderLineStyle = Thin, Italic = True, ReportBackgroundColor = Gray, ReportUseBottomLine1 = True, ReportUseTopLine1 = True I'm using the same formatting for Header and Cell Format but as you can see from the screenshot below, there is a blank space below Total. Has anyone encountered this?Linking external Excel Spreadsheet to cube view input spreadsheet
Hi all, I'm building a cube view which includes pre-filled columns including 12 months for CY budget, PY actuals and columns for YTD actuals. Additionally, I have included all future months in the year to be for the Forecast scenario for users to input. I have embedded this cube view into a spreadsheet form, so that users can either directly enter their forecast numbers into the spreadsheet in OS app, or it can be opened in Excel for users to complete outside the system. When I open the file in Excel, the CV correctly works and refreshes, and submission correctly writes the cells back to Onestream when FCT1 numbers are entered. However, I am stuck on one thing - is there a way to update the Cube View form cells by referencing other cells in another spreadsheet, or in the workbook? I can link 1 cell individually, but once I reference the cell, it automatically converts to a number and I cannot autofill any formula link to the remaining cells. Most users will either be wanting to link to the budget numbers and adjusting those, or workings they have in their own spreadsheets. I know another option is to use setcells, but I am trying to avoid this method if possible for this purpose. Happy to hear of any thoughts, maybe I'm missing something simple. Able to link 1 cell: Converts immediately to a number and unable to drag cell reference down: Thanks Andrew
