Icon

Replicating Spreadsheet Import Bug: Face Value Update Issue

Learn how to replicate a bug where importing different spreadsheets causes face value not to update properly, using spreadsheets with one million and 500,000 entries.

By Brandon Donkersgoed

In this guide, we'll learn how to replicate a specific bug related to spreadsheet imports, where the face value does not update correctly when a new spreadsheet is imported. This process involves using two separate spreadsheets with different values. By following the steps, you will understand how the bug manifests and affects the displayed data. This knowledge can be useful for debugging and improving data handling in spreadsheet applications.

Let's get started

We will replicate the bug where importing a spreadsheet and then importing a different one later causes the face value not to update properly.

2
Click on "+Whole Life"
Step #2: Click on "+Whole Life"

To accomplish this, we have two separate spreadsheets for the company: one with one million face valueand another with 500,000. First, I'll import the 500,000-entry spreadsheet.

3
Click here
Step #3: Click here

As we can see, it shows 500,000 under the insurance benefit.

4
Click here
Step #4: Click here
5
Click here
Step #5: Click here

If I open this in a new tab, it shows 500,000 here.

6
Generate the report
Step #6: Generate the report
8
$500,000
Step #8: $500,000

Now, I'm going to import a new spreadsheet over the existing one.

10
Click here
Step #10: Click here
11
Click here
Step #11: Click here

If I click here, it still shows 500,000.

12
Click here
Step #12: Click here
13
Click here
Step #13: Click here

It still shows 500,000 here as well.

14
Click here
Step #14: Click here
16
Click here
Step #16: Click here

Replicating Spreadsheet Import Bug: Face Value Update Issue