1. Hugo Moors
  2. PowerBuilder
  3. Monday, 24 February 2020 09:49 AM UTC

Empty fields get spaces when exporting XLSX! in PB2019 not in PB2017

There are also no spaces when exporting Excel8!

Create an external datastore d_testemptyxlsx with 1 string field

datastore lds_test
Long ll_row

lds_test = CREATE datastore
lds_test.dataobject = 'd_testemptyxlsx'
ll_row = lds_test.insertrow( 0 )

lds_test.SaveAs( "C:\Temp\testxlsx.xlsx" , XLSX!, FALSE )
lds_test.SaveAs( "C:\Temp\testexcel8.xls" , Excel8!, FALSE )

DESTROY lds_test

(Copy/Past field A1 into a text editor)

In Excel the XLSX file testxlsx.xlsx field A1 will be "    "

In the XLS file testexcel8.xls field A1 will be ""

In PB2017 field A1 is "" in both Excel8 and XLSX

This is blocking our applications from being converted to PB2019

 

 

Accepted Answer
Hugo Moors Accepted Answer Pending Moderation
  1. Thursday, 5 October 2023 05:43 AM UTC
  2. PowerBuilder
  3. # Permalink
It is fixed in PB2019 R2 Build 2328
Comment
  1. Armeen Mazda @Appeon
  2. Friday, 6 October 2023 15:40 PM UTC
Thanks for letting us know and updating status of your post!
  1. Helpful
There are no comments made yet.
Erling Kjerland Accepted Answer Pending Moderation
  1. Monday, 18 May 2020 16:23 PM UTC
  2. PowerBuilder
  3. # 1
I have come across this same problem i PB 2017 R3 build 1915. Is there any chance this problem will be fixed there?
Comment
  1. Erling Kjerland
  2. Tuesday, 19 May 2020 08:36 AM UTC
Ok. Thanks.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 24 February 2020 19:54 PM UTC
  2. PowerBuilder
  3. # 2

Hi Hugo;

   I have now verified your issue in ticket #4155 (thank you for pointing out this anomaly and opening this ticket).

Note: This is also the case in PB2019 R2.

Regards ... Chris

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 24 February 2020 10:00 AM UTC
  2. PowerBuilder
  3. # 3

Hi, I see you already reported it as a bug. Thank you.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.