SelectionStampInBIFFExport=1 in QV Server 12.20

[steeefan]

Hey everyone,

I'm in the process of moving to a new machine and also upgrading from 11.120 to 12.20. The only thing I'm missing and can't get to work is to have the selections at the end of an Excel sheet when exported from an app.

I did as I did on my old server (and is also described here) and added to C:\ProgramData\QlikTech\QlikViewServer\settings.ini the following line (03):

[Settings 7]
...
SelectionStampInBIFFExport=1
...
[Authentication]
...

After restarting the server service it still does not work. Has anyone encountered this before? I can't get this to work but really need it.

Thanks,

-Stefan

[Anil_Babu_Samineni]

Can you try BIFF Code using Macro in Excel like, and then we can investigate or test in QlikView

Sub Macro_Export_Edit()

  Dim wb As Workbook

  Set wb = Workbooks.Open("S:\Client\Assumptions.xls", UpdateLinks:=0, ReadOnly:=False)

  wb.Sheets(1).Range("A1").Activate

  ActiveCell.Value = 1

  wb.ChangeFileAccess Mode:=xlReadWrite

End Sub

[marcus_sommer]

I could imagine that this parameter isn't valid anymore because with 12.2 the excel-default format by exporting is now xlsx and not xls. By loading data into qlik the file-format changed from biff to ooxml regarding to xls vs xlsx. You could try just replacing it within the parameter. Otherwise some hint from the qlik-side will be needed.

SelectionStampInOOXMLExport=1

- Marcus

[steeefan]

This throws a runtime error 1004 at

wb.ChangeFileAccess Mode:=xlReadWrite

when I run this sub in Excel and have Workbooks.Open() point to an actual Excel file.

Maybe I don't understand correctly what you're suggesting.

[steeefan]

Good point! I tried it with OOXML, XLSX, XLS and Excel instead of BIFF but none of those worked.

[steeefan]

I did some more testing and found that it's not working in the local client as well although it's enabled in the User Preferences. This is very troubling. Can anyone confirm?

[marcus_sommer]

Try to change this option within the local qlikview desktop client and then take a look within the settings.ini from the client - the used parameter should be listed there.

- Marcus

[steeefan]

There it's still the old one:

SelectionStampInBIFFExport=1

However, as stated below, it's also not working in the client for me.

[rwunderlich · Accepted solution]

It's not working for me either. I would take this to QT Support.

In the meantime, if you want a workaround to return to old xls method, there is a switch:

SendToExcelLegacyFormat=1

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[steeefan]

Thanks, Rob! Now I at least have selection stamps in my exports.

I'll go ahead and report this to QT Support.