Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Save as Excel5 gives cells with wrong length

  1. Issue
0
Votes
Undo
  1. D Aggelis
    D Aggelis
  2. PowerBuilder
  3. Wednesday, 29 March 2023 09:16 AM UTC

Hi,

we've just moved to Appeon from PB 11.2 and we have an issue with Saveas Excel5!. Cells with text content appear to have length +1 than the real size, e.g. cell A1 contains ABCD and len(A1) gives 5 instead of 4. This is a problem because our users use functions like Right() and take wrong results, e.g. right(A1; 2) gives D instead of CD. This was working as expected in PB 11.2.

Any ideas; (Save as xlsx works but many programs have as default Excel5!)

 

DataWindow Merge Conflicts and how to solve them
Anyway to go back to previous runtime version?
Accepted Answer
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 31 March 2023 12:21 PM UTC
  2. PowerBuilder
  3. # Permalink
Yes, I think you're right on that one. Why not use XLSX format? (It is a bit slower though, that's true). regards.
Comment
There are no comments made yet.
Responses (3)
D Aggelis
D Aggelis Accepted Answer Pending Moderation
  1. Wednesday, 29 March 2023 11:18 AM UTC
  2. PowerBuilder
  3. # 1

Ηι,

thank you for your answer.

It is not the initial quote since the problem is in right() not in left().

Thankfully Excel8! and Excel12! seem to work as expected.

 

 

 

 

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 29 March 2023 10:59 AM UTC
  2. PowerBuilder
  3. # 2

Hi,

I think the difference might be that now, in later PB or windows versions, it's also counting the initial single quote in a text cell.

Excel5! which version is that? Can't you upgrade to a somewhat newer version of Excel?

That's 1993 ! You do get an easter egg of being able to play a mini Doom game :)

 

"

Excel 5.0 (1993)

With version 5.0, Excel has included Visual Basic for Applications (VBA), a programming language based on Visual Basic which adds the ability to automate tasks in Excel and to provide user-defined functions (UDF) for use in worksheets. VBA includes a fully featured integrated development environment (IDE). Macro recording can produce VBA code replicating user actions, thus allowing simple automation of regular tasks. VBA allows the creation of forms and in‑worksheet controls to communicate with the user. The language supports use (but not creation) of ActiveX (COM) DLL's; later versions add support for class modules allowing the use of basic object-oriented programming techniques.

The automation functionality provided by VBA made Excel a target for macro viruses. This caused serious problems until antivirus products began to detect these viruses. Microsoft belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate.

Versions 5.0 to 9.0 of Excel contain various Easter eggs, including a "Hall of Tortured Souls", a Doom-like minigame, although since version 10 Microsoft has taken measures to eliminate such undocumented features from their products.[100]

5.0 was released in a 16-bit x86 version for Windows 3.1 and later in a 32-bit version for NT 3.51 (x86/Alpha/PowerPC)

"

regards.

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.