Current Position:Home > Webi export to excel misaligned border free cell

Webi export to excel misaligned border free cell

Update:11-30Source: network consolidation
Advertisement
Hi
I'm using Webi XI 3.1 SP3 FP 3.3.
I've a report in which I've put border using a Free standing cell. When I export this report in Excel format (browser/rich client), the border comes as empty at the start of the excel and after which the report blocks/data come.
Why is this happening?
Thanks
Deep

The Best Answer

Advertisement
hi Deep,
Blank Cell is not treated as block.
Whereas Chart and tables are treated as blocks.
Hence the relative positioning between the blocks is preserved.
But not blank cell.
This can be observed by looking at properties tab of Chart/Table. You will see 'name' as block
But this doesn't holds good for Blank cell.
That's the reason Excel treats it as a separate entity.
Regards,
Vamsee
  • Webi export to excel misaligned border free cell Update:11-30

    Hi I'm using Webi XI 3.1 SP3 FP 3.3. I've a report in which I've put border using a Free standing cell. When I export this report in Excel format (browser/rich client), the border comes as empty at the start of the excel and after which the report bl

  • Webi export to excel having issues. Update:11-30

    Hi, I have a webi report which generates 62 mb excel file when exported to excel. It can be saved to excel without any error but when we open the excel report it shows the error that there are some damage done to report and excel is trying to recover

  • Bex Web - Export to Excel / Export to PDF Update:11-30

    Hi gurus, Using BI-IP. In a web-template, I use the function "Export to Excel 2000" (or "Printable version", which generates a PDF file). The function works, except that at detailed level there is no data for input-ready columns. Is it

  • How to list all reports created in webi - export to excel or print Update:10-11

    We are using BO 3.1, is there a way to list all reports and print or export the information to excel?  instead of navigating through each folder structure. JohnHi, If you have auditing enabled in the environment, please login to InfoView and select "

  • Cells merge issue when extracting webi report in excel format Update:10-11

    Hi Experts, We have some WEBI reports in BO XI 3.1. The reports have header where we are showing report name and some values which user selects in prompt. Now the issue is that when we save our webi report in excel format, many cells get merge. I hav

  • Problem in Exporting Webi Report to Excel Update:10-11

    Hi, I have developed a WEBI report in BOBJ 4.1 SP1 on top of IDT Universe and applied Drill Down analysis. While exporting the WEBI Report to Excel, I'm getting Images in the place of columns where there is no data. However, images are not getting in

  • Export to Excel is not working for List View Web Part after filtering using Query String parameters in SharePoint 2010 Update:10-11

    Hi,  I am filtering SharePoint list view web part based on Query string parameter and I am doing Export to Excel by using following code. <a href="#" onclick="javascript:window.location='../_vti_bin/owssvr.dll?CS=109&Using=_layouts/q

  • Web Intelligence export to Excel misses some fields Update:10-11

    Hi, Our system is running BusinessObjects Enterprise XI 3.1 with SP3 (no fix packs).  The behavior I'm seeing is when exporting a particular Webi doc to Excel.  Here is some background info for the document I am attempting to export to Excel. The doc

  • Webi reports - Problem exporting to excel Update:11-30

    HI, I have exported a webi report as an excel file. The report contains a column with numeric values preceded by a dollar sign. After exporting to excel, i want to calculate the sum of the values in that column. However some cells show a numeric valu

  • Problem when exporting Query from Web template to Excel Sheet. Update:11-30

    Hello, Im encoutering a problem when im trying to export query output from web template to excel sheet. A popup windown appears when excel sheet opens which reads.."problem cameup in the following areas during  load : Cell Value".The report layo