umya-spreadsheet _FilterDatabase?

@MathNya Thanks for the latest version. It is MUCH better!

I'll continue to test, but it seems so far most of the issues have been resolved.

I discover a strange artifact:

Can you tell me where that _FilterDatabase come from? There doesn't seem to be a way to remove it...

Jul 06 '24 05:07 schungx

I understand that it is a named range, but I do not have that named range in my source file.

Jul 06 '24 05:07 schungx

Source file:

Output file:

Jul 06 '24 05:07 schungx

@schungx, can you please share minimal code and test excel for duplication.

Jul 07 '24 02:07 agentjill

@schungx This is a strange phenomenon. There was no string "_FilterDatabase" in the program either. I wonder where it came from.

can you please share minimal code and test excel for duplication.

We would very much appreciate your response here.

Jul 08 '24 08:07 MathNya

can you please share minimal code and test excel for duplication.

We would very much appreciate your response here.

No prob. Sorry I'm travelling. Will do that tonight when I get to hotel.

Jul 08 '24 08:07 schungx

xxx.xlsx

output.xlsx

output is simply a read-write of xxx.

If you load output in Excel, it'll complain about errors in cells (probably due to the formula).

You can also see the _FilterDatabase range.

Jul 08 '24 13:07 schungx

@schungx, there is a _FilterDatabase in original file (xxx.xlsx) the same is written to output file (output.xlsx) as

Jul 08 '24 15:07 agentjill

Ah, the original file has hidden="1". That's why it isn't showing up.

The output file does not have this attribute.

Jul 09 '24 00:07 schungx

@schungx, the mystery of _FilterDatabase is now solved, now it needs to be investigated why the definedName element name is placed in the background in that range?

Jul 09 '24 00:07 agentjill

@schungx, the mystery of _FilterDatabase is now solved, now it needs to be investigated why the defined name element name is placed in the background in that range?

This is resolved. It turns out that Excel automatically displays the range's name (in bold large text to add injury) as a watermark over the range if the zoom level is below 40%. Seems to be standard Excel behavior.

Jul 09 '24 04:07 schungx

@schungx @agentjill Thank you for your confirmation. We will address the issue of the disappearance of the hidden attribute in the next update.

Jul 09 '24 09:07 MathNya

The latest version has been released. Please check to see if any problems have been resolved.

Aug 04 '24 07:08 MathNya