CODEWITHSUNDEEP
excelexport-to-excellistlabel
tonirush
tonirush

Reputation: 430

Export a List&Label table with formula to Excel

I have an existing List&Label report containing a table with three columns:

col1 = valueA
col2 = valueB
col3 = valueA + valueB

When exporting these list to excel, the resulting excel table contains only values in all three columns.

Example export:

enter image description here

I tried to enter the formula for col3 as text, but then Excel also interpreted it as text.

enter image description here

Is there a way to export the table with List&Label to Excel, so that I have a working formula in excel?

Upvotes: 1

Views: 149

Answers (2)

DaPeppi
DaPeppi

Reputation: 60

I'm new to List & Label and I'm evaluating it currently for further use. While my research to the product I found this article which describes new feature within the export format to Excel and meanwhile formulas are supported in the latest version - look there: Generating Excel Formulas in Worksheets

Upvotes: -1

JBartlau
JBartlau

Reputation: 802

Unfortunately - no. As List & Label has its own formula language that isnt't entirely translateable to Excel, there is no layer for this purpose - all values are exported as is. I'd export just columns A and B and add the formula to the resulting sheet. If this is something you need to do often/automatically, you could use VBA to post process the sheet. Here is a primer how to do that.

Upvotes: 1

Related Questions